(AME4631) Data Analyst / CDP Developer

POSITION IS LOCATED IN TORRANCE, CA

Job Description:

Data Analysis and Development:

• Analyze customer data, event data, and large-scale datasets to define data requirements, validate data quality and transformation logic, identify data patterns and anomalies, and support the design of data solutions.

• Design, write, optimize, and maintain advanced SQL queries and data transformations across Presto, Hive, and NoSQL systems.

• Develop and modify Python scripts and solutions for data processing, automation, workflow integration, and API integrations.

• Design and implement data solutions within cloud platforms, primarily AWS, applying cloud data architecture, storage, security, and integration principles.

• Perform exploratory data analysis to validate assumptions, identify anomalies and data dependencies, and translate stakeholder requirements into data and system requirements.

• Document data processes, business rules, transformation logic, system requirements, integrations, and workflow designs in Confluence or similar platforms.

• Collaborate with engineering, analytics, marketing, CRM teams, and SMEs to analyze business and technical requirements, define data and integration requirements, and ensure solution accuracy.

• Design, configure, and enhance CDP workflow orchestration using tools such as Digdag and TD Workflows to implement data pipelines, dependencies, and scheduled processing.

• Design, enhance, and monitor data quality frameworks, including validation logic, automated checks, alerts, and pipeline observability.

• Apply CI/CD and Git-based version control best practices to SQL, Python scripts, workflow configurations, and technical documentation.

• Incorporate applicable privacy and compliance requirements, including GDPR, CCPA, and PII handling, into data processing and solution design.

• Design and implement solutions to end-to-end data challenges, from ingestion and integration through transformation, analysis, and activation.

• Design and refine data models, schemas, identity-resolution logic, and customer profile structures based on business and system requirements.

• Define technical specifications and integration logic for data flows between CDP, CRM, cloud, API, and downstream systems.

• Evaluate alternative approaches for data ingestion, transformation, integration, and workflow design based on scalability, performance, data quality, and implementation requirements.

• Assess technical feasibility, dependencies, data constraints, and implementation considerations for new CDP and data-platform requirements.

• Maintain rigorous attention to detail, especially with customer-level and production data.

• Proactively analyze and improve automation, data quality, workflow architecture, reliability, and system performance.

• Communicate insights and technical concepts clearly to both technical and non-technical audiences.

• Partner with SMEs to understand business context, analyze and refine data and system requirements, evaluate solution approaches, and validate technical solution accuracy.

Troubleshooting & Support:

• Analyze, diagnose, and resolve complex data pipeline failures, ingestion issues, integration defects, and workflow errors.

• Perform technical root-cause analysis of data and system issues using logs, pipeline metadata, data lineage, and system monitoring tools.

• Support production environments by analyzing pipeline behavior, validating data transformations and outputs, and identifying technical changes needed to improve data accuracy, availability, and system reliability.

• Design and implement code, configuration, workflow, and data-processing changes to resolve identified issues and prevent recurring problems.

• Maintain technical documentation of identified issues, root causes, implemented solutions, and preventive design changes to strengthen operational reliability.

What this person will be working on:

As a Data Analyst / CDP Developer, the candidate will analyze, design, develop, integrate, and enhance solutions within the customer data platform (CDP), improve data quality, implement scalable data solutions, and address end-to-end data challenges. This role requires advanced SQL development, Python-based automation and integration, CDP integration, data modeling, pipeline design and operations, and technical troubleshooting across large-scale datasets. The ideal candidate is highly analytical, detail-oriented, exercises independent technical judgment, and thrives in a fast-paced, cross-functional environment.

Required Skills:

• Bachelor's degree in Data Science, Computer Science, Information Systems, Engineering, or a related field.

• 5+ years of combined experience across data analysis, data engineering, data development, or data operations.

• Advanced SQL and Query Optimization (Presto, Hive, NoSQL).

• Expertise in designing and writing complex SQL queries and transformations and optimizing them for large-scale datasets.

• Experience with Customer Data Platforms (CDP) and CRM Systems.

• Hands-on experience designing integrations and configuring CDP and CRM solutions to unify and activate customer data.

• Strong SQL expertise, including complex joins, window functions, CTEs, and performance optimization.

• Proficiency with Python development for data processing, automation, workflows, and API integrations.

• Experience working with customer data, event data, and large-scale datasets.

• Experience designing and implementing data solutions within cloud environments such as AWS, GCP, or Azure, including S3, IAM, and cloud data storage concepts.

• Ability to perform exploratory data analysis, validate data quality and transformation logic, identify technical data issues, and communicate findings to stakeholders.

• Understanding of data modeling, schema design, identity resolution, and profile unification.

• Ability to document data processes, transformations, system requirements, integration logic, and technical solution designs in Confluence or similar platforms.

• Strong communication skills and the ability to work with cross-functional teams.

• Hands-on experience with Treasure Data CDP or similar CDPs (Amperity, mParticle, Tealium, etc.).

• Experience designing, configuring, and maintaining workflow orchestration using Digdag Workflows or similar tools.

• Experience with data quality frameworks, monitoring, alerting, and pipeline observability.

• Experience with CI/CD, Git, and version control best practices.

• Understanding of privacy and compliance requirements, including GDPR, CCPA, and PII handling.

• Experience analyzing and resolving complex technical issues in production data platforms, pipelines, and integrations.

• Strong technical problem-solving skills and the ability to design and deliver end-to-end data solutions, from ingestion and integration through transformation and analysis.

• Excellent attention to detail, especially when working with customer-level and production data.

• Proactive mindset for improving data quality, automation, and system reliability.

• Ability to collaborate closely with Subject Matter Experts (SMEs) to understand domain context, analyze and validate data and system requirements, and ensure technical solutions accurately align with those requirements.

The hiring range for this position is $58.85 to $62.00 per hour, which factors in various geographic regions. The base pay rate actually offered will take into account internal equity and also may vary depending on the candidate's geographic region, job-related knowledge, skills, and experience among other factors.