Data Analytics Engineer

Job overview

The Data Analytics Engineer role is onsite in Saint Louis, MO, with an annual salary of $88,000–$117,000. The role supports Midwest Railcar’s data infrastructure and its railcar leasing and transportation business. The engineer bridges raw data ingestion and analytics by building reliable, documented, and performant models and pipelines. The work enables analysts and stakeholders to use consistent, high-quality information for reporting, operational decisions, and strategic initiatives.

What you'll do

• Design and manage data models and ELT/ETL pipelines in Snowflake using dbt
• create conform and analytics layers, dimensional models, and data marts
• implement data quality, integrity, and performance monitoring
• contribute to governance, lineage, and data definitions
• optimize Snowflake storage, retrieval, SQL, and transformations
• document models, processes, metrics, lineage, and metadata
• use version control and CI/CD
• test, review, and automate deployments
• collaborate with analysts and business subject matter experts to translate requirements into technical solutions.

What we're looking for

Skills & competencies

data analytics engineer

saint louis mo

imperial pfs

midwest railcar

snowflake

dbt

sql

data modeling

etl/elt pipelines

data governance

ci/cd

$88k–$117k/year

railcar leasing

Work arrangement

• Weekend coverage required

Benefits & perks

• Parking and commuter benefits based on location
• wellness and employee assistance programs
• gym membership subsidies
• 401(k) match
• medical, prescription, dental, vision, life, and AD&D insurance
• paid time off and holidays.

Why this role

Bachelor’s degree in Information Systems or related field and 2–4 years of relevant experience required; advanced SQL, Snowflake, and dbt proficiency required. SnowPro certification, Python, and visualization tools are among preferred qualifications.

About the employer

Imperial PFS is hiring for this role. Industry: Support Activities for Rail Transportation. Sector: 48.