Data Engineer II

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 let’s talk. 

Tools: experience with maintaining projects using a distributed version control system such as Git and GitHub. Experience in automated deployment of pipelines and schema into production environments would be great. 

Techniques. You should be experienced with agile methods and the concepts behind continuous delivery. We expect you to be passionate about developing 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. 

Education: We prefer you have a BS in Computer Science, plus equivalent professional experience, which means between one to three years of delivering production solutions. 

Focus: We expect you to have a passion for and experience shipping and maintaining production software products to business users. You must have strong verbal, written and visual presentation 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: You can work 100% remote with occasional travel to company meetings and events. We have a service-oriented collaborative environment where teamwork and care and helping others to succeed are highly valued. 

Compensation:  The annual base salary for this position is in the range of $88,000 - $116,000 in Los Angeles,CA and New York, NY. 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.