Senior Analytics Engineer

American Industrial Transport - AITX; Saint Charles (MO); On-site; USD 110,000 - 170,000; Full time

Job summary

American Industrial Transport - AITX seeks a Senior Analytics Engineer to design, build, and maintain enterprise analytics solutions. You will transform data from bronze to gold, create scalable data models, and develop AI-ready data products to enable data-driven decisions across the organization.

You will collaborate with business and technology leaders, own analytics initiatives from requirements to implementation, and drive quality, governance, and actionable insights using modern dashboards

Qualifications

• 7+ years in data engineering or analytics roles.
• Strong SQL and data modeling skills.
• Experience with modern dashboards and BI applications.
• Understanding of data governance, quality, and metadata.
• Excellent communication and business partnership abilities.
• Familiarity with Microsoft data stack and ERP integrations.
• Experience in regulated or asset-intensive industries preferred.

Responsibilities

• Design, build, and maintain curated data products (bronze to gold).
• Develop scalable data models and semantic layers for diverse analytics.
• Create reusable metrics and standardized calculations.
• Develop dashboards, scorecards, and self-service analytics.
• Translate business needs into analytical solutions for decisions.
• Collaborate with Data Governance to ensure data quality and lineage.
• Lead AI-ready data product initiatives and AI capabilities.
• Support enterprise data platform modernization and analytics initiatives.

Skills

SQL development

Dimensional modeling

Semantic modeling

Dashboard analytics

Data governance

Data quality

Metadata management

Communication & collaboration

AI-ready data products

APIs & cloud integration

Event-driven architectures

AI / ML initiatives

ERP SAP experience

Regulated industries knowledge

Education

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

Tools

Microsoft Fabric

Azure Data Factory

Azure SQL

Power BI

Microsoft Purview

ERP SAP

Job description

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.
• Strong SQL development experience.
• 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.