Senior Data Engineer, HR Data & Analytics

FTI Consulting, Inc.; Washington (District of Columbia); On-site; USD 122,000 - 213,000; Full time

Job summary

FTI Consulting is seeking a Senior Data Engineer to join the HR Data & Analytics team. This role designs, builds, and optimizes scalable data solutions that enable business intelligence, reporting, analytics, and decision-making across the organization.

The ideal candidate brings deep expertise in SQL, data integration, data modeling, and Power BI, with collaboration across HR stakeholders, analysts, data scientists, and technology teams to deliver reliable, scalable data platforms.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field.
• 5+ years of experience in data engineering, data warehousing, or business intelligence development.
• Experience with SQL Server / T-SQL, ETL/ELT, Data Modeling, Power BI, DAX, MDX, Data Warehousing, Database Design & Optimization, Git / Azure DevOps, VS, VS Code.
• Travel to clients and FTI offices is required.
• Applicants must be authorized to work in the United States on a full-time basis; visa sponsorship is not provided.

Responsibilities

• Design, develop, and maintain enterprise-grade data pipelines and integration solutions.
• Build and optimize data warehouse, data lake, and semantic models to support analytics and reporting needs.
• Lead data modeling efforts, including conceptual, logical, and physical data models.
• Develop robust ETL/ELT processes to ingest, transform, and manage data from multiple source systems.
• Create scalable and performant SQL solutions for complex business requirements.
• Support and enhance Power BI datasets, data models, and reporting architectures.
• Ensure data quality, governance, and security across the data ecosystem.
• Collaborate with business and technical stakeholders to translate requirements into technical solutions.
• Troubleshoot and resolve performance bottlenecks across databases, integrations, and reporting platforms.
• Contribute to data architecture decisions and establish engineering best practices.

Skills

SQL Server / T‑SQL

Data Integration ETL/ELT

Data Modeling

Power BI

DAX

MDX

Data Warehousing

Git / Azure DevOps

VS / VS Code

REST APIs

Azure Data Services

Education

Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field

Tools

C#

Python

Microsoft Fabric

Azure Data Factory

Azure SQL

Azure Databricks

Azure Functions

SSRS

Job description

Who We Are

FTI Consulting is the leading global expert firm for organizations facing crisis and transformation. We work with many of the world’s top multinational corporations, law firms, banks and private equity firms on their most important issues to deliver impact that makes a difference. From resolving disputes, navigating crises, managing risk and optimizing performance, our teams respond rapidly to dynamic and complex situations. At FTI Consulting, you’ll work side‑by‑side with leaders who have shaped history, helping solve the biggest challenges making headlines today. From day one, you’ll be an integral part of a focused team where you can make a real impact. You’ll be surrounded by an open, collaborative culture that embraces diversity, recognition, professional development and, most importantly, you. Are you ready to make your impact?

About the Role

We are seeking a highly skilled Senior Data Engineer to join our HR Data & Analytics team. This role is responsible for designing, building, and optimizing scalable data solutions that enable business intelligence, reporting, analytics, and decision‑making across the organization. The ideal candidate brings deep expertise in SQL, data integration, data modeling, and Power BI, along with strong experience building modern data platforms and pipelines. This individual will collaborate closely with HR stakeholders, analysts, data scientists, and technology teams to deliver reliable, scalable, and high‑performance data solutions.

Key Responsibilities

• Design, develop, and maintain enterprise‑grade data pipelines and integration solutions.
• Build and optimize data warehouse, data lake, and semantic models to support analytics and reporting needs.
• Lead data modeling efforts, including conceptual, logical, and physical data models.
• Develop robust ETL/ELT processes to ingest, transform, and manage data from multiple source systems.
• Create scalable and performant SQL solutions for complex business requirements.
• Support and enhance Power BI datasets, data models, and reporting architectures.
• Ensure data quality, consistency, governance, and security across the data ecosystem.
• Collaborate with business and technical stakeholders to translate requirements into technical solutions.
• Troubleshoot and resolve performance bottlenecks across databases, integrations, and reporting platforms.
• Contribute to data architecture decisions and establish engineering best practices.

How You’ll Grow

We are committed to investing and supporting you in your professional development and we have developed a range of programs focused on fostering leadership, growth and development opportunities. We aim to promote continuous learning and individual skills development through on‑the‑job learning, self‑guided professional development courses and certifications. You’ll be assigned a dedicated coach to mentor, guide and support you through regular coaching sessions and serve as an advocate for your professional growth. As you progress through your career at FTI Consulting, we offer tailored programs for critical professional milestones to ensure you are prepared and empowered to take on your next role.

What You Will Need to Succeed

Basic Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field.
• 5+ years of experience in data engineering, data warehousing, or business intelligence development.
• Must have experience with the following - SQL Server / T‑SQL, Data Integration (ETL/ELT), Data Modeling, Power BI, RLS, DAX, MDX, Data Warehousing, Database Design & Optimization, Git / Azure DevOps, VS, VS Code.
• This role requires travel to clients and FTI offices.
• Applicants must be currently authorized to work in the United States on a full-time basis; this position does not provide visa sponsorship.

Preferred Qualifications

• Advanced expertise in SQL development and performance tuning.
• Strong experience designing and implementing data integration solutions, ETL/ELT pipelines, Medallion architecture.
• Deep understanding of data modeling principles, including multidimensional modeling, snowflake-schema and star-schema design.
• Advanced experience with Power BI, including semantic models, DAX, performance optimization, and enterprise reporting.
• Experience working with large and complex datasets in enterprise environments.
• Knowledge of data governance, master data management, and security best practices.
• Strong analytical, problem‑solving, and communication skills.
• Experience supporting HR, Finance, Sales, or enterprise analytics environments.
• Experience with Agile development methodologies and DevOps practices.
• Strong documentation skills.
• Experience developing applications and integrations using C#/.NET and/or Python.
• Hands‑on experience with Microsoft Fabric, including Lakehouse, Warehouse, Data Pipelines, and OneLake.
• Strong knowledge of REST APIs, web services, and system integrations.
• Experience with Microsoft Azure data and analytics services (Azure Data Factory, Azure SQL, Azure Databricks, Azure Functions).

Technical Skills

• C#, Python, SSRS, Microsoft Fabric, Azure Data Services, REST APIs.

Equal Opportunity Statement

FTI Consulting is an equal opportunity employer and does not discriminate on the basis of race, color, national origin, ancestry, citizenship status, protected veteran status, religion, physical or mental disability, marital status, sex, sexual orientation, gender identity or expression, age, or any other basis protected by law, ordinance, or regulation.

Compensation

• Minimum Pay: $122,000
• Maximum Pay: $213,000
• Compensation Disclosure: The compensation range reflects potential base salary for the role. Actual compensation is determined based on a wide array of relevant factors including market considerations, business needs, and an individual’s location, skills, level of experience, and qualifications.

Company Overview

With more than 8,100+ employees located in 32 countries and territories around the globe, we are the leading global expert firm for organizations facing crisis and transformation. Our experts have led organizations, shaped policy, driven investigations, managed crises, advised world leaders and built businesses from the ground up. Learn more about the work we do and how we're helping clients around the world turn their biggest challenges and opportunities into stories of success. Learn more about our impact. We are committed to creating an inclusive culture where our people can grow and achieve their full potential. To learn more about FTI Consulting, visit www.fticonsulting.com/careers and connect with us on Instagram and LinkedIn.