Lead Data Engineer (T2)

Global Sports Jobs Limited; Nashville (TN); Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Medical insurance

Basic Life and AD&D Insurance

Telemedicine

Paid Vacation / Holidays

Paid Sick Time

Paid Parental Leave

Educational Assistance

Job summary

Creative Artists Agency (CAA) is seeking a Lead Data Engineer to provide technical leadership in the Product Development data engineering team. You will drive design, development, and evolution of scalable data solutions supporting enterprise applications in a global entertainment environment.

The role demands deep expertise in SQL Server, MongoDB, data modelling, and architecture, with responsibilities spanning standards, CI/CD, and cross-functional collaboration.

Qualifications

• Expert-level production Microsoft SQL Server experience with data modelling and performance tuning.
• Strong MongoDB experience including document modelling and relational integration.
• Experience designing scalable enterprise database architectures.
• Experience designing data services and working with JSON data structures.
• Experience implementing automated database deployments and schema migration in CI/CD.
• Strong understanding of Agile software development and Continuous Delivery practices.
• Experience implementing automated testing, database monitoring, and deployment practices.
• Experience managing projects with Git/GitHub and distributed version control.
• Experience collaborating across cross-functional engineering teams in large-scale environments.
• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.
• 6-8 years in Data Engineering focusing on SQL Server.
• Minimum 3+ years leading a technical team.
• Strong verbal and written communication skills.

Responsibilities

• Lead the data engineering team across multiple application initiatives, ensuring data models, database objects, integrations, and pipelines align with enterprise architecture and standards.
• Mentor and provide technical leadership to the Data Engineering team, supporting workload planning and career development.
• Lead design, development, and maintenance of SQL Server databases, including schema design, indexing, and stored procedures.
• Establish and enforce database development standards, naming conventions, coding guidelines, and performance practices.
• Lead document schema design while ensuring integration between relational and NoSQL stores.
• Partner with Software Engineering, Architecture, Product Management, QA, and DevOps to ensure scalable and maintainable data solutions.
• Prioritise work, estimate effort, identify risks, and ensure successful delivery of data initiatives.
• Lead code and schema reviews for high-quality data, security, and maintainability.

Skills

SQL Server

MongoDB

Data modelling

Database design

CI/CD

Agile

Git/GitHub

Communication

Leadership

Education

Bachelor's degree in Computer Science or related field

Tools

GitHub

Job description

About the Role

CAA is seeking a Lead Data Engineer with deep expertise in data engineering, data architecture, database development, and data modelling to provide technical leadership within the Product Development data engineering team. The role drives the design, development, and evolution of scalable data solutions that support CAA's enterprise applications. The Product Development team designs and builds software experiences that support CAA's diverse, global, and high-energy entertainment industry culture of agents, executives, artists, and business partners.

Key Responsibilities

• Lead the data engineering team across multiple application development initiatives, ensuring data models, database objects, integrations, and pipelines align with enterprise architecture and application standards.
• Manage, mentor, and provide technical leadership to the Data Engineering team, supporting workload planning, career development, and engineering excellence.
• Lead the design, development, and maintenance of SQL Server databases, including schema design, indexing strategies, query optimisation, and stored procedure development.
• Establish and enforce database development standards, naming conventions, coding guidelines, performance standards, and best practices.
• Lead document schema design while ensuring appropriate integration patterns between relational and NoSQL data stores.
• Partner closely with Software Engineering, Architecture, Product Management, QA, and DevOps teams to ensure data solutions support application scalability, maintainability, and performance.
• Work with leadership to prioritise work, estimate effort, identify technical risks, and ensure successful delivery of data engineering initiatives.
• Lead database code and schema reviews, ensuring high standards for data quality, performance, security, and maintainability across the team.

Required Experience & Qualifications

• Expert-level experience with production Microsoft SQL Server, including data modelling, schema design, stored procedure development, query optimisation, indexing strategies, execution plan analysis, and performance tuning.
• Strong hands-on experience with MongoDB, including document modelling and integration with relational systems.
• Strong experience designing scalable database architectures for enterprise applications.
• Experience designing data services and working with JSON data structures.
• Experience implementing automated database deployments and schema migration processes within CI/CD pipelines.
• Strong understanding of Agile software development methodologies and Continuous Delivery practices.
• Experience implementing automated testing, database monitoring, and deployment practices.
• Experience managing projects using a distributed version control system such as Git and GitHub.
• Experience collaborating across cross-functional engineering teams in large-scale enterprise software environments.
• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related technical field.
• 6-8 years working in Data Engineering with a strong focus on SQL Server.
• Minimum 3+ years leading a technical team.
• Passion and experience in shipping and maintaining production software products.
• Strong verbal and written communication skills.

Preferred Skills

• Interest in working in an environment where attention to detail, problem solving, simplicity, quality, and agility are highly prized.

Workplace

• Hybrid role based in the Nashville office, with two days per week working in the office and three days working remotely.

Salary

• Eligible for a discretionary bonus.
• Wages may vary based upon factors including relevant experience, time in role, business sector, and geographic location, among other criteria.

Benefits & Perks

• Competitive compensation and benefits package for all regular full-time employees.
• Company pays 80%-100% of the cost for: Medical
• Basic Life and AD&D Insurance
• Telemedicine
• Employee assistance and mental health counselling in person, virtually, or through text
• Paid Vacation / Holidays
• Paid Sick Time
• Paid Parental Leave and Other Paid Leaves of Absence
• NICU leave
• Bereavement resources
• Adoption Benefits
• Educational Assistance

About the Company

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. 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.