Senior Associate, Analytics at dentsu in Detroit

Summary: Dentsu International Americas is a leading marketing and advertising agency, and they are seeking a Senior Associate in Analytics to support data analysis and deliverable development. This role focuses on ensuring data quality and process improvement while collaborating with internal teams and global partners. Responsibilities: - Design and manage processes for capturing and ingesting data from multiple sources - Maintain and improve ETL/ELT workflows to ensure they run efficiently and reliably - Work with data models and structured schemas to support clear and consistent reporting - Validate and monitor data throughout pipelines, including checks for completeness, accuracy, and structural consistency - Create and maintain alerts, checks, and dashboards to help identify issues early - Help document and support data governance practices related to data intake and processing - Translate technical workflows into clear outputs, dashboards, and resources for end users - Collaborate with analysts, media teams, and business partners to ensure data structures meet their needs - Support and enhance internal tools that surface data quality issues and provide visibility to stakeholders - Assist in managing mapping tables, error logs, data lineage references, and validation checks - Contribute to developing and maintaining data pipelines and related tools within the organization’s technology stack - Use version control to manage changes, maintain transparency, and support team collaboration - Help identify opportunities for automation that improve consistency and reduce manual workload - Maintain thorough documentation to support transparency, continuity, and team alignment - Collaborate with teammates to improve processes, scale data operations, and create a positive experience for data consumers Required Qualifications: - Bachelor's degree in Analytics, Statistics, Mathematics, Computer Science, or a related field - At least 1-2 years required in data enablement, data engineering, analytics engineering, or a related field - At least one year of strong working knowledge of SQL and Python to build, automate, and validate data pipelines, perform analysis, and troubleshoot data quality issues across large datasets - Experience with ETL/ELT tools or workflow oriented systems - Familiarity with Microsoft's data ecosystem (e.g., data storage, reporting, or workflow tools) - Experience using version control for managing code and collaborating on data related changes - Experience integrating external or third party data sources - Understanding of data quality practices, including validation checks, monitoring, and reconciliation - Ability to communicate clearly with both technical and non-technical partners - Demonstrated ability to learn quickly, solve ambiguous problems, and work independently - Strong organizational and time management skills Required Skills: SQL, Python, ETL/ELT tools Important Skills: Data quality practices, Data engineering Nice-to-Have Skills: Version control, Data governance Benefits: Medical, vision, and dental insurance, Life insurance, Short-term and long-term disability insurance, 401k, Flexible paid time off, At least 15 paid holidays per year, Paid sick and safe leave, Paid parental leave