Data Analytics Engineer: Snowflake, dbt & Pipelines

Imperial PFS; Edwardsville (IL); On-site; USD 88,000 - 117,000; Full time

Benefits offered by this job

Parking and commuter benefits

Paid training program

Wellworks wellness program + EAP

401(k) with company match

Paid time off & holidays

Insurance benefits (medical, dental, +

Job summary

Midwest Railcar is seeking a Data Analytics Engineer to build and maintain scalable data infrastructure. You will transform raw data into analytics-ready models and support governance and performance optimization in Snowflake using dbt.

You will design data models, develop ELT/ETL pipelines, ensure data quality, and document lineage and definitions while collaborating with analysts and business stakeholders to translate requirements into reliable data solutions.

Qualifications

• 2–4 years of analytics engineering or data engineering experience.
• Advanced ANSI-SQL querying and data transformation.
• Snowflake expertise with architecture and best practices.
• Strong data modeling skills for analytics-ready structures.
• dbt proficiency for transformations and modeling in Snowflake.
• Attention to detail and commitment to quality.
• Strong communication and stakeholder collaboration.
• Intellectual curiosity to understand business problems through data.

Responsibilities

• Design, build, and manage data models and ELT/ETL pipelines in Snowflake using dbt.
• Create conform analytics layers for business consumption.
• Develop dimensional models and data marts for business needs.
• Implement data quality, integrity, and performance monitoring.
• Contribute to data governance with lineage and definitions.
• Document data models, processes, and metrics.
• Collaborate with analysts and stakeholders to translate requirements.
• Leverage CI/CD and testing to ensure code quality.

Skills

Advanced SQL

Data modeling

Strong communication

Collaborating with non-technicalstake

Tools

Snowflake

dbt

Fivetran

Tableau

Looker

Power BI

Python

Job description

Midwest Railcar is seeking a Data Analytics Engineer to build and maintain scalable data infrastructure. You will transform raw data into analytics-ready models and support governance and performance optimization in Snowflake using dbt.

You will design data models, develop ELT/ETL pipelines, ensure data quality, and document lineage and definitions while collaborating with analysts and business stakeholders to translate requirements into reliable data solutions.