Data Solutions Architect

Spaulding Ridge is an advisory and IT implementation firm. We help global organizations get financial clarity into the complex daily sales and operational decisions that impact profitable revenue generations efficient operational performance and reliable financial management.

At Spaulding Ridge we believe all business is personal. Core to our values is our relationships with our clients our business partners our team and the global community. Our employees dedicate their time to helping our clients transform their business from strategy through implementation and business transformation.

What You Will Do and Learn

We are seeking a highly experienced and motivated ETL Architect to lead the design development and optimization of scalable ETL pipelines and modern data integration solutions. The ideal candidate will possess deep expertise in ETL architecture data modeling and hands-on experience with industry-leading tools such as Fivetran Informatica Azure Data Factory (ADF) and Snowflake. Strong communication skills and a proven track record in team leadership and cross-functional collaboration are essential for this role.

Key Responsibilities:

• Architect design and implement robust ETL solutions ensuring scalability reliability and performance.

• Lead the development of complex ETL pipelines that extract transform and load data from multiple sources into data warehouses or data lakes.

• Ensure efficient integration of systems using tools such as Fivetran Informatica ADF and Snowflake.

• Set up and configure ETL environments including choosing appropriate tools platforms and technologies.

• Define and implement standards for ETL environments across development testing and production stages.

• Ensure all required software libraries and configurations are in place to support ETL jobs.

• Establish ETL monitoring processes and alerting mechanisms for operational support.

• Build and manage data pipelines using tools like Fivetran Informatica Azure Data Factory and Snowflake.

• Design and implement CI/CD pipelines for automated testing deployment and monitoring of ETL processes.

• Collaborate with DevOps and engineering teams to integrate ETL pipelines with version control (Git) CI/CD tools (Jenkins GitLab Azure DevOps) and testing frameworks.

• Ensure seamless integration and deployment of ETL jobs across environments (e.g. dev test prod).

• Design and implement solutions for managing SCD types 1 2 and 3 in the data warehouse.

• Ensure that data integrity and historical data tracking are maintained across changing datasets.

• Design efficient data models and data warehousing solutions optimized for Snowflake.

• Ensure data quality consistency and reliability through rigorous testing and monitoring.

• Provide technical leadership and mentorship to junior engineers.

• Coordinate with project managers and stakeholders on project scope timelines and deliverables.

Required Skills & Qualifications:

• 810 years of experience in ETL development and architecture.

• Extensive experience in designing and architecting ETL pipelines using tools such as Fivetran Informatica ADF and Snowflake.

• Proven expertise in setting up and managing ETL environments.

• Strong hands-on experience with CI/CD pipelines for automated deployment testing and monitoring of ETL processes.

• Experience working with APIs unstructured data and JSON Parquet Flat files etc.

• Deep understanding of Slowly Changing Dimensions (SCD) including implementation of SCD Type 1 Type 2 and Type 3 in the data warehouse.

• Expertise in data modeling (e.g. dimensional normalized models star/snowflake schemas).

• Strong proficiency in SQL with experience working on large-scale datasets and optimizing query performance in Snowflake or other relational databases.

• Familiarity with cloud data platforms (e.g. Azure AWS GCP) and technologies like data lakes data warehouses and big data solutions.

• Ability to lead teams mentor junior developers and collaborate effectively with business stakeholders.

• Experience with data governance and data security practices.

• Strong problem-solving skills and ability to troubleshoot complex data and performance issues.

• Experience working with applications such as Oracle ERP / SAP / Microsoft ERP / Salesforce / NetSuite / etc.

• Good understanding of data within ERP & CRM. Functional expertise in areas like Finance / Procurement / HRMS / etc.

Preferred Qualifications:

• Experience with modern data stack tools (e.g. dbt Airflow Matillion).

• Understanding of data governance privacy and compliance frameworks.

• Experience working in Agile/Scrum environments.

• Certifications in Snowflake Azure Data Factory are a plus.

Spaulding Ridges Commitment to an Inclusive Workplace

When we engage the expertise insights and creativity of people from all walks of life we become a better organization we deliver superior services to clients and we transform our communities and world for the better.

At Spaulding Ridge we believe our team should reflect the rich diversity of society and we take seriously the responsibility to cultivate a workplace where every bandmate feels accepted respected and valued for who they are. We do this by creating a culture of trust and belonging through practices and policies that support inclusion and through our employee led Employee Resource Groups (ERGs): CRE (Cultural Race and Ethnicity) Women Elevate PROUD and Mental Wellness Alliance.

The company is committed to offering Equal Employment Opportunity and to providing reasonable accommodation to applicants with physical and/or mental disabilities. If you are interested in applying for employment with Spaulding Ridge and are in need of accommodation or special assistance to navigate our website or to complete your application please send an e-mail with your request to our VP of Human Resources Cara Halladay (). Requests for reasonable accommodation will be considered on a case-by-case basis.

Qualified applicants will receive consideration for employment without regard to their age race religion national origin gender sexual orientation gender identity protected veteran status or disability.