HR Data Analyst

Dexian; Houston (TX); On-site; USD 80,000 - 110,000; Full time

Job summary

Dexian is seeking an experienced HR Data & Reporting Analyst to support HR data integrations and reporting. The role focuses on migrating data workflows from a cloud-based system to an internally developed platform, leveraging strong SQL skills and HR reporting expertise.

You will design and maintain HR dashboards, track metrics like headcount, turnover, DEI, and compensation, and collaborate with HR and People teams to deliver data-driven solutions.

Qualifications

• Strong SQL skills with complex joins, query optimization, and stored procedures.
• Experience with HR data sources like HRIS, payroll, or workforce analytics.
• Experience creating reports and dashboards using Power BI, Tableau, or similar tools.
• Solid understanding of data extraction, transformation, and loading (ETL) concepts.
• Ability to work with custom systems and limited documentation.

Responsibilities

• Write, optimize, and maintain complex SQL queries for HR data sources.
• Design, develop, and maintain HR reporting and dashboards (headcount, turnover, DEI, comp analysis).
• Support migration of data pipelines from cloud to internal system.
• Collaborate with HR and People teams to translate reporting needs into data solutions.
• Document data lineage, transformations, and migration decisions.
• Ensure data quality, security, and compliance with HR data handling standards.

Skills

SQL

HR data

Reporting tools

ETL concepts

Custom systems

Tools

Power BI

Tableau

Job description

We are seeking an experienced HR Data & Reporting Analyst to support HR data integrations and reporting. This role involves migrating existing data workflows from a cloud-based system to an internally-developed platform. The ideal candidate will have strong SQL skills and expertise in HR reporting. Prior experience with cloud data tools is a plus but not required.

Position Summary

We are seeking an experienced HR Data & Reporting Analyst to support HR data integrations and reporting. This role involves migrating existing data workflows from a cloud-based system to an internally-developed platform. The ideal candidate will have strong SQL skills and expertise in HR reporting. Prior experience with cloud data tools is a plus but not required.

Key Responsibilities

• Write, optimize, and maintain complex SQL queries for HR data sources such as HRIS, payroll, and applicant tracking systems.
• Design, develop, and maintain HR reporting and dashboards, including metrics like headcount, turnover, diversity, equity, inclusion, and compensation analysis.
• Support the migration of data pipelines from a cloud-based platform to an internal, custom-built system.
• Collaborate with HR and People teams to convert reporting needs into effective data solutions.
• Document data lineage, transformation processes, and migration decisions.
• Ensure data quality, security, and compliance with HR data handling standards, including PII sensitivity.

Required Qualifications

• Strong SQL skills, including complex joins, query optimization, and stored procedures.
• Proven experience working with HR or People data, such as HRIS, payroll, or workforce analytics.
• Experience creating reports and dashboards using tools like Power BI, Tableau, or similar platforms.
• Solid understanding of data extraction, transformation, and loading (ETL) or data integration concepts.
• Ability to work comfortably with custom systems and limited documentation.

Preferred Qualifications

• Prior hands-on experience with cloud data integration tools, such as Talend Cloud.
• Scripting experience relevant to the internal system's technology stack, such as Python.
• Background working within a corporate HR or People Analytics function.
• Familiarity with HRIS platforms such as Workday, SAP SuccessFactors, or ADP.

Why This Opportunity May Be Appealing

This position offers the chance to work on a critical data migration project within a dynamic organization. As an HR Data & Reporting Analyst, you will play a key role in enhancing HR data capabilities, working directly with HR stakeholders, and contributing to data-driven decision-making in a collaborative environment.

Dexian stands at the forefront of Talent + Technology solutions with a presence spanning more than 70 locations worldwide and a team exceeding 10,000 professionals. As one of the largest technology and professional staffing companies and one of the largest minority-owned staffing companies in the United States, Dexian combines over 30 years of industry expertise with cutting-edge technologies to deliver comprehensive global services and support. Dexian connects the right talent and the right technology with the right organizations to deliver trajectory-changing results that help everyone achieve their ambitions and goals. To learn more, please visit https://dexian.com/.

Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.