Data Analytics Engineer

Midwest Railcar; St. Louis (MO); On-site; USD 70,000 - 117,000; Full time

Benefits offered by this job

401(k) with a company match

Parking and commuter benefits programs

Wellworks wellness program

Employee Assistance Program

Gym membership subsidies

Medical, prescription, dental, vision,

Life insurance and AD&D

Job summary

Midwest Railcar is seeking a Data Analytics Engineer to strengthen its data foundation and deliver analysis-ready insights for decision-making. This onsite role in St.

Louis focuses on building scalable data models, ELT/ETL pipelines, and governance practices, with Snowflake and dbt at the core. You will design conformed analytics layers, dimensional models, and data marts, while ensuring data quality, lineage, and performance monitoring across pipelines.

Qualifications

• Bachelor's degree in Information Systems or a related field.
• ,
• ,
• ],
• job_responsibilities_description:[
• ,
• ] ,
• CoT_job_summary_short
• job_summary_short
• contract_type
• location_type
• remote_scope
• perks
• stated_min
• stated_max
• stated_absolute
• salary_estimation_cot
• estimated_low
• estimated_medium
• estimated_high
• currency
• frequency
• bonus
• tax
• application_email
• job_end_date
• contact_person
• hiring_department_name
• ]}{
• }
• }
• ,
• }
• ,
• }
• ,
• }
• ,
• }
• ,
• }
• ,
• }
• ,
• }
• ,
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }
• }

Responsibilities

• Design, build, and manage data models and ELT/ETL pipelines in Snowflake using dbt.
• Create conformed and analytics layers to standardize data for business use.
• Develop dimensional models and data marts aligned to business needs.
• Implement data quality, integrity, and performance monitoring practices.
• Contribute to data governance, lineage, and metadata documentation.
• Establish data quality checks and validation in dbt workflows.
• Optimize storage and retrieval in Snowflake for scalable solutions.
• Fine-tune SQL queries and transformations for performance.
• Monitor and improve pipeline efficiency and resource usage.
• Document data models, processes, and key metrics clearly.
• Document data lineage and maintain metadata for datasets.
• Set documentation standards and best practices for the team.
• Use version control and CI/CD pipelines for reliable development.
• Ensure code quality via testing, peer reviews, and automated deployment.
• Partner with analysts and business SMEs to translate needs into data solutions.
• Participate in stakeholder meetings to refine data capabilities.
• Build standardized data models to shorten time-to-insight.

Skills

Advanced SQL

Data modeling

dbt

Communication

Attention to detail

Curiosity

Education

Bachelor's degree in Information Systems or related field

Tools

Snowflake

dbt

ANSI-SQL

CI/CD

Tableau

Looker

Power BI

Fivetran

Python

Job description

Midwest Railcar is seeking a Data Analytics Engineer to strengthen its data foundation and help deliver analysis-ready insights for decision-making. In this onsite role in St. Louis, you will build and maintain scalable data models, ELT/ETL pipelines, and governance practices, with a focus on transforming raw business data into well-documented, performant assets in Snowflake using dbt.

What you’ll do

• Design, build, and manage data models and ELT/ETL pipelines that transform raw data into structured formats within Snowflake using dbt
• Create conformed and analytics layers to standardize data for business consumption
• Develop dimensional models and data marts aligned to business requirements
• Implement best practices for data quality, integrity, and performance monitoring
• Contribute to data governance frameworks, including maintaining data lineage and definitions
• Establish data quality checks and validation processes within dbt workflows
• Optimize data storage and retrieval in Snowflake to support scalable, reliable, and cost-effective solutions
• Fine-tune SQL queries and data transformations to improve performance
• Monitor and improve pipeline efficiency and resource utilization
• Create and maintain clear, comprehensive documentation for data models, processes, and key metrics
• Document data lineage and maintain metadata for analytical datasets
• Establish documentation standards and best practices for the team
• Use version control and CI/CD pipelines to support streamlined, reliable development
• Ensure code quality through testing, peer reviews, and automated deployment
• Partner with analysts and business subject matter experts to understand requirements and translate business needs into technical data solutions
• Participate in regular stakeholder meetings to refine and expand data capabilities
• Build standardized data models that reduce time-to-insight for business users
• Implement data quality and governance frameworks that help ensure information is accurate and compliant
• Create reliable, well-documented data pipelines to enable consistent reporting and analytics across business functions

Key technologies

• Snowflake
• dbt
• ELT/ETL
• ANSI-SQL (SQL)
• CI/CD
• Tableau, Looker, Power BI
• Fivetran
• Python

What you bring

• Bachelor’s degree in Information Systems or a related field
• 2–4 years of experience in analytics engineering, data engineering, or a similar role
• Advanced SQL proficiency in ANSI-SQL for querying, data transformation, and building data infrastructure
• Snowflake expertise with hands‑on experience in architecture and best practices for data management and processing
• Strong data modeling skills with a deep understanding of data modeling principles and experience designing efficient analytics structures
• dbt proficiency for managing transformations and building data models within Snowflake
• Detail-oriented mindset focused on spotting data and process gaps and driving continuous improvement
• Strong communication skills and comfort collaborating with non-technical stakeholders
• Intellectual curiosity and a drive to understand business problems through data

Salary and location

• Location: St. Louis, MO (onsite)
• Salary range: $88,000 to $117,000 per year

Benefits

• 401(k) with a company match
• Parking and commuter benefits programs
• Wellworks wellness program
• Employee Assistance Program
• Gym membership subsidies
• Medical, prescription, dental, voluntary vision, voluntary life/dependent life, group term life, and AD&D insurance benefits
• Paid time off
• Paid holidays

Preferred qualifications

• SnowPro certification or equivalent advanced Snowflake expertise
• Experience with modern cloud data architecture (data lakes, data lakehouses, cloud data platforms)
• Experience with ELT/ETL tools (Fivetran experience a plus)
• Knowledge of data visualization tools (Tableau, Looker, Power BI)
• Previous experience in insurance, finance, or regulated industries
• Python programming experience for data parsing, transformation, and scripting within data pipelines