Associate Director, Data Engineer (Data Management)

Wunderman Thompson (DBA VML)
$75,000-$180,000 USD
paid time off, 401(k)
United States, Michigan, Detroit
243 West Congress Street (Show on map)
Nov 25, 2024
Who We Are: At VML, we are a beacon of innovation and growth in an ever-evolving world. Our heritage is built upon a century of combined expertise, where creativity meets technology, and diverse perspectives ignite inspiration. With the merger of VMLY&R and Wunderman Thompson, we have forged a new path as a growth partner that is part creative agency, part consultancy, and part technology powerhouse. Our global family now encompasses over 30,000 employees across 150+ offices in 64 markets, each contributing to a culture that values connection, belonging, and the power of differences. Our expertise spans the entire customer journey, offering deep insights in communications, commerce, consultancy, CRM, CX, data, production, and technology. We deliver end-to-end solutions that result in revolutionary work. Who we are looking for: VML is seeking an Associate Director, Senior Data Engineer to provide the technical expertise to translate data sources into actionable outputs as part of marketing solutions. This includes user interfaces, data loading, database design, marketing business rule analysis, program generation, and execution. Process flow diagrams and quality control checks will aid in program clarity and successful execution. This role is responsible for the design and development of systems to support client-marketing processes and internal VML systems. The Senior Data Engineer is responsible for analyzing current processes and recommending simplifications and enhancements to improve accuracy, delivery time, and cost. What you'll do: Analyze business processes to refine and automate them. Design and develop systems and relational databases to support client projects and internal systems. Perform / supervise data hygiene procedures. Create and pull a wide range of reports from the local and remote data-access tools. Design and implement quality control procedures. Manage data resources to support client and internal work. Estimate effort required to develop specified systems. Assist in other data and analytics work as necessary. Maintain and support all company standards as specified within the Quality Management System. May include other duties as assigned. Who you are: The Senior Data Engineer is required to be knowledgeable in Microsoft SQL Server, T-SQL, Power BI, Tabular Data Models, C#, SSIS, and Microsoft Azure. What you'll need: Medium to large-scale application development experience required. Relational database design experience including use of entity relationship diagrams. Working knowledge of data-interface protocols. Microsoft SQL Server, SSIS, SSAS, Power BI, C#, Python, Powershell. Previous Work Experience 3-5 years of experience with SQL Server with sound SQL knowledge. 2-3 years of experience with SSIS and SSAS. 2-3 years of experience with C# 1-2 years of experience with Power BI Experience Preferred Snowflake Web Application development What we offer (All NA roles not Canada): Passionate, driven people \| We champion a culture of people that do extraordinary work. Consciously cultivated culture \| We aim to embody the behaviors to build an inclusive community that is in it together, bringing both positivity and active listening into the workplace as we simultaneously strive to empower creative bravery. Competitive benefits \| What we offer full time hires ranges from the full spectrum of group health coverage options (medical, dental, vision) to a generous 401k match (100% dollar-for-dollar match, up to 5% of salary contribution), and a variety of paid time off offerings that reflect our investment in all aspects of your overall life balance and wellness. Growth-minded opportunities \| We aim to nurture a culture of real-time feedback, growth-oriented mindset, and plenty of training opportunities through VML and WPP, so you can continue to grow personally and professionally. VML is an equal opportunity employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability, or other protected group status. We believe in creating a dynamic work environment that values diversity and inclusion and strives to recruit a diverse slate of candidates to help us achieve that goal. The base salary range for this position at the time of this posting is indicated below. Individual compensation varies based on job-related factors, including location, business needs, level of responsibility, experience, and qualifications. We offer a competitive benefits package, click WPP Benefits for more details. _ $75,000 - $180,000 USD At VML, we are committed to fostering an all-inclusive work environment that is both rewarding and career-forward. Our Inclusion, Equity & Belonging initiatives, alongside the VML Foundation, reflect our dedication to giving back and making a positive impact in our communities and beyond. Our people are the heartbeat of our organization-creators, doers, innovators, makers, and thinkers-who drive not just marketing, but meaningful experiences that resonate in every action and interaction. VML is a WPP Agency. For more information, please visit our website, and follow VML on our social channels via Instagram,LinkedIn, andX. When you click "Submit Application", this will send any information you add below to VML. Before you do this, we think it's a good idea to read through our Recruitment Privacy Policy. California residents should read our California Recruitment Privacy Notice. This explains what we do with your personal data when you apply for a role with us, and, how you can update the information you have provided us with or how to remove it.