Senior Associate, Data Enablement at dentsu · Detroit…

Summary: Dentsu International Americas is a leading global marketing and advertising agency, and they are seeking a Senior Associate in Data Enablement to ensure accuracy and reliability across the full data lifecycle. This role involves data analysis, process improvement, and support for business analytics needs, with responsibilities including maintaining data quality and collaborating with various teams. 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 governance Nice-to-Have Skills: Version control, Data modeling 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