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 #J-18808-Ljbffr