Senior Data Engineer

Senior Data EngineerThe 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. It is a deep-technical senior individual-contributor role without direct reports.Key Responsibilities1. Legacy SQL Estate — Support & ModernizationSupport, 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.2. 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.3. Data Modeling & Analytics-Ready DataBuild 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.4. High Availability & Disaster RecoveryEnsure 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.5. Data Governance, Privacy & Regulatory OperationalizationContribute 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.6. Database Depth & DBA SuccessionBring 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 Qualifications7+ 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 QualificationsMicrosoft 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 OpportunityWME 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.Per local requirements and in the interest of transparency, the rate shown below reflects the prevalent current hiring range for this position. Hiring pay rates are based on a number of factors, including location and may vary depending on job-related qualifications, knowledge, skills and experience. The company strives to provide locally competitive rewards packages, which include base rate along with, as applicable, short- and long-term incentives, growth and developmental opportunities, and robust benefits, such as health care, retirement, vacation and other paid time off, and additional offerings.Hiring Rate Minimum:$127,500 annually (minimum will not fall below the applicable state/local minimum salary thresholds)Hiring Rate Maximum:$170,000 annuallyWME is an equal opportunity employer and encourages applications from qualified and eligible candidates regardless of sex, race, disability, age, sexual orientation, or religion or belief.