Data Engineer II

Job Description

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

CAA is seeking a developer with excellent data engineering and full stack skills to join our product development team. The product development team designs and builds software experiences for mobile and web that are uniquely valuable for CAA’s diverse, global, and high-energy entertainment industry culture of agents, executives, artists, and business partners. 

Responsibilities: You and your teammates can work collaboratively with other developers to design and deliver the data infrastructure (warehouse, schema, pipelines, OLTP, ETL) and tooling that supports CAA’s portfolio of applications and analytics tools, and we need your help building and maintaining supporting services for that infrastructure and the tooling that our users will be using to maintain the data. 

You will be able to 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. You will have the chance to directly interact with the people who are using your applications. 

Languages and Frameworks: You should be proficient in JavaScript/Typescript with a history of delivering production applications, with familiarity in frontend frameworks such as React/Angular/Vue and backend frameworks like Node/Express. We welcome candidates with experience in other languages such as Ruby/PHP.  Proficiency with Python would also be an asset.  It would be great for you to have experience in the Azure data stack (Azure Data Factory, Azure Data Lake, Tabular Model / DAX, Microsoft Fabric), but if you have strong experience with complementary open-source data technologies such as Hadoop, Amazon Glue, Spark, Airflow and so on we would love to talk to you. 

Databases: We’d like to see real SQL and NoSQL production experience. We’re particularly interested in your expertise with SQL Server, Azure Synapse, MongoDB. Having experience talking to customers and modeling data would be a plus.  If you bring specific skills in Kafka , Cassandra, or any other cloud-based warehouse