HR Data Engineer

Job Description

Who We Are

Creative Artists Agency (CAA) is the leading entertainment and sports agency, with global expertise in filmed and live entertainment, digital media, publishing, sponsorship sales and endorsements, media finance, consumer investing, fashion, trademark licensing, and philanthropy. Distinguished by its culture of collaboration and exceptional client service, CAA’s diverse workforce identifies, innovates, and amplifies opportunities for the people and organizations that shape culture and inspire the world. The trailblazer of the agency business, CAA was the first to build a sports business, create an investment bank, launch a venture fund, found technology start-up companies, establish a philanthropic arm, build a business in China, and form a brand marketing services division, among other innovations. Named Most Valuable Sports Agency by Forbes for eight consecutive years, CAA represents more than 2,000 of the world’s top athletes in football, baseball, basketball, hockey, soccer, in addition to coaches, on-air broadcasters, and sports personalities and works in the areas of broadcast rights, corporate marketing initiatives, social impact, and sports properties for sales and sponsorship opportunities. Founded in 1975, CAA is headquartered in Los Angeles, and has offices in New York, Nashville, Memphis, Chicago, Miami, London, Munich, Geneva, Stockholm, Shanghai, and Beijing, among other locations globally.

The Role

CAA is seeking anHR Data Engineerto join its CorporateHuman Resources People Analytics Team, based in LA. The candidate will report to the Head ofHRData, andplay a critical role inleveragingdata to drive HR strategies,optimizeworkforce planning, and enhance employee experiences. This position involves designing, building, andmaintainingdata pipelines, analytics solutions using Microsoft Fabric,Workdayand related tools. The role focuses on transforming HR data into actionable insights forareas such astalent acquisition,compensation,performance management, employee engagement, and compliance. The successful candidate will ensure data accuracy, governance, and security while supporting enterprise-widepeopleanalytics initiatives.

Responsibilities

• Design, implement, and manage data pipelines and ETL processes using Microsoft Fabric to ingest, transform, and store HR data from sources like Workday.

• Create andmaintainFabric workspaces, includingOneLakestorage, shortcuts, and semantic models for efficient data modeling and analysis.

• Assistin the development ofadvanced reports, dashboards, and visualizations using Power BI (with DAX queries) and Workday reporting tools (e.g., Workday Prism) to provide insights on HR metrics such as employee turnover, diversity, recruitment efficiency, and compensation trends.

• Perform data analysis and ad-hoc queries using SQL/T-SQL to support HR decision-making, ensuring data quality, privacy, and compliance with regulations like GDPR or CCPA.

• Optimizedata governance, security (e.g., Row-Level Security, Object-Level Security), and performance through monitoring tools like Fabric Monitoring Hub.

• Collaborate with cross-functional teams to gather requirements, conduct quarterly data reviews, and implement system enhancements or migrations.

• Support real-time analytics, event-driven architectures, and automation scripting to improve HR processes like performance-based assessments and workforce planning.

• Mentor junior team members on best practices in data engineering, analytics, and HR technology; document processes andmaintaincompliance with ethical principles.

Qualifications

• More than5years of professional experience in data engineering, data science, analytics, or a similar role, preferably in HR orpeopleanalytics environments.

• Hands-on experience creating andmaintainingMicrosoft Fabric workspaces, including data ingestion, transformation, and orchestration.

• Proventrack recordworking with Workday HCM for configuration, reporting, and integrations.

• Experience in HR data management, including employee lifecycle processes (e.g., recruiting, development, engagement, workforce planning).

Skills and Knowledge

• Proficiencyin Microsoft Fabric ecosystem (e.g., Synapse Data Engineering, Data Warehouse, Real-Time Analytics,OneLake).

• Strong knowledge of SQL/T-SQL for querying and data manipulation.

• Expertisein Power BI, including DAX for advanced calculations and visualizations.

• Proficiencyin Python for data processing, machine learning, and scripting

• Knowledge of semantic models (e.g., in Power BI or Fabric for data modeling and relationships).

• Familiarity with data governance, compliance, and security practices

• Understanding ofETL orchestration, performance tuning, and big data technologies.

Location
This role is hybrid, based out of the Los Angeles office.

Compensation
The annual base salary for this position is in the range of $132,000 -$170,000. This position also is eligible for benefits and discretionary bonus. Ultimately, the salary may vary based upon, but not limited to, relevant experience, time in role, business sector, and geographic location, among other criteria. Please talk with a CAA Recruiter to learn more.

Creative Artists Agency, LLC (the “Company”) is committed to a policy of Equal Employment Opportunity and will not discriminate on the basis of race (inclusive of traits historically associated with race, including hair texture and protective hairstyles), color, religion, creed, gender or sex (including pregnancy, childbirth, breastfeeding or related medical conditions), national origin, ancestry, age, physical disability, mental disability, medical condition, genetic information, family and medical care leave status, military or veteran status, marital status, family status, sexual orientation, gender identity, gender expression, political affiliation, an employee’s or their dependent’s reproductive health decision making (e.g., the decision to use or access a particular drug, device or medical service), or any other characteristic protected by applicable law.The absence of a permanent address is not a bar to employment. The Company does not discriminate against individuals based on housing status, including the absence of a fixed address.The Company also complies with the Americans with Disabilities Act and applicable state and local laws with regard to providing reasonable accommodation for qualified individuals with disabilities.CAA does not accept unsolicited resumes from third-party recruiters unless they were contractually engaged by CAA to provide candidates for a specified opening. Any such employment agency, person or entity that submits an unsolicited resume does so with the acknowledgement and agreement that CAA will have the right to hire that applicant at its discretion without any fee owed to the submitting employment agency, person or entity.