Jr. Data Engineer

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, brand management and consumer product 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, form a brand marketing services division, and launch a family office advisory practice, among other innovations. Named Most Valuable Sports Agency by Forbes for nine consecutive years, CAA represents more than 3,000 of the world’s top athletes in football, baseball, basketball, hockey, and soccer, in addition to coaches, on-air broadcasters, and sports personalities and works in the areas of property sales and sponsorships, media advisory, brand consulting, venue development and strategic advisory, and executive search. Founded in 1975, CAA is headquartered in Los Angeles, and has offices in New York, London, Nashville, Shanghai, Beijing, Chicago, Washington D.C., Singapore, Toronto, Denver, Charlotte, Jacksonville, and Atlanta, among other locations globally.

The Role

CAA is seeking a developer with excellent software architecture and data engineering 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

• Collaborate with teammates to design and deliver data infrastructure (warehouse, schema, pipelines, data management tools) that supports CAA’s portfolio of applications and analytics.
• Build and maintain services and best practices for data infrastructure.
• Develop new data pipelines and APIs in an agile environment using software development skills.
• Sustain the end-to-end lifecycle: design, deployment, test, operations, monitoring and support through continuous delivery.
• Directly interact with the people who are using your applications.

Languages and Frameworks

You should be proficient in Python with at least a year of experience delivering production Python data projects. Experience in other languages such as Ruby, PHP, or Javascript is welcome, with Javascript being a plus. Experience with the Azure data stack (Azure Data Factory, Azure Data Lake, Tabular Model / DAX, Azure Analysis Services) is beneficial, but strong experience with complementary open-source data technologies such as Hadoop, Amazon Glue, Spark, and Airflow is also highly valued.

Databases

Real SQL and NoSQL production experience is required, with particular interest in expertise with SQL Server, Azure SQL, Azure Synapse, and MongoDB. Experience talking to customers and modeling data would be a plus. Skills in Kafka, Cassandra, or any other cloud-based warehouse are also relevant.

Tools

You should have 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 is highly regarded.

Techniques

Experience with agile methods and the concepts behind continuous delivery is expected. A passion for developing data structures, pipelines, and APIs, coupled with experience in security, testing, performance, JSON, and REST, is essential. We are eager to hear about your experience and opinions around data quality, test strategy, and test automation.

Education

A BS in Computer Science or equivalent experience, which means between one to two years of delivering production data pipelines, is preferred.

Focus

We expect you to have a passion for and experience shipping and maintaining production software products to business users. Strong verbal, written, and visual presentation skills are a must. 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 position will be based in our LA office with a minimum of 1-2 days a week in the office.

Compensation

The annual base salary for this position is in the range of $72,000 - $91,000 in Los Angeles, CA. 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.

Key skills/competency

• Data Pipeline Development
• Software Architecture
• Python Programming
• Azure Data Stack
• SQL/NoSQL Databases
• Agile Methodologies
• Continuous Delivery
• Data Quality
• API Development
• Git/Github