Senior Data Engineer

Matrix IT Ltd; Kansas City, Northern (MO, KY); Hybrid; USD 120,000 - 180,000; Full time

Job summary

Matrix IT Ltd. is seeking a Senior Data Engineer in Kansas City to own data pipelines, semantic models, and enterprise BI solutions.

You will design ETL/ELT workflows, optimize SQL Server-based environments, and mentor junior engineers while partnering with cross-functional teams to drive data-driven decision making. The role emphasizes production support, data governance, and the modernization of analytical models, with opportunities to influence data architecture and reporting capabilities

Qualifications

• Bachelor's degree required in CS/IS/Engineering/Data Analytics or related field.
• 8+ years of data engineering, ETL, warehousing, and analytics experience.
• Strong SQL development, design, and performance tuning
• Hands-on with semantic modeling, analytical data structures, and BI platforms
• Experience supporting production data environments and troubleshooting data issues
• Knowledge of dimensional modeling and star schemas
• Excellent written and verbal communication, cross-functional collaboration

Responsibilities

• Monitor, support, and enhance enterprise data pipelines for accuracy and availability.
• Design, develop, and optimize ETL/ELT processes and workflows.
• Troubleshoot data quality issues and production incidents with minimal business impact.
• Maintain data governance and documentation; ensure data lineage and metadata.
• Design semantic models and support migration to modern BI platforms.
• Collaborate with engineering teams on schema design and query optimization.
• Mentor junior data engineers and analysts; promote engineering standards.

Skills

SQL development

ETL development

Semantic modeling

Data warehousing

Performance tuning

Stakeholder engagement

Mentoring

Education

Bachelor's degree in CS/IS/Engineering/Data Analytics

Tools

SQL Server

Python

PowerShell

Job description

