Data Architect Engineer

Job Description

CAA is seeking a pragmatic and experienced Data Architect with a strong affinity for data engineering implementations to join our data team. In this position, you will play a critical role in designing and implementing robust data platform architectures, models and solutions that meet our business's strategic requirements. Your expertise in data modeling, data engineering, and data architecture will be instrumental in driving our data initiatives forward.

The Data team designs and builds the foundational data pillars that power our suite of software solutions and products.

Job Description

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.

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.
• You will 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. Candidates with 8 years of experience and a high-level degree will be considered as well.
• 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) but If you have strong hands-on experience with complementary data technologies such as AWS Stack, Google Cloud Platform, Hadoop, Amazon Glue, Spark, Airflow and so on we would love to talk to you.
• Hands-on SQL and NoSQL production experience. We're particularly interested in your expertise with SQL Server, Azure SQL, Azure Synapse, CosmosDB, MongoDB, and Elastic. If you bring specific skills in any other cloud-based warehouse let's talk.
• 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 would be great.
• You should be experienced with agile methods and the concepts behind continuous delivery.
• Excellent problem-solving skills and the ability to think strategically while also paying attention to detail.
• Strong communication and interpersonal skills to collaborate effectively with stakeholders and cross-functional teams.

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

Environment
We have a service-oriented collaborative environment where teamwork and care and helping others to succeed are highly valued. Because of these values, we'd love to have someone onsite in a hybrid model at either our LA or NY office. However, we remain committed to finding the strongest fit for this role and are open to 100% remote for the right candidate. Remote candidates will have occasional travel to company meetings and events.

Creative Artists Agency, LLC (the ''Company'') is committed to a policy of Equal Employment Opportunity and will not discriminate on the basis of race (inclusive of traits historically associated with race, including hair texture and protective hairstyles), color, religion, creed, gender or sex (including pregnancy, childbirth, breastfeeding or related medical conditions), national origin, ancestry, age, physical disability, mental disability, medical condition, genetic information, family and medical care leave status, military or veteran status, marital status, family status, sexual orientation, gender identity, gender expression, political affiliation, an employee's or their dependent's reproductive health decision making (e.g., the decision to use or access a particular drug, device or medical service), or any other characteristic protected by applicable law.

The Company also complies with the Americans with Disabilities Act and applicable state and local laws with regard to providing reasonable accommodation for qualified individuals with disabilities.

Jobcode: Reference SBJ-r75258-3-137-223-8-42 in your application.