Senior Data Engineer
Summary
Design and optimize cloud-based data pipelines and Snowflake data warehouses, building scalable ETL/ELT workflows to deliver high-quality data for analytics and business systems.
Senior Data Engineer (Snowflake)
Team: Data Engineer
Location: Chicago, Illinois, United States, Minneapolis, Minnesota, Indianapolis, Indiana, Columbus, Ohio, St. Louis, Missouri
Commitment: Remote
Workplace Type: remote
We are looking for an experienced Senior Data Engineer with strong expertise in Snowflake to help build and optimize modern cloud-based data solutions that support critical business operations.
In this role, you'll design, develop, and maintain scalable ETL/ELT pipelines, optimize data models, and ensure the delivery of accurate, high-quality data to downstream business systems. You'll work with modern cloud-native technologies while helping evolve the organization's data platform toward a Snowflake and dbt architecture.
The ideal candidate has strong experience building enterprise data pipelines, designing scalable data warehouses, and transforming complex business requirements into reliable data solutions.
Remote – United States (Midwest Preferred)
Occasional travel to Chicago may be required.
Key Responsibilities:
- Design, develop, and maintain scalable ETL/ELT pipelines using modern data integration tools.
- Build and optimize data models in Snowflake for analytics and operational reporting.
- Develop data transformation processes supporting business intelligence and downstream applications.
- Design and maintain enterprise data pipelines integrating CRM, ERP, billing, and other business systems.
- Ensure data quality, integrity, consistency, and reliability across all data workflows.
- Build and maintain outbound integrations with enterprise applications and reporting platforms.
- Monitor, troubleshoot, and optimize pipeline execution and query performance.
- Collaborate with business stakeholders to translate requirements into scalable data solutions.
- Support the evolution of modern cloud-native data architecture using Snowflake and dbt.
- Participate in code reviews and continuously improve engineering best practices.
Requirements:
- 5+ years of professional Data Engineering experience.
- 4+ years of hands-on Snowflake experience.
- Strong SQL and data warehousing experience.
- Experience designing and maintaining ETL/ELT pipelines.
- Experience working with enterprise business data.
- Experience integrating multiple enterprise applications.
- Strong analytical and problem-solving skills.
- Experience working in Agile environments.
- Strong written and verbal English communication skills.
- Must be based in the United States.
Must Have:
- 5+ years of Data Engineering experience.
- 4+ years of hands-on Snowflake experience.
- Advanced SQL skills.
- Experience building and maintaining ETL/ELT pipelines.
- Experience with Matillion or similar ETL/ELT platforms.
- Strong data modeling experience.
- Experience designing enterprise data warehouses.
- Experience optimizing Snowflake performance.
- Experience integrating CRM, ERP, billing, and other enterprise systems.
- Experience building scalable data pipelines.
- Strong understanding of data quality, governance, and integrity.
- Experience translating business requirements into scalable data solutions.
Nice to Have
- Experience with dbt (Data Build Tool).
- Experience migrating ETL workloads to Snowflake-native architectures.
- Experience with SAP Callidus.
- Experience with Xactly.
- Experience with CaptivateIQ.
- Experience working with Sales Compensation or Incentive Compensation Management (ICM) platforms.
- Experience supporting Revenue Operations or Sales Operations teams.
- Experience with Snowflake Cortex.
- Experience implementing AI-driven data workflows.
- Experience working with Finance or Commission-related datasets.