Lead Data Engineer (T2)

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

• Lead data engineering execution in support of complex application development initiatives, ensuring data integrations, pipelines, and models align with established architectural standards 

• You and your teammates will work collaboratively with other engineers to design, build, and execute data migrations between systems, including data mapping, transformation, validation, and reconciliation to help ensure data accuracy and completeness across environments. 

• You will use your software development skills in an agile environment to develop new data pipelines, APIs, and data management tools and your experience with continuous delivery will support the end-to-end lifecycle: design, deployment, test, operations, monitoring and support. 

Languages and Frameworks 

• Proficiency in Python with a history of delivering production pipelines. 

• Experience building production scripts or services used for data movement and validation.  

• Experience with the Azure data stack (Azure Data Factory, Azure Data Lake, Tabular Model / DAX, Microsoft Fabric) is preferred, though strong experience with comparable technologies is also valued. 

• We’d like to see real SQL and NoSQL production experience.  

• We’re particularly interested in your expertise with SQL Server and MongoDB.  

• You should be comfortable modeling data, analyzing source and target schemas, writing complex queries, and resolving data quality issues during migration. 

Tools 

• Experience maintaining projects using a distributed version control system such as Git and GitHub.  

• Experience in automated pipeline deployment and schemas into production environments would be great. 

• You should be experienced with agile methods and the concepts behind continuous delivery.  

• We expect you to be passionate about developing migrations, data structures, pipelines, and APIs, so we want to see your experience with security, testing, performance, JSON, and REST.  

• We are eager to hear about your experience and opinions around data quality, test strategy, and test automation. 
   

Focus 

• 6-8 years of job-related experience

• We expect you to have a passion for and experience shipping and maintaining production software products and data migrations.  

• 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, solving problems, simplicity, quality, and moving quickly are highly prized. 
   

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.