Senior Data Engineer

IMG LIVE; Beverly Hills (CA); On-site; USD 127,500 - 170,000; Full time

Job summary

WME Enterprise IT is seeking a Senior Data Engineer to own and modernize the SQL data estate that underpins analytics and reporting across our global footprint. You’ll stabilize legacy environments, build ELT pipelines from multiple sources, and partner with the enterprise architect on governance and privacy.

Responsibilities include ensuring high availability with disaster recovery, delivering analytics‑ready datasets for BI, reporting, and AI, and advancing data governance to meet GDPR/CCPA

Qualifications

• 7+ years in data and/or database engineering.
• Deep SQL and SQL Server administration (T‑SQL, maintenance, troubleshooting).
• Experience modernizing legacy SQL/database environments (consolidation, upgrades, migration).
• DPA/DR concepts: Always On, backup & restore, RTO/RPO planning.

Responsibilities

• Support, stabilize, and maintain legacy SQL databases behind applications.
• Build and modernize ELT pipelines from multiple source systems into a governed data store.
• Develop data models and analytics-ready datasets for BI and analytics.
• Ensure high availability, disaster recovery planning, and testing.
• Contribute to data governance, privacy, and regulatory operationalization (GDPR, CCPA).
• Grow toward broader database ownership and knowledge transfer.

Skills

SQL Server administration

ELT / pipelines

Data modeling

Regulatory compliance knowledge

Tools

SAP integration

Power BI datasets

Microsoft Purview

Job description

Position Summary

The Senior Data Engineer owns and modernizes WME Enterprise IT's SQL data estate — the databases behind the custom applications the product and engineering teams build, the legacy SQL environment those applications run on, and the pipelines that turn that data into trusted, query-ready information for analytics and reporting. This role does not inherit a modern, greenfield data platform; it inherits a working legacy SQL environment and helps set and drive the strategy to stabilize and modernize it. The role manages and supports the databases behind the custom product and engineering applications, keeps that data highly available with sound disaster-recovery planning, and builds the pipelines and analytics-ready data that reporting and BI are built on. It brings deep SQL and SQL Server expertise, works within the enterprise data architecture standards set by the Principal Enterprise Architect, partners with the Senior DBA on the database estate — developing toward broader database ownership over time — and partners with the Sr Manager, GRC on data governance and privacy. WME operates across a global footprint spanning the Americas, EMEA, and APAC, so the role must know how to operationalize data‑privacy and regulatory requirements — GDPR, CCPA, and regional equivalents — at the data layer. The data it delivers serves analytics, reporting, and — increasingly — AI.

Key Responsibilities

• Legacy SQL Estate — Support, stabilize, and maintain the legacy SQL databases behind the custom product / engineering applications — performance, reliability, and availability. Help set and drive the strategy to modernize the legacy SQL environment — consolidation, upgrades, and migration toward a governed, better‑managed data estate. Partner with the Principal Enterprise Architect on the database and data side of legacy modernization.
• Data Pipelines & Integration (ELT) Build and modernize pipelines from source systems — the custom applications, SAP, and business systems — into a governed data store. Own pipeline orchestration and scheduling; engineer resilient, observable pipelines with clear failure handling and recovery. Integrate SAP as a major source, in partnership with the SAP program.
• Data Modeling & Analytics‑Ready Data Build the data models and analytics‑ready datasets that BI, reporting, and analytics are built on. Provide well‑structured, trustworthy data so the business and analysts can build their own reports — deliver the data behind the reports, not the reports themselves. Serve analytics, reporting, and AI consumers of the data.
• High Availability & Disaster Recovery Ensure the databases and data estate are highly available — redundancy, failover, and resilience matched to each system's criticality. Own database backup, restore, and disaster‑recovery planning and testing. Set and meet recovery objectives (RTO / RPO) for critical data, in partnership with infrastructure and BCDR.
• Data Governance, Privacy & Regulatory Operationalization Contribute at a foundational level to data governance — quality, classification, lineage, and stewardship — in partnership with the GRC function. Operationalize data‑privacy and regulatory requirements at the data layer — GDPR, CCPA, and regional equivalents — across WME's global footprint: data residency, retention, minimization, and support for data‑subject rights. Implement the data controls GRC defines, including SOX‑relevant controls, and produce the supporting evidence.
• Database Depth & DBA Succession Bring deep SQL Server administration to the estate — T‑SQL, tuning, maintenance, and troubleshooting. Develop database‑administration depth through structured mentorship from the Senior DBA, growing toward broader database ownership over time. Maintain runbooks, documentation, and knowledge transfer; apply AI‑assisted engineering where it adds value.

Required Qualifications

• 7+ years in data and/or database engineering, with progressive responsibility.
• Deep SQL and SQL Server administration — T‑SQL, query optimization, maintenance, and troubleshooting of application databases.
• Experience modernizing legacy SQL / database environments — consolidation, upgrades, and migration.
• Database high availability and disaster recovery — Always On / clustering, backup and restore, and recovery planning (RTO / RPO).
• ELT / pipeline engineering and integration from multiple source systems, including databases behind custom applications.
• Data modeling and analytics‑ready datasets; Power BI semantic models / datasets (the data layer behind reports) a plus.
• Foundational data governance, and experience operationalizing data‑privacy regulation — GDPR, CCPA, or equivalents — at the data layer (residency, retention, subject rights).

Preferred Qualifications

• Microsoft certifications — Azure Database Administrator (DP‑300), Azure Data Engineer (DP‑700 / DP‑203), or SQL Server administration.
• Data‑privacy certification (e.g., IAPP CIPP/E or CIPP/US) or hands‑on GDPR / CCPA operational experience.
• Database HA/DR technologies (Always On, log shipping, replication) and backup / recovery tooling.
• SAP data integration experience; data catalog / governance tooling (Microsoft Purview or equivalent).
• Background in media, entertainment, or other high‑confidentiality, multi‑region environments.

Equal Employment Opportunity

WME is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other characteristic protected by applicable law.

Compensation

• Hiring pay rates are based on a number of factors, including location and may vary depending on job‑related qualifications, knowledge, skills and experience.
• Hiring Rate Minimum: $127,500 annually (minimum will not fall below the applicable state/local minimum salary thresholds)
• Hiring Rate Maximum: $170,000 annually