In office
Not Available
About the job
Job Title: Snowflake Architect – SAP Integration
Location: Boise, Idaho 100% Onsite
Employment Type: Contract (12 months)
Job Summary
We are seeking an experienced Snowflake Architect with strong SAP integration and data architecture expertise to design, develop, and implement scalable enterprise data solutions. The ideal candidate will have hands-on experience integrating SAP source systems with Snowflake, building modern data pipelines, and designing cloud-based data warehouse solutions to support enterprise reporting, analytics, and business intelligence.
The candidate should possess strong knowledge of SAP data structures, data extraction, transformation, data modeling, and Snowflake architecture, along with the ability to collaborate with business stakeholders, SAP functional teams, and data engineering teams.
Key Responsibilities
Design and implement scalable data architecture and enterprise data warehouse solutions using Snowflake.
Architect end-to-end data integration solutions between SAP systems and Snowflake.
Integrate data from SAP ECC and SAP S/4HANA, including relevant SAP modules such as FI/CO, MM, SD, or PP, based on business requirements.
Design data ingestion, transformation, and loading pipelines from SAP into Snowflake using suitable ETL/ELT tools.
Develop and optimize Snowflake objects, including databases, schemas, tables, views, virtual warehouses, and secure data-sharing solutions.
Implement data modeling strategies, including dimensional modeling, star schemas, and enterprise data models.
Work with SAP extraction and replication technologies such as SAP SLT, SAP ODP, SAP Data Services, or SAP Datasphere, as applicable.
Leverage integration tools such as Informatica IDMC/IICS, SAP Data Services, Fivetran, Matillion, or equivalent platforms.
Optimize Snowflake query performance, warehouse utilization, and data processing costs.
Establish data governance, security, access controls, data quality, and metadata management standards.
Collaborate with SAP functional consultants, data engineers, BI developers, and business stakeholders to translate requirements into technical architecture.
Lead technical design discussions, architecture reviews, documentation, and implementation best practices.
Required Skills
Strong hands-on experience with Snowflake architecture and cloud data warehousing.
Proven experience integrating SAP data with Snowflake.
Strong knowledge of SAP ECC and/or SAP S/4HANA data structures and extraction methods.
Experience with ETL/ELT pipelines and data integration tools.
Proficiency in SQL and Snowflake performance optimization.
Experience with data modeling, data warehousing, and enterprise data architecture.
Knowledge of cloud platforms such as AWS, Microsoft Azure, or Google Cloud.
Experience with data governance, security, and data quality practices.
Strong communication, problem-solving, and stakeholder management skills.
Preferred Qualifications
Experience with SAP Datasphere, SAP BW/4HANA, SAP SLT, SAP ODP, or SAP Data Services.
Experience with Informatica IDMC/IICS, Fivetran, Matillion, or similar data integration platforms.
Knowledge of SAP business processes across Finance, Supply Chain, Procurement, Manufacturing, or Sales.
Experience with dbt, Python, CI/CD, and automated data pipeline deployments.
Snowflake certification or relevant SAP certification is an advantage.
