Hiring: Talent Acquisition Data Engineering & Analytics Specialist

Location: Rancho Cordova, CA
Job Type: Contract
Work Mode: Onsite/ Remote
About the Role

We are looking for a Data Engineering & Analytics Specialist to build end-to-end Talent Acquisition reporting solutions. The role involves developing ETL/ELT pipelines, cloud data warehouse integration, dimensional data modeling, and Power BI dashboards with automated refresh and governed reporting.

Required Qualifications

• Bachelor's degree in Data Analytics, Data Science, Data Engineering, Computer Science, Information Systems, or a related field; or equivalent practical experience.
• 4+ years of professional experience delivering production analytics or data engineering solutions.
• Advanced SQL, including complex joins, aggregations, window functions, and query optimization against large datasets.
• Demonstrated Power BI delivery experience, including authoring DAX measures, designing semantic models, and publishing to Power BI Service.
• Hands-on experience with a cloud data warehouse platform (e.g., BigQuery, Redshift, Databricks, Snowflake, or comparable).
• Proven experience designing and implementing dimensional data models in a production environment.
• Experience building and maintaining ETL/ELT pipelines, including incremental loads and failure handling.
• Proficiency in Python (or R) for data extraction, transformation, and analysis.
• Demonstrated ability to translate ambiguous business questions into structured, measurable analytics requirements and to drive stakeholder agreement on metric definitions.
• Experience documenting technical solutions and enabling non-technical end users.

Preferred Qualifications

• Experience with Snowflake.
• Experience with Power BI Service administration: workspaces, gateways, deployment pipelines, and row-level security.
• Experience with orchestration and transformation tooling (dbt, Airflow, Azure Data Factory).
• Experience with APIs and system-to-system data integrations.
• Experience with HR or Talent Acquisition source systems, particularly SmartRecruiters or Workday.
• Experience with Workday Prism Analytics or Workday Data Cloud.
• Experience with large datasets in cloud environments (Azure, AWS, or Google Cloud Platform).
• Proficiency with version control (Git) and analytics engineering practices.
• Prior experience delivering analytics solutions in a contract or consulting capacity, including structured handover.
• Familiarity with AI/ML techniques and interest in applying them to workforce data.
• Interest in HR, Talent Acquisition, or workforce analytics and how data informs business strategy.

Technical Skills

• Cloud data warehouse platforms (BigQuery, Redshift, Databricks, Snowflake)
• SQL (advanced) and query optimization
• Power BI (authoring, DAX, semantic models, Power BI Service)
• Data modeling (dimensional, star schema, slowly changing dimensions)
• ETL/ELT pipeline development
• Python/R data transformation
• APIs and system integrations
• Data quality frameworks and monitoring
• Git and version control