Data Architect

About The Role:

As a Data Architect at ROI Solutions, you will play a critical role in leading the migration from legacy systems to Snowflake and ensuring we design a future-ready data platform in the process. This role is focused on internal collaboration rather than direct client interaction, and your work will directly support the strategic objectives of ROI Solutions. You will work closely with internal stakeholders to ensure that the architecture you design not only meets today's requirements but also anticipates and supports future business needs, in alignment with ROI's mission to empower nonprofits. 

What You Will Be Doing In This Role: 

• Lead the migration from legacy data tools (Oracle, Redshift, Windows services, and Glue) to reimagined toolset (Snowflake, DBT, Fivetran, etc). Ensuring minimal disruption and maximum data integrity throughout the process. 
• Architect and design a scalable, secure, and efficient data platform on Snowflake that aligns with ROI Solutions' strategic goals and the mission of supporting nonprofits.  
• Collaborate closely with internal teams to understand business needs, translating them into technical solutions that support both current and future objectives.  
• Optimize data models, ETL/ELT processes, and data pipelines to enhance performance, scalability, and cost-efficiency within the Snowflake environment.  
• Implement and maintain robust data security measures, including encryption, access controls, and compliance with relevant regulations, particularly within the context of nonprofit data needs.  
• Provide technical leadership and mentorship to team members, fostering a culture of continuous improvement, innovation, and strategic thinking.  
• Conduct architectural reviews and recommend strategic improvements to ensure long-term success and alignment with ROI’s mission.  
• Document and communicate architectural decisions, migration processes, and strategic plans clearly to both technical and non-technical stakeholders. 
• Travel for in-person work meetings and company gatherings is required (very infrequent).

What You Bring To The Table: 

• Extensive experience (5 years) in data architecture, with a strong focus on Snowflake and aligned cloud data solutions, particularly within AWS. 
• Proven track record in migrating from legacy platforms such as Oracle, Redshift, and Glue to Snowflake and adjacent technologies, with an emphasis on ensuring smooth transitions and data integrity.
• Expertise in AWS services, particularly in the context of Snowflake integration, performance optimization, and security. 
• Proficiency in SQL, data modeling, and ETL/ELT processes, with a focus on creating efficient and scalable data pipelines. 
• Experience with data integration tools such as Fivetran and DBT, particularly in migration and future-oriented architecture scenarios. 
• Strong knowledge of data governance, security, and compliance, especially as it pertains to nonprofit data management. 
• Excellent problem-solving skills with the ability to think strategically and architect solutions that anticipate future needs. 
• Strong communication skills, with the ability to articulate complex technical concepts and strategic visions to a diverse audience. 
• Bachelor’s degree in Computer Science, Information Technology, or a related field. Master’s degree preferred. 

Other Nice to Have Qualifications:

• Prior experience with Oracle databases, Redshift, and Glue, specifically in the context of migration to Snowflake. 
• Deep understanding of the strategic and operational needs of nonprofit organizations, and how data architecture can support these needs.
• Knowledge of Java, particularly in the context of data processing, integration, and supporting complex data workflows. 
• Knowledge of machine learning and advanced analytics integration with Snowflake. 
• Certification in Snowflake and AWS or other relevant disciplines. 
• Excellent interpersonal skills. 
• Excellent organizational skills and attention to detail. 
• Excellent time management skills with a proven ability to meet deadlines. 
• Proficient with Microsoft Office 365 Suite or related software preferred. 
• Ability to plan agendas, lead meetings, and convey expertise. 

PLEASE NOTE: This role is ONLY available for work in the following (21) locations: AL, AR, CO, FL, IL, KY, MA, MD, ME, MN, NC, NH, NJ, PA, SC, VA, VT, WA, WI, WV, and DC.