Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Analytics Engineer

$88k - $117k

Imperial PFS

Job Description

Job Description

Midwest Railcar - Data Analytics Engineer

About Midwest Railcar LLC - Midwest Railcar, LLC, a company related to Imperial PFS (IPFS), is a premier railcar leasing and rail fleet management company serving a diverse range of industries, including agriculture, energy, construction materials, iron & steel, chemicals, plastics, food products, and many others. The company owns, leases, and manages a fleet of more than 31,000 railcars, offering a broad range of equipment including covered hoppers, gondolas, tank cars, boxcars, open top hoppers, and flatcars through flexible leasing solutions tailored to meet customer needs. Backed by strong capital partners and deep industry expertise, Midwest Railcar combines high-quality equipment, disciplined asset management, and a customer-focused approach to ensure long-term value, performance, and sustainable growth.

Compensation and Benefits

  • Compensation annual salary range of $88,000 to $117,000
  • Medical, dental, vision and life insurance plans
  • 401(k) plan
  • Generous paid time off (PTO) plan
  • Company-paid holidays

About the Role

The Data Analytics Engineer builds and maintains the foundational data infrastructure that transforms raw business data into reliable, analysis-ready insights for decision-making. This position is critical to establishing scalable data models, pipelines, and governance practices that will support our growing analytical needs.

The prime reason for this role's existence is to bridge the gap between raw data ingestion and analytics needs, ensuring that our analysts and stakeholders have access to high-quality, well-documented, and performant data models. This position directly contributes to the company's overall mission by enabling data-driven decision making across all departments, improving operational efficiency, and supporting strategic initiatives through reliable analytics infrastructure.

Key contributions to the company include:

  • Building standardized data models that reduce time-to-insight for business users

  • Implementing data quality and governance frameworks that ensure information is accurate and compliant.

  • Creating reliable, well-documented data pipelines that enable consistent reporting and analytics across all business functions

What You'll Do

Data Modeling and Pipeline Development

  • Design, build, and manage data models and ELT/ETL pipelines to transform raw data into structured formats within Snowflake using dbt

  • Create conform and analytics layers that standardize data for business consumption

  • Develop dimensional models and data marts tailored to business requirements

Data Quality and Governance

  • 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

Performance Optimization

  • Optimize data storage and retrieval processes within Snowflake to ensure scalable, reliable, and cost-effective data solutions

  • Fine-tune SQL queries and data transformations for optimal performance

  • Monitor and improve pipeline efficiency and resource utilization

Technical Documentation

  • 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

Software Engineering Practices

  • Leverage version control and CI/CD pipelines for streamlined, reliable development processes

  • Ensure code quality through testing, peer reviews, and automated deployment

Collaboration and Stakeholder Management

  • Work closely with analysts and business subject matter experts to understand requirements

  • Translate business needs into effective technical data solutions

  • Participate in regular stakeholder meetings to refine and expand data capabilities


Other Tasks and Responsibilities as Required

Required Qualifications

  • Bachelor’s degree in Information Systems or a related field

  • 2-4 years of experience in analytics engineering, data engineering, or similar role

  • Advanced SQL 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 deep understanding of data modeling principles and experience designing efficient structures for analytics

  • dbt proficiency for managing data transformations and building data models within Snowflake

  • Passion for detail and quality - skilled at spotting data and process gaps and committed to driving continuous improvement

  • Strong communication skills and comfort collaborating with non-technical stakeholders

  • Intellectual curiosity and drive to understand business problems through data

  • Communication skills – specifically 1 on 1 communication skills with staff regarding changes or fixes that could affect them.
  • Listening skills – being able to interpret the issues that the user is facing is key when providing them with a solution.
  • Understand and prioritize corporate goals

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

