Senior Analytics Engineer

AITX Railcar Services, LLC; Saint Charles (MO); On-site; USD 120,000 - 130,000; Full time

Job summary

AITX Railcar Services, LLC seeks a Senior Analytics Engineer to design, build, and maintain enterprise analytics solutions. You will transform data into trusted, scalable information, from bronze to gold, and create reusable data products that improve reporting and decision-making across the organization.

You will partner with business and technology leaders to develop AI-ready data products, semantic models, and dashboards, driving analytics across operational, financial, and executive domains.

Qualifications

• Bachelor's degree or equivalent experience in a related field.
• 7+ years in data engineering, analytics engineering, BI, or related roles.
• Experience designing dimensional and semantic data models.
• Experience developing modern dashboards and analytical apps.
• Strong understanding of data governance, data quality, and metadata management.
• Excellent communication, collaboration, and business partner skills.
• Experience with Microsoft Fabric, Azure Data Factory, Azure SQL, Power BI, and related Microsoft data technologies.
• Experience with medallion data architectures.
• Knowledge of APIs, cloud integration, and event-driven architectures.
• Understanding of emerging agentic AI solutions.
• Experience supporting AI, ML, or advanced analytics initiatives.
• Familiarity with Microsoft Purview or similar governance platforms.
• Experience working with ERP platforms such as SAP.
• Experience in regulated or asset-intensive industries preferred.

Responsibilities

• Design, build, and maintain bronze to gold data products using medallion architecture.
• Develop scalable enterprise data models and semantic models for various analytics.
• Create reusable metrics and standardized calculations for consistent reporting.
• Maintain and enhance enterprise data products and semantic models.
• Develop scalable dashboards, scorecards, and self-service analytics.
• Translate business requirements into intuitive analytical solutions.
• Design reports to simplify environments, reduce redundancy, and improve usability.
• Rationalize enterprise reporting by retiring redundant reports and promoting governed semantic models.
• Improve reporting performance, adoption, and user experience.
• Collaborate with business leaders to identify opportunities to improve decision-making with data.
• Recommend solutions to simplify processes and deliver measurable value.
• Help establish KPIs aligned with objectives.
• Own analytics initiatives from requirements to implementation and enhancement.
• Partner with Data Governance to improve data quality, metadata, and lineage.
• Implement validation, reconciliation, and monitoring for trusted analytics outcomes.
• Document end-to-end data lifecycle from source to enterprise data products and reporting.
• Develop AI-ready data products and semantic models to support enterprise AI capabilities.
• Design and implement AI solutions including data agents and intelligent search.
• Collaborate with Data Science to enable advanced analytics on trusted assets.
• Support data platform modernization and continuous improvement initiatives.

Skills

Dimensional modeling

Semantic modeling

Dashboard development

Data governance

Communication skills

AI / analytics initiatives

ETL / data engineering

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or related discipline (or equivalent experience)

Tools

Microsoft Fabric

Azure Data Factory

Azure SQL

Microsoft Power BI

ERP SAP

Microsoft Purview

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Full Time St. Charles, MO, US

6 days ago Requisition ID: 1272

Salary Range: $120,000.00 To $130,000.00 Annually

Job Summary

The Senior Analytics Engineer is responsible for designing, building, and maintaining the organization's enterprise analytics solutions by transforming enterprise data into trusted, scalable, and actionable business information. Beginning with data available in the bronze layer of the enterprise data platform, this role owns the lifecycle of data curation, business transformations, enterprise data modeling, semantic modeling, and analytics that enable informed decision‑making across the organization.

Working closely with business and technology leaders, the Senior Analytics Engineer develops reusable data products that improve operational performance, simplify enterprise reporting, and support data‑driven decision making. In addition to delivering traditional analytics solutions, this role develops AI‑ready data products and designs, builds, and implements enterprise AI capabilities including data agents, intelligent search, AI‑assisted decision making, and future intelligent business solutions.

This position represents the evolution of traditional reporting roles into a modern analytics engineering discipline. By combining data curation, enterprise modeling, semantic design, analytics engineering, and data visualization into a single role, the Senior Analytics Engineer delivers governed, reusable, and scalable data products that reduce complexity, standardize business metrics, and accelerate the organization's ability to leverage analytics and AI.

Job Duties

• Design, build, and maintain curated silver and gold data products following the organization's medallion architecture.
• Develop scalable enterprise data models, dimensional models, and semantic models supporting operational, financial, commercial, and executive analytics.
• Create reusable business metrics and standardized calculations that provide consistent reporting across the organization.
• Maintain and enhance enterprise data products and semantic models to meet evolving business needs.
• Develop scalable dashboards, scorecards, executive reporting, and self‑service analytics solutions.
• Translate business requirements into intuitive analytical solutions that support decision‑making.
• Design reporting solutions that simplify the reporting environment, reduce redundancy, and improve usability.
• Continuously evaluate and rationalize enterprise reporting assets by retiring redundant reports, standardizing enterprise reporting, and promoting the use of governed semantic models.
• Improve reporting performance, adoption, and overall user experience.
• Work directly with business leaders to understand operational challenges and identify opportunities to improve decision‑making through data.
• Recommend solutions that simplify business processes and deliver measurable business value.
• Help establish enterprise KPIs and performance measures aligned with organizational objectives.
• Own analytics initiatives from requirements gathering through solution design, development, implementation, and ongoing enhancement.
• Partner with the Data Governance team to improve data quality, metadata, and lineage across enterprise data assets.
• Implement validation, reconciliation, and monitoring processes to ensure trusted and reliable analytical outcomes.
• Understand and document the end‑to‑end data lifecycle from source systems through enterprise data products, semantic models, and business reporting.
• Develop AI‑ready data products, semantic models, and curated data assets that support enterprise AI capabilities, including data agents, intelligent search, AI‑assisted decision making, and future intelligent business solutions.
• Design, develop, and implement AI solutions including data agents, intelligent search, AI‑assisted analytics, and other agentic capabilities.
• Partner with Data Science and business stakeholders to enable advanced analytics initiatives through trusted enterprise data assets.
• Support enterprise data platform modernization and continuous improvement initiatives.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or related discipline (or equivalent experience).
• 7+ years of experience in data engineering, analytics engineering, business intelligence, or related technical roles.
• Experience designing dimensional and semantic data models.
• Experience developing modern dashboards and analytical applications.
• Strong understanding of data governance, data quality, and metadata management.
• Excellent communication, collaboration, and business partnership skills.
• Experience with Microsoft Fabric, Azure Data Factory, Azure SQL, Microsoft Power BI, and related Microsoft data technologies.
• Experience with medallion data architectures.
• Knowledge of APIs, cloud integration, and event‑driven data architectures.
• Understanding of emerging agentic AI solutions.
• Experience supporting AI, machine learning, or advanced analytics initiatives.
• Familiarity with Microsoft Purview or other metadata and governance platforms.
• Experience working with ERP platforms such as SAP.
• Experience in regulated or asset‑intensive industries (e.g., rail, manufacturing, logistics) preferred.