Pay Growth
?
out of 5
Not enough data
Not enough info to score pay or growth
Snowflake Data Engineer
Job
Infojini
Elk Grove Village, IL (In Person)
Full-Time
Review key factors to help you decide if the role fits your goals.
Job Security
?
out of 5
Not enough data
Calculating job security score...
Total Score
82
out of 100
Average of individual scores
Skill Insights
Compare your current skills to what this opportunity needs—we'll show you what you already have and what could strengthen your application.
Job Description
A senior data engineer with extensive hands-on experience in building and maintaining modern, scalable data pipelines and transformation frameworks. This role involves designing, developing, and optimizing production-grade data solutions using Snowflake, dbt, and Fivetran. The ideal candidate demonstrates strong ownership, accountability, and operational independence to deliver high-quality data infrastructures that meet enterprise standards for performance, cost-efficiency, and reliability. Responsibilities Design, build, and maintain scalable ELT pipelines utilizing Fivetran for ingestion and dbt for transformation on Snowflake. Develop and manage modular, reusable dbt models including staging, intermediate, and data marts, with documentation and testing. Create scalable data models based on best practices such as star schema, dimensional modeling, and data vault principles. Optimize Snowflake performance through query tuning, workload management, micro-partitioning, clustering, and pruning. Build and enforce data quality frameworks featuring schema validation, testing, and reconciliation for consistency and accuracy. Develop Python scripts for automation, operational tooling, metadata management, and orchestration support. Implement and maintain Git-based development workflows including version control, branching, pull requests, and code reviews. Build and enhance CI/CD pipelines to enable automated testing, deployment, and environment promotion for data workflows. Collaborate with platform, governance, and business teams to align on data requirements, access control, and delivery standards. Work with orchestration tools like Airflow or similar to schedule, monitor, and manage data pipeline executions, ensuring operational reliability. Qualifications Hands-on production experience with dbt, including model development, dependency management, macros, testing, and deployment. Deep Snowflake expertise encompassing data modeling, performance tuning, cost optimization, security, and access control. Strong SQL skills for building complex transformations and troubleshooting. Proficiency in Python programming for automation, data processing, and operational support. Solid experience with Git, including collaborative development workflows and version control. Proven track record in designing, building, and maintaining reliable, high-performance data pipelines aligned with SLAs.