Data Architect Engineer

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.

Responsibilities:

• Partner with a team to design and expand the common data platform that powers our line of business and analytic systems.
• Collaborate with stakeholders to understand business requirements and translate them into scalable data architecture designs and data structures.
• Work closely with data engineering teams to implement and maintain the data structures, data stores, APIs (Application Programming Interface), and data pipelines required for line-of-business systems and analytics platforms.
• Use your skills in an agile environment to develop these new business models within our data environment.
• Your experience with continuous delivery will support the end-to-end lifecycle: design, deployment, test, operations, monitoring, and support.
• Collaborate with cross-functional teams, including product management, business intelligence, and software engineering, to ensure alignment and integration of data solutions within line of business application and analytic products.
• Provide thought leadership, technical guidance, and mentorship to the data engineering team, ensuring best practices and efficient data management processes.
• Continuously evaluate and enhance the performance, scalability, and security of data platforms in our cloud data platform.

Preferred Skills and Qualifications:

• 10+ years’ experience total with a minimum of 5 years' experience working with data architecture and data engineering with a focus on implementation, preferably within the Microsoft Azure Data Stack.
• Strong expertise in designing and implementing data models, data warehouses, and data lakes.
• Proficiency in Python with at least a year of experience delivering production Python data projects to production.
• Experience with JavaScript is a plus.
• Experience with multiple data formats such as JSON, Parquet, Avro.
• Hands-on experience in the Azure data stack (Azure Data Factory, Azure Data Lake, Tabular Model / DAX, Azure Analysis Services).
• Hands-on SQL and NoSQL production experience, particularly with SQL Server, Azure SQL, Azure Synapse, CosmosDB, MongoDB, and Elastic.
• 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.
• Experience with agile methods and the concepts behind continuous delivery.
• Excellent problem-solving skills and strong communication and interpersonal skills.

Education:

We prefer you have a BS in Computer Science, or equivalent experience, which means five plus years modeling business processes and delivering production code.

Focus:

We expect you to have a passion for and experience with shipping and maintaining production software products to business users. You must have strong verbal, written, and visual presentation skills.

Environment:

We have a service-oriented collaborative environment where teamwork and care and helping others to succeed are highly valued. We’d love to have someone onsite in a hybrid model at either our LA or NY office, but we remain committed to finding the strongest fit for this role and are open to 100% remote for the right candidate.

Equal Employment Opportunity:

Creative Artists Agency, LLC (the “Company”) is committed to a policy of Equal Employment Opportunity and will not discriminate on the basis of any characteristic protected by applicable law.