Data Analytics Engineer

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