HR Data Analyst

Dexian; Houston (TX); On-site; USD 75,000 - 105,000; Full time

Job summary

Dexian is seeking an experienced HR Data & Reporting Analyst to support data integrations and HR reporting during a migration to an internal platform. Strong SQL skills and HR data experience are essential.

The role involves designing dashboards, ensuring data quality, and collaborating with HR teams to deliver data-driven insights in a fast-paced environment.

Qualifications

• Strong SQL skills with complex joins, optimization, and stored procedures.
• Experience with HR data like HRIS, payroll, or workforce analytics.

Responsibilities

• Write and optimize SQL queries for HR data sources.
• Design and maintain HR dashboards (headcount, turnover, diversity, compensation).
• Migrate data pipelines from cloud to internal system.
• Collaborate with HR to translate reporting needs into data solutions.
• Document data lineage and transformation processes.

Skills

SQL

HR data analytics

Power BI/Tableau

ETL concepts

Documentation

Tools

Power BI

Tableau

Talend Cloud

Job description

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.