HireMO

Description

Position Summary

We are seeking an accomplished Senior Data Engineer with 8 years of hands-on experience to join our data team. This role combines deep expertise in data pipeline engineering ETL- SQL Server, Informatica, Active Batch, and SSAS - with strong semantic modeling capabilities, including Power BI and dimensional data modeling. The ideal candidate is equally comfortable supporting and enhancing production pipelines and supporting high-performance analytical models that drive business intelligence across the enterprise.

Key Responsibilities

Pipeline Engineering & Production Support

+ Monitor, support, and enhance existing data pipelines built on SQL Server, Informatica, and Active Batch, ensuring high availability and data integrity.

+ Develop, maintain, and optimize ETL/ELT processes; troubleshoot performance bottlenecks and data quality issues with minimal downtime.

+ Manage and tune Active Batch job workflows for reliable, efficient automation.

+ Collaborate with cross-functional teams to resolve data incidents, communicate root cause, and implement preventive measures.

+ Document pipeline processes, data flows, and technical specifications to support operational continuity and knowledge transfer.

Data Modeling & Semantic Layer

+ Design, develop, and optimize SSAS tabular models and lead migration efforts to Power BI semantic models.

+ Build and maintain Power BI semantic models leveraging data from SQL Server; ensure high-performance query execution.

+ Write, optimize, and troubleshoot SQL, DAX, and Power Query (M) to support analytics and reporting needs.

+ Partner with data engineers to design tables and schemas for optimal analytical performance.

+ Document data models, business rules, and data mappings using catalog tooling.

+ Ensure smooth daily operations of deployed data models; address outages promptly.

Stakeholder Engagement & Mentorship

+ Collaborate with business and technical stakeholders to gather requirements and deliver data products aligned to business needs.

+ Train and mentor junior engineers and modelers on best practices for pipeline development, data modeling, and optimization.

+ Research and recommend tools, methods, and technologies to continuously improve data engineering and modeling practices.

Qualifications

+ Bachelor Degree in Computer Science, Management Information Systems, Engineering or related field required

+ 8 years of combined experience in data engineering and data modeling roles.

+ Expert-level proficiency in T-SQL and SQL Server (including stored procedures, views, performance tuning) preferred.

+ Hands-on experience with Informatica (PowerCenter or IICS) for ETL pipeline development and support preferred.

+ Proven experience managing and troubleshooting ActiveBatch job scheduling and workflow automation preferred.

+ Strong background in SSAS tabular model development and performance optimization preferred.

+ Advanced knowledge of DAX and Power Query (M) for Power BI semantic modeling preferred.

+ Solid understanding of data warehousing concepts, dimensional modeling, and ETL/ELT patterns preferred.

+ Strong problem-solving skills with a disciplined approach to root cause analysis and incident resolution preferred.

Strongly Preferred Qualifications:

+ Experience with Azure Data Factory or comparable cloud orchestration platforms.

+ Familiarity with Big Query as a data platform for modeling and pipeline development.

+ Experience with Azure cloud environments and underlying infrastructure concepts.

+ Knowledge of scripting languages such as Python or PowerShell for pipeline automation.

+ Familiarity with Oracle SQL, PL/SQL.

+ Experience with data catalog tools such as Alation or similar platforms.

+ Knowledge of business processes and terminology (e.g., Finance, HR, Project Costing).

+ QA/QC mindset with experience validating data accuracy across analytical layers.

This job posting will remain open a minimum of 72 hours and on an ongoing basis until filled.

EEO/Disabled/Veterans

Job Web Development

Primary Location US-MO-Kansas City

Schedule: Full-time

Travel: No

Req ID: 263758

Job Hire Type Experienced #LI-MJ #COR

Apply Externally

Jobs

Senior Data Engineer - Information Technology (Kansas City)

Summary

You Need a MO Jobs Account First

Jobs

Jobs

Senior Data Engineer - Information Technology (Kansas City)

Summary

Do You Have a MO Jobs Account?

First, Let's Find Your MO Jobs Account

Create an Account to Apply

You Need a MO Jobs Account First

HireMO Terms of Use

1. Acceptance and Changes

2. A No-Cost Public Workforce Service

3. Eligibility, Youth, and Authority

4. Accounts and Security

5. Accuracy Attestation and Program Information

6. Job Seeker Terms

7. Employer Terms

8. Assessments and Matching

9. Artificial Intelligence Features

10. Public Records and Required Notices

11. User Content and Permissions

12. Acceptable Use

13. Intellectual Property and Government Marks

14. Other Users and Third-Party Services

15. Electronic Communications

16. Suspension, Termination, and Records

17. Disclaimers

18. Limitation of Liability and Sovereign Immunity

19. Employer Indemnification

20. Governing Law and General Terms

21. Contact, Accessibility, and Complaints