## Senior Data EngineerKansas city · Full-time · Intermediate#### About The PositionSenior Data EngineerWe are seeking an accomplished **Senior Data Engineer** with extensive experience in data engineering, ETL development, and semantic data modeling. This role is responsible for supporting and enhancing enterprise data pipelines, optimizing analytical data models, and delivering scalable business intelligence solutions. The ideal candidate combines strong technical expertise in SQL Server-based data ecosystems with hands-on experience building high-performing semantic models and supporting enterprise reporting platforms.This position requires a balance of production support, data architecture, performance optimization, stakeholder engagement, and mentoring of junior team members.Key ResponsibilitiesData Pipeline Engineering & Production Support* Monitor, support, and enhance enterprise data pipelines to ensure data accuracy, reliability, and availability.* Design, develop, maintain, and optimize ETL/ELT processes and workflows.* Troubleshoot data quality issues, performance bottlenecks, and production incidents while minimizing business impact.* Manage and optimize enterprise job scheduling and workflow automation platforms.* Partner with cross-functional teams to resolve data-related issues, perform root-cause analysis, and implement long-term corrective actions.* Maintain technical documentation, data flow diagrams, operational procedures, and support materials.* Ensure data governance, operational continuity, and adherence to best practices.Data Modeling & Analytics* Design, develop, and maintain enterprise semantic and analytical data models.* Support migration and modernization of legacy analytical models into modern BI platforms.* Build scalable semantic models that enable self-service analytics and reporting.* Develop and optimize SQL queries, analytical calculations, and transformation logic to support reporting and business intelligence requirements.* Collaborate with engineering teams to design schemas, tables, and structures that maximize reporting and query performance.* Document business rules, data lineage, transformations, and metadata.* Monitor and support deployed analytical models, ensuring optimal performance and availability.Data Warehousing & Business Intelligence* Apply dimensional modeling principles and data warehousing best practices.* Design and maintain fact and dimension structures that support enterprise reporting needs.* Ensure consistency and accuracy across reporting, analytical, and operational data layers.* Work closely with reporting and analytics teams to improve usability and performance of BI solutions.Stakeholder Collaboration & Leadership* Partner with business and technical stakeholders to understand requirements and translate them into scalable data solutions.* Support delivery of data products and reporting capabilities aligned with organizational objectives.* Provide guidance and mentorship to junior data engineers and analysts.* Promote engineering standards, documentation practices, and technical excellence across the team.* Research, evaluate, and recommend emerging technologies, tools, and methodologies to improve data engineering capabilities.Required Qualifications* Bachelor's degree in computer science, Information Systems, Engineering, Data Analytics, or a related field.* 8+ years of experience in data engineering, ETL development, data warehousing, and analytics solutions.* Advanced expertise in SQL development, database design, query optimization, and performance tuning.* Strong experience with ETL/ELT development and enterprise data integration platforms.* Proven experience supporting production data environments and troubleshooting complex data issues.* Hands-on experience with semantic modeling, analytical data structures, and business intelligence platforms.* Strong knowledge of dimensional modeling, star schema design, and data warehouse architecture.* Experience developing and optimizing analytical calculations and reporting datasets.* Excellent problem-solving, analytical, and root-cause analysis skills.* Strong written and verbal communication skills with the ability to work across technical and business teams.Preferred Qualifications* Experience with cloud-based data integration and orchestration platforms.* Familiarity with modern cloud data warehouses and analytics platforms.* Experience working within cloud environments and data architecture frameworks.* Knowledge of scripting and automation tools such as Python, PowerShell, or similar technologies.* Experience with multiple relational database platforms and data processing technologies.* Familiarity with enterprise data catalog and metadata management solutions.* Understanding of business functions such as Finance, Human Resources, Operations, Project Costing, or similar domains.* Experience validating and reconciling data across analytical and operational systems.* Strong quality assurance and data governance mindset.Success in This RoleIn this role, you will:* Ensure stable, reliable, and scalable enterprise data pipelines.* Deliver high-performing data models that enable actionable business insights.* Improve data quality, accessibility, and operational efficiency.* Support business-critical reporting and analytics initiatives.* Drive modernization of data architecture and semantic modeling capabilities.* Serve as a trusted technical leader and mentor within the data organization.* Contribute to the long-term data strategy and analytics vision of the company.Matrix is a global, dynamic, and fast‐growing technology services and consulting company with **over 17,000 employees worldwide**. Founded in 2001, Matrix has grown through significant organic expansion and strategic acquisitions, executing some of the largest and most impactful technology projects in the market.We specialize in the design, development, and implementation of advanced technologies, software solutions, and digital products. Our services include infrastructure and consulting, IT outsourcing and offshore delivery, training and assimilation programs, and acting as a trusted implementation and delivery partner for the world’s leading software vendors.With deep expertise across both the private and public sectors—spanning **Finance, Telecom, Healthcare, Hi‐Tech, Education, Defense, and Security**—Matrix serves a strong customer base in Israel alongside a continuously expanding global client portfolio.At Matrix, our people are at the heart of our success. We are a community of talented, creative, and dedicated professionals who are passionate about innovation and excellence. We actively attract, develop, and retain top talent, recognizing that every employee’s contribution is critical to our continued growth and future success.Matrix’s success is built on a **challenging and engaging work environment**, competitive compensation and benefits, and meaningful career development opportunities. We foster a diverse, inclusive culture that encourages collaboration, continuous learning, and growth—together.Join the winning team. Be challenged, grow your career, and enjoy the journey in a highly respected global organization.**To learn more, visit:** www.matrix-ifs.comEQUAL OPPORTUNITY EMPLOYER: Matrix is an Equal Opportunity Employer and Prohibits Discrimination and Harassment of Any Kind. Matrix is committed to the principle of equal employment opportunity for all employees, providing employees with a work environment free of discrimination and harassment. All employment decisions at Matrix are based on business needs, job requirements, and individual qualifications, without regard to race, color, religion or belief, family or parental status, or any other status protected by the laws or regulations in our locations. Matrix will not tolerate discrimination or harassment based on any of these characteristics. Matrix encourages applicants of all ages*.*