Data Architect (Remote, In-Office, or Hybrid)

Do you like technology and enjoy solving problems? Do you like to work with fun, smart, nerdy, and genuinely good people? Do you want to help make the world a better place by working with some of the most progressive nonprofits in the world… those who are protecting the environment, saving wildlife, curing disease, and standing up for human rights? If so, ROI Solutions is the place for you. At ROI Solutions, we have created a diverse, accepting, creative, fun, and fast-paced environment where our staff can grow, learn, and share. And most importantly, have fun while doing it.

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. 

This position has no direct supervisory responsibilities but is likely to serve as a coach and mentor for other positions in the company. 

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. 

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).
  

If you don't meet every requirement mentioned above, don't worry. We strongly believe in creating a diverse and inclusive work environment. So, if you find this job opportunity interesting but don't exactly fit every qualification mentioned in the job description, we encourage you to apply anyway. You might be the perfect candidate for this or other similar roles.

Who We Are: 

ROI Solutions was founded in 1999 to help nonprofit organizations change the world through innovative technology solutions and services. We are focused on sustainable growth, hiring staff committed to working with the nonprofit sector, and constantly evolving our technology and services to help nonprofits succeed in their missions with passion and purpose. This is our calling. 

We’re a proudly independent company, meaning we answer only to our clients rather than shareholders and investors. Our clients inspire our product and solution roadmaps, as well as our strategic direction. We’re committed to this model and the opportunity it provides us to develop our solutions based on needs in the nonprofit sector. 
 

We truly believe our clients are partners in our desire to improve the world. As a result, we work only with nonprofit organizations and socially responsible companies whose values and missions align with ours. They are the most influential and progressive organizations in animal rights & welfare, social justice & civil rights, equality, environmental protection, gun control, health & human services, and public media. We’re proud to empower their efforts and their impact. 

We constantly evaluate our products and services to ensure they evolve to meet our clients needs. Our innovative solutions and services are based on best practices that help lower costs, increase constituent involvement, improve operational efficiency, provide insights, and allow organizations to adopt new methods and approaches to their work. As a result, we embrace technological advances that significantly impact our ability to serve the nonprofit sector. 

PLEASE NOTE:  This role can be remote, in-office, or hybrid. Please Note: This role is not available for remote work in AK, AZ, CA, CT, DE, HI, IA, ID, IN, KS, LA, MI, MO, MS, MT, NE, ND, NM, NV, NY, OH, OK, OR, RI, SD, TN, TX, UT, VT, WA, WI, WY, US Territory, or any location outside of the United States.