Back to Jobs
Recently postedHuman Resources

Talent Acquisition Data Engineering & Analytics Specialist

Whiz Global LLCRancho Cordova, CA🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeOn Site
LocationRancho Cordova, CA, United States
SQLGitAWSETLSnowflakeAirflowBigQueryCordovaData PipelineDatabricksGoogle CloudPythonRedshiftdbtRESTAzurePower BIJiraData AnalysisAzure Data Factory

Job description

Hiring: Talent Acquisition Data Engineering & Analytics Specialist

Location: Rancho Cordova, CA
Job Type: Contract
Work Mode: Onsite / As applicable

About the Role

We are looking for an experienced Talent Acquisition Data Engineering & Analytics Specialist to build and deliver a production-ready reporting and analytics solution for Talent Acquisition.

The ideal candidate will own the complete data lifecycle, from raw recruiting data ingestion to automated, leadership-facing Power BI dashboards. This includes establishing cloud data warehouse connectivity, developing automated ETL/ELT pipelines, designing dimensional data models, and building a comprehensive Power BI dashboard suite.

This is a technical data engineering and analytics role and does not involve operational recruiting activities.

Key Responsibilities

1. Data Pipeline & Infrastructure

  • Establish and validate connections between Talent Acquisition source systems such as SmartRecruiters, Workday, Jira, and ServiceNow.

  • Build and maintain production-grade ETL/ELT pipelines, including API-based data ingestion.

  • Configure Power BI connectivity and scheduled refresh automation.

  • Implement data quality checks, refresh monitoring, and failure-handling mechanisms.

2. Data Modeling & Transformation

  • Design and deploy dimensional data models supporting requisition, recruitment funnel, and hiring analytics.

  • Develop and optimize complex SQL queries and transformations.

  • Build historical and point-in-time reporting, including requisition status history and pipeline snapshots.

  • Define table grain, conformed dimensions, star schemas, and slowly changing dimensions (SCD).

3. Power BI Reporting & Analytics

  • Develop comprehensive Power BI dashboards covering:

    • Executive Summary

    • Requisition & Pipeline Health

    • Funnel Conversion

    • Time-to-Fill & Time-in-Stage

    • Offer Metrics

    • Sourcing Effectiveness

    • Recruiter Workload

    • Talent Acquisition Operational SLA Metrics

  • Build governed semantic models and certified DAX measures.

  • Implement Row-Level Security (RLS).

  • Optimize Power BI model performance for large datasets.

  • Publish and manage dashboards through Power BI Service.

4. Governance, Documentation & Enablement

  • Document pipeline architecture, data lineage, model diagrams, and measure definitions.

  • Develop refresh, monitoring, and troubleshooting runbooks.

  • Establish consistent metric definitions in collaboration with stakeholders.

  • Create end-user guides and conduct enablement sessions for business users.

  • Deliver complete technical documentation and knowledge transfer.

5. Stakeholder Collaboration

  • Partner with Talent Acquisition leadership to understand reporting requirements.

  • Translate business questions into measurable analytics solutions.

  • Present dashboard walkthroughs and analytical insights.

  • Independently manage priorities, risks, dependencies, and technical decisions.

Required Qualifications

  • Bachelor's degree in Data Analytics, Data Science, Data Engineering, Computer Science, Information Systems, or a related field; equivalent practical experience is also acceptable.

  • 4+ years of professional experience delivering production analytics or data engineering solutions.

  • Advanced SQL skills, including complex joins, aggregations, window functions, and query optimization.

  • Strong hands-on experience with Power BI, including DAX, semantic models, dashboard development, and Power BI Service.

  • Experience with cloud data warehouse platforms such as Snowflake, BigQuery, Redshift, or Databricks.

  • Strong understanding of dimensional data modeling and star schema architecture.

  • Experience building and maintaining ETL/ELT pipelines, incremental loads, and failure-handling processes.

  • Proficiency in Python or R for data extraction, transformation, and analysis.

  • Experience translating business requirements into structured analytics solutions.

  • Strong technical documentation and stakeholder communication skills.

Preferred Qualifications

  • Hands-on experience with Snowflake.

  • Experience with Power BI Service administration, workspaces, gateways, deployment pipelines, and Row-Level Security.

  • Familiarity with dbt, Airflow, or Azure Data Factory.

  • Experience with APIs and system integrations.

  • Exposure to HR or Talent Acquisition platforms, particularly SmartRecruiters or Workday.

  • Experience with Workday Prism Analytics or Workday Data Cloud.

  • Experience working with large datasets across Azure, AWS, or Google Cloud Platform.

  • Proficiency in Git and analytics engineering best practices.

  • Experience delivering analytics solutions in consulting or contract environments.

  • Familiarity with AI/ML techniques and workforce analytics.

Technical Skills

  • Cloud Data Warehousing: Snowflake, BigQuery, Redshift, Databricks

  • SQL: Advanced SQL, Query Optimization

  • BI & Visualization: Power BI, DAX, Semantic Models, Power BI Service

  • Data Modeling: Dimensional Modeling, Star Schema, SCD

  • Data Engineering: ETL/ELT Pipelines

  • Programming: Python / R

  • Integration: REST APIs, System Integrations

  • Data Governance: Data Quality, Monitoring

  • Version Control: Git

Key Deliverables

  • Production-ready cloud data pipelines.

  • Deployed dimensional data model.

  • Complete Power BI dashboard suite.

  • Governed semantic model with documented measures.

  • Automated refresh and data quality monitoring.

  • Technical documentation and troubleshooting runbook.

  • End-user enablement and knowledge transfer.

  • Documented operational handover and future analytics roadmap.

Similar jobs