Senior Data Engineer: HR Analytics & BI Pipelines

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

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.