Data Analytics Engineer

The Data Analytics Engineer at Midwest Railcar designs and maintains the data foundation that powers dependable, analysis-ready insights. This onsite role in St. Louis focuses on building scalable data models, ELT/ETL pipelines, and governance practices in Snowflake using dbt.

Key Responsibilities

• Design, build, and manage data models and ELT/ETL pipelines that transform raw data into structured outputs within Snowflake using dbt
• Create standardized conform and analytics layers to support business consumption
• Develop dimensional models and data marts aligned to business requirements
• Apply 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 storage and retrieval processes in Snowflake to support scalable, reliable, and cost-effective data solutions
• Fine-tune SQL queries and data transformations for improved performance
• Monitor and improve pipeline efficiency and resource utilization
• Create and maintain clear documentation covering data models, processes, and key metrics
• Document data lineage and maintain metadata for analytical datasets
• Define and maintain documentation standards and team best practices
• Use version control and CI/CD pipelines to support streamlined, reliable development processes
• Ensure code quality through testing, peer reviews, and automated deployment
• Collaborate 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

Core Contributions

• Build standardized data models that reduce time-to-insight for business users
• Implement data quality and governance frameworks to ensure information is accurate and compliant
• Create reliable, well-documented data pipelines that enable consistent reporting and analytics across business functions

Required Qualifications

• 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 proficiency in ANSI-SQL for querying, data transformation, and building data infrastructure
• Snowflake expertise with hands-on experience in its 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 structures for analytics
• dbt proficiency for managing transformations and building data models within Snowflake
• Attention to detail with the ability to identify data and process gaps and drive continuous improvement
• Strong communication skills and comfort collaborating with non-technical stakeholders
• Intellectual curiosity and drive to understand business problems through data

Preferred Qualifications

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

Technologies

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

Benefits

• 401(k) with 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
• Paid time off
• Paid holidays

Location and Salary

Location: St. Louis, MO (onsite)

Salary: USD 88,000 - 117,000 per year

Salary Range: The salary range for this position is $88,000 to $117,000.