Want to know if this job is worth applying to?
Nashville, Tennessee, United States
Hybrid
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.
Job Summary
CAA is seeking a Lead Data Engineer with deep expertise in data engineering, data architecture, database development, and data modeling to provide technical leadership within our Product Development data engineering team. This role will drive 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.
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 optimization, 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 prioritize 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.
Languages and Frameworks
Expert level experience with production Microsoft SQL Server, including data modeling, schema design, stored procedure development, query optimization, indexing strategies, execution plan analysis, and performance tuning.
Strong hands-on experience with MongoDB, including document modeling and integration with relational systems.
Strong experience designing scalable database architectures for enterprise applications.
Experience designing data services, as well as working with JSON data structures.
Tools
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.
Education
Bachelor's degree in Computer Science, Information Systems, Engineering, or a related technical field.
Focus
6-8 years working in Data Engineering with a strong focus on SQL Server.
Minimum 3+ years leading a technical team.
We expect you to have a passion and experience in shipping and maintaining production software products.
You must have strong verbal and written skills.
We are most interested in candidates who want to work in an environment where attention to detail, problem solving, simplicity, quality, and agility are highly prized.
Environment
This role is hybrid, with two days per week working in the office and three days working remotely.
We foster a service-oriented, highly collaborative environment where teamwork, care, and helping others succeed are highly valued.
Location
This role is hybrid, based in our Nashville office.
Compensation
The annual base salary for this position is in the range of $151,000 - $168,000 in Nashville. This position is also eligible for benefits and a discretionary bonus. Ultimately, the salary may vary based upon, but not limited to, relevant experience, time in the role, business sector, and geographic location, among other criteria. Please talk with a CAA Recruiter to learn more.