Apply Now

Senior Data Engineer - Information Technology (Kansas City)

Kansas City, MO, US • Posted 9 hours ago • Updated 9 hours ago

Full Time

On-site

Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

Information Technology
Business Intelligence
Production Support
Informatica
High Availability
Data Integrity
Data Quality
ROOT
Data Flow
Specification Gathering
Knowledge Transfer
Migration
SQL
Analytics
Reporting
Business Rules
Stakeholder Engagement
Collaboration
Mentorship
Optimization
Research
Computer Science
Management Information Systems
Data Engineering
Data Modeling
Transact-SQL
Microsoft SQL Server
Stored Procedures
Informatica PowerCenter
Management
Job Scheduling
Workflow
Microsoft SSAS
Performance Tuning
DAX
Microsoft Power BI
Semantics
Data Warehouse
Dimensional Modeling
Extract
Transform
Load
ELT
Conflict Resolution
Problem Solving
Root Cause Analysis
Orchestration
Modeling
Microsoft Azure
Cloud Computing
Scripting
Python
Windows PowerShell
PL/SQL
Business Process
Finance
Project Costing
Quality Assurance
Quality Control
Analytical Skill
SAP BASIS
Web Development
Marketing Operations

Information Technology
Business Intelligence
Production Support
Informatica
High Availability
Data Integrity
Data Quality
ROOT
Data Flow
Specification Gathering
Knowledge Transfer
Migration
SQL
Analytics
Reporting
Business Rules
Stakeholder Engagement
Collaboration
Mentorship
Optimization
Research
Computer Science
Management Information Systems
Data Engineering
Data Modeling
Transact-SQL
Microsoft SQL Server
Stored Procedures
Informatica PowerCenter
Management
Job Scheduling
Workflow
Microsoft SSAS
Performance Tuning
DAX
Microsoft Power BI
Semantics
Data Warehouse
Dimensional Modeling
Extract
Transform
Load
ELT
Conflict Resolution
Problem Solving
Root Cause Analysis
Orchestration
Modeling
Microsoft Azure
Cloud Computing
Scripting
Python
Windows PowerShell
PL/SQL
Business Process
Finance
Project Costing
Quality Assurance
Quality Control
Analytical Skill
SAP BASIS
Web Development
Marketing Operations

Summary

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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10394681
Position Id: b80ab882080d64b800b3884aee30a56b
Posted 9 hours ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Data Engineer III

Virginia

•

Today

ApplyLogic is a fast-paced Service-Disabled Veteran-Owned Small-Business, headquartered in Vienna, VA. Our people are our greatest asset, and our company culture is grounded on that belief. We offer challenging and interesting work in a friendly and supportive environment. Through prime and subcontracts, we deliver best-in-class expertise to solve complex technical problems. We're looking for a talented Data Engineer to join our team supporting a complex Federal Government customer in Northern

Full-time

USD 95,000.00 - 130,000.00 per year

Data Engineer - Advanced Analytics & Fraud Detection

No location provided

•

Today

The Data Engineer will support PRAC's Advanced Analytic & Investigative Support Services program by designing, building, maintaining, and optimizing data pipelines that support fraud detection, anomaly detection, financial oversight, investigative intelligence, and advanced analytics across large-scale federal benefit programs. This role will be responsible for ingesting, transforming, validating, cataloging, and preparing data from diverse sources to support data science, graph analytics, fore

Full-time

USD 115,000.00 per year

Data Engineer

Maryland

•

Today

Descriptions & Requirements Job Description and Requirements We Are At Synopsys, we drive the innovations that shape the way we live and connect. Our technology powers the Era of Pervasive Intelligence, enabling breakthroughs in artificial intelligence, cloud computing, autonomous systems, and advanced semiconductor design. We empower the world's leading technology companies to accelerate innovation through world-class silicon and software solutions. Join us and help build the data platforms

Full-time

Sr. Data Engineer

Remote

•

Today

The Sr Data Engineer is responsible for designing, building, and maintaining scalable data pipelines, infrastructure, and data visualization to support our data-driven decision-making processes. The scope of this job includes collaborating with data scientists, analysts, solutions partners, and other stakeholders to increase data quality, accessibility, and security. Key Responsibilities: Create, develop, maintain, and leverage data pipelines, data models, reporting, and dashboards to solve bus

Full-time

Search all similar jobs

More jobs at Burns & McDonnell in Kansas City, MO