The salary range for this position is $88,000 to $117,000. If an offer is made, the pay rate determinations will take into account relevant market data and the applicant’s prior experience, education and other qualifications directly related to the position to ensure internal equity.
Vacancy posted 15 days ago
Similar jobs that could be interesting for youBased on the Data Analytics Engineer in Saint Louis, MO vacancy
  • $88k - $117k

     ...Job DescriptionJob DescriptionMidwest Railcar - Data Analytics EngineerAbout Midwest Railcar LLC - Midwest Railcar, LLC, a company related...  ...) planCompany-paid holidaysAbout the RoleThe Data Analytics Engineer builds and maintains the foundational data infrastructure that... 
    Suggested
    Flexible hours

    Imperial PFS

    Saint Louis, MO
    1 day ago
  • *** Must be a US Citizen or Green Card only Applicant **** The Data Analytics Engineer will be a part of the Data Engineering team whose primary mission is to build trusted Data Ingestion Pipelines to seamlessly move and transform data from SaaS and in house transactional... 
    Suggested
    2 days per week

    The Timberline Group Company

    Saint Louis, MO
    9 hours ago
  • $75.2k - $158.1k

    Job Title: Cyber Data Analyst Engineer Job Category: Information Technology Time Type: Full time Minimum Clearance Required to Start: TS/SCI Employee Type: Regular Percentage of Travel Required: Up to 10% Type of Travel: Local * * * The Opportunity:... 
    Suggested
    Full time
    Contract work
    Work experience placement
    Local area
    Flexible hours
    Night shift

    CACI International, Inc.

    Saint Louis, MO
    4 days ago
  • $20.91 - $45.04 per hour

     ...sensor solutions enable the distribution of power, signal and data to advance next-generation transportation, renewable energy, automated...  ...and category management decision-making through advanced analytics partnering closely with the Senior Analyst and cross-functional... 
    Suggested
    Remote job
    Work experience placement
    Summer work
    Internship
    Local area

    TE Connectivity

    Saint Louis, MO
    2 days ago
  •  ...executing the technology portion of the Data Strategy IT pillar. This team will work...  ...closely with technology leaders, the Data & Analytics business team and industry partners to...  ...governance and management, and data engineering. The Cloud Data Engineering team within... 
    Suggested
    Immediate start

    The Timberline Group Company

    Saint Louis, MO
    1 day ago
  •  ...Overview: Data Scientist Remote 12 Month Contract to hire Data Scientist...  ...role with strong overlap into Data Engineering. What the client is really looking...  ...requirement); Joins, CTEs, window functions, analytical queries Hands-on with data quality,... 
    Contract work
    Remote work

    Stellar IT Group

    Saint Louis, MO
    9 hours ago
  •  ...Data Scientist James Scott, LLC is actively searching for an experienced Data Scientist to provide support to one of its top tier...  ...both structured and unstructured datasets in a modeling and analytics context to develop efficient processes for evaluating complex data... 

    James Scott Group

    Saint Louis, MO
    4 days ago
  •  ...interpret regulatory guidance and instructions, sourcing vital data, and preparing reports schedules with detailed supporting work...  ...and take initiative and ownership of assigned tasks.  Strong analytical and problem solving skills with high attention to detail. Strong... 
    Full time
    Local area

    Enterprise Bank and Trust

    Saint Louis, MO
    a month ago
  • RESPONSIBILITIES: Kforce has a client that is seeking a remote Data Analyst. Summary: The Data Analyst supports client-facing...  .... The analyst will work with large datasets, develop KPIs and analytical models, and translate complex data into clear reporting and... 
    Hourly pay
    Contract work
    Remote work

    Kforce Technology Staffing

    Saint Louis, MO
    3 days ago
  •  ...As a Category Insights Analyst, you will serve as a critical analytical and insights resource for clients with less than $20 million in...  ...portion of this role involves collecting, analyzing, and reporting data from a variety of sources, including syndicated, retailer,... 

    Advantage Unified Commerce

    Saint Louis, MO
    1 day ago
  •  ...SAP Data Quality Analyst Location: St. Louis, MO / Seattle, WA Duration: Fulltime Skills Desired: Responsible for reviewing profiling results with business and IT, identifying data quality business rules to be developed in Information Steward Functional... 
    Full time
    Immediate start
    Relocation

    JConnect Infotech

    Saint Louis, MO
    1 day ago
  • $58.4k - $99.7k

     ...Finance office, which will assist WUSM department users, by providing reporting solutions that enhance planning, historical analysis, and data-driven decision-making. In addition, this position assists with monthly data extracts and reconciliation processes to ensure... 
    Work experience placement
    Work at office

    Washington University in St. Louis

    Saint Louis, MO
    1 day ago
  • $124k - $140k

     ...valued. If you want your work to count and the room to become your best youll find it here. Lead Data Analyst Lead Data Analyst for St Louis MO to lead data analytics tasks by defining prioritizing & setting timelines to deliver agricultural data insights and... 
    Full time
    Local area
    Remote work
    Home office
    3 days per week

    Bayer

    Saint Louis, MO
    5 days ago
  •  ...Job Title: Network Data Comm Analyst Location: Stennis Space Center, Mississippi Type: 1 + year Contract...  ...networking/customer related concerns and issues Supporting engineers in troubleshooting network instability Communicating to... 
    Contract work
    Temporary work
    Local area
    Shift work

    System One

    Saint Louis, MO
    15 days ago
  •  ...company is seeking an HR Analyst for Total Rewards & Recognition. This role involves administering the recognition platform, supporting analytics, and coordinating with vendors. Ideal candidates should have 2-4 years in HR operations, strong analytical skills, and proficiency... 
    Flexible hours

    Copeland

    Saint Louis, MO
    1 day ago
  • A leading higher education institution in St. Louis seeks a Prospect Management Consultant to manage prospect data integrity and provide insights for fundraising strategies. The candidate will work collaboratively with gift officers and fundraising teams to optimize donor... 
    Full time

    Washington University in St. Louis

    Saint Louis, MO
    3 days ago
  •  ...Enterprise Mobility is excited to announce the opening of a Data Engineer Intern . The Information Technology (IT) department of Enterprise...  ...duties as assigned Skills and Abilities: Demonstrable analytical and troubleshooting skills; ability to think outside the box... 
    Work experience placement
    Summer work
    Internship
    Summer internship
    Work at office
    Remote work
    Work from home
    Monday to Friday

    Enterprise

    Saint Louis, MO
    2 days ago
  • $115k - $160k

     ...Data Scientist bioMerieux's Data Science group is looking for an experienced Data...  ...application of mathematical techniques, data analytics, experiment design, algorithm design and...  ...interaction with other scientists and engineers while prototyping, integrating and... 
    Temporary work
    Work experience placement

    BioFire Diagnostics

    Hazelwood, MO
    4 days ago
  •  ...sponsorship. About You You are a curious investigator who views media data as a story waiting to be told. You aren’t satisfied with "what"...  ...or disprove them. Integrated Collaboration: Serve as a core analytical partner for the Integrated Strategy & Planning and Campaign... 
    Permanent employment
    Casual work
    Work at office
    Work from home
    Flexible hours
    Shift work

    True Media

    Saint Louis, MO
    3 days ago
  •  ...This role supports compliance, financial statement preparation, data analysis, reconciliations, and reporting processes while...  ...standards and regulatory requirements. The ideal candidate is analytical, detail-oriented, and experienced in financial reporting within... 
    Local area

    Ebs Recruiters

    Saint Louis, MO
    3 days ago
  •  ...here at Stifel, where success meets success.What You'll Be DoingThe Bank Data Analyst II - CECL & Credit Risk will work as a member of Stifel's Analyst team within the Credit Risk Data Analytics group. The Credit Data Analyst II is responsible for automation and servicing... 
    Work experience placement

    Stifel Financial

    Saint Louis, MO
    9 hours ago
  •  ...Coordinate mapping and transformation design for legacy to S4 HANA data objects. Ability to run meetings with business and IT individuals Need functional knowledge of S4 in the related workstream they are responsible for and an understanding of data... 

    3B Staffing LLC

    Saint Louis, MO
    9 hours ago
  •  ...decision-making through comprehensive market research in the biotechnology and healthcare sectors. Ideal candidates will have strong analytical skills, 1-3 years of relevant experience, and a Bachelor's degree in related fields. This role provides an excellent opportunity... 

    Bayer AG

    Saint Louis, MO
    1 day ago
  • Active Duty Staffing is seeking a Marketing Business Analyst in St. Louis, MO, to enhance marketing efficiencies through data analytics. You will analyze business data to guide resource allocation and marketing strategies, ensuring effectiveness in customer engagement.... 

    Active Duty Staffing

    Saint Louis, MO
    5 days ago
  • RESPONSIBILITIES: Kforce has a client that is seeking a Data Engineer in Saint Louis, MO. Duties: * Data Engineer will maintain...  ...Strong SQL/querying capabilities * Strong troubleshooting and analytical skills * Detail-oriented approach to working with data *... 
    Hourly pay
    Contract work

    Kforce Technology Staffing

    Saint Louis, MO
    9 hours ago
  •  ...Description: Hybrid 4 days on-site, 1 day work from home in St. Louis, MO Our client seeks an experienced Data Engineer to support scrum teams working on an enterprise accounting application. You will operate in an AWS GovCloud environment alongside application... 
    Hourly pay
    Local area
    Work from home

    Eliassen Group

    Saint Louis, MO
    4 days ago
  •  ...Job Description Job Description Summary: The engineer in this position should have a wealth of experience engineering/installing...  ...cohesive package. This would include the complete engineering of data centers including, but not limited to, infrastructure, overhead... 
    For contractors
    Work at office
    Local area

    ADEX

    Saint Louis, MO
    1 day ago
  • $89.31k - $134.87k

     ...accessible to all. A Brief Overview Maintain and enhance data integrity by supporting existing validations and adding...  ...are documented. Support development of implementation of data analytics tools, which could include support of the transition from legacy... 
    Work experience placement
    Immediate start
    Remote work

    Reinsurance Group of America

    Chesterfield, MO
    2 days ago
  •  ...Data Engineer - Databricks 6-Month Contract-to-Hire REMOTE (Local to St. Louis would be a big bonus) Must be GC...  ...modern architecture, and platform capabilities that support analytics, AI, and future business initiatives. Responsibilities... 
    Contract work
    Local area
    Remote work

    3B Staffing LLC

    Saint Louis, MO
    1 day ago
  •  ...Hi Professionals, Hope you are doing good, Please find the below JD and let me know your thoughts, Job Title : Sr. Data Engineer (SSIS & Power BI) Location : Remote till march 2022 Duration : 6 Months C2H W2 ONLY Day to Day Responsibilities... 
    Remote work

    Navtech

    Saint Louis, MO
    1 day ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Analytics Engineer. Be the first to apply!