Senior HR Data Engineer & Analytics Lead

Consulting, Inc.; United States; On-site; USD 120,000 - 180,000; Full time

Job summary

FTI Consulting is seeking a Senior Data Engineer to join the HR Data & Analytics team. You will design, build, and optimize scalable data solutions enabling BI, reporting, analytics, and informed decision-making across the organization.

Ideal candidate has deep SQL, data modeling, ETL/ELT, and Power BI expertise, plus experience with modern data platforms and pipelines in enterprise environments. Travel to clients and offices is required.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.
• 5+ years of experience in data engineering, data warehousing, or BI development.
• Experience supporting HR analytics environments.
• Proficient with SQL Server / T-SQL, 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.
• Authorized to work in the United States on a full-time basis; visa sponsorship not available.

Responsibilities

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

Skills

SQL / T-SQL

Data Warehousing

Power BI

ETL/ELT

Data Modeling

Data Integration

Git / Azure DevOps

VS / VS Code

C# / .NET

Python

REST APIs

Azure

Microsoft Fabric

Education

Bachelor's degree in Computer Science or related field

Tools

Power BI

Git / Azure DevOps

VS Code

Microsoft Fabric

Azure DevOps

Job description

FTI Consulting is seeking a Senior Data Engineer to join the HR Data & Analytics team. You will design, build, and optimize scalable data solutions enabling BI, reporting, analytics, and informed decision-making across the organization.

Ideal candidate has deep SQL, data modeling, ETL/ELT, and Power BI expertise, plus experience with modern data platforms and pipelines in enterprise environments. Travel to clients and offices is required.