Senior Data Engineer, HR Data & Analytics
About The Position
FTI Consulting is seeking a Senior Data Engineer to join its HR Data & Analytics team. The role designs, builds, and optimizes scalable data solutions that enable business intelligence, reporting, analytics, and organizational decision-making. The ideal candidate has expertise in SQL, data integration, data modeling, and Power BI, as well as experience building modern data platforms and pipelines. The engineer collaborates with HR stakeholders, analysts, data scientists, and technology teams to deliver reliable, scalable, high-performance solutions. The role requires travel to clients and FTI offices. Applicants must be authorized to work in the United States on a full-time basis; visa sponsorship is not provided. FTI Consulting describes a professional development program that includes on-the-job learning, self-guided courses and certifications, a dedicated coach, and tailored programs for career milestones.
Requirements
- Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field.
- At least 5 years of experience in data engineering, data warehousing, or business intelligence development.
- Experience supporting HR enterprise analytics environments.
- Experience with SQL Server/T-SQL, data integration (ETL/ELT), data modeling, Power BI, RLS, DAX, MDX, data warehousing, database design and optimization, Git/Azure DevOps, Visual Studio, and VS Code.
- Must be currently authorized to work in the United States on a full-time basis; the position does not provide visa sponsorship.
- Ability to travel to clients and FTI offices.
Nice To Haves
- Advanced expertise in SQL development and performance tuning.
- Experience designing and implementing data integration solutions, ETL/ELT pipelines, and Medallion architecture.
- Deep understanding of data modeling principles, including multidimensional modeling and snowflake- 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 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, including Azure Data Factory, Azure SQL, Azure Databricks, and Azure Functions.
- Technical skills in C#, Python, SSRS, Microsoft Fabric, Azure Data Services, and REST APIs.
Responsibilities
- Design, develop, and maintain enterprise-grade data pipelines and integration solutions.
- Build and optimize data warehouses, data lakes, and semantic models for analytics and reporting.
- Lead conceptual, logical, and physical data modeling efforts.
- Develop ETL/ELT processes to ingest, transform, and manage data from multiple source systems.
- Create scalable, 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.
Benefits
- Professional development through on-the-job learning, self-guided courses, and certifications.
- A dedicated coach providing mentoring, guidance, and support through regular coaching sessions.
- Tailored programs for critical professional milestones and career progression.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
