Senior Data Insights Consultant

Map · Austin, Texas, United States

// classified as

Other (Adjacent or hard to classify.)

> stack

sqlawsdatabricksdbtdbt

> description

<div class="content-intro"><h4>Who We Are</h4> MAP | WPP Enterprise Solutions designs, builds, and operates the growth systems that competitive businesses rely on. In a world where Al is reshaping how companies drive growth, we lead clients in business transformation and marketing modernization, connecting strategy directly to execution. Our 12,000 experts in engineering and platforms, commerce, consulting, content transformation, CRM, and CX work within a unified global operating unit across 40+ markets. WPP Enterprise Solutions works alongside best-in-class partners including Adobe, AWS, Braze, Google, Microsoft, Salesforce, and Shopify, as well as innovators in AI, to deliver growth solutions tailored to the needs of our clients’ businesses. About WPP MAP is part of <a href="https://urldefense.com/v3/__http:/wpp.com/__;!!IfJP2Nwhk5Z0yJ43lA!L_cfT4E3gsmmDY1lVQTB6ihlfPeBl9X4sMM2KI6iWZYexC2nCeZ9oxgP9qvgbrqxIBpx82rGb_mWqh5F0zKxq5_dP7Y$" data-outlook-id="5677231c-455b-4705-9250-42d6515234fb">WPP</a>, the trusted growth partner for the world's leading brands. Powered by exceptional talent and our agentic marketing platform WPP Open, WPP unites cutting-edge media intelligence and data solutions, creativity, production, enterprise solutions and expert strategic counsel. </div> Do you have strong data and analytical skills, with a passion for shaping business strategy? Can you architect, build, and apply modern data models to deliver impactful marketing insights? Are you seeking an exciting role with significant opportunities for leadership and growth? Then you might be the Senior Data Insights Consultant we are looking for!  <h2>What will your day look like?</h2> As our new Senior Data Insights Consultant, you will join our growing Technology and Data team. Here, you will be a key leader in helping our clients make data-driven decisions to enhance their digital communication on an enterprise scale. This entails designing, enabling, and delivering complex data solutions and integrations for various campaign platforms. More specifically, your tasks will include:  <ul> <li data-leveltext="" data-font="Symbol" data-listid="6" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1">Architecting, building, and delivering value-adding insights solutions, serving as a key advisor to clients on how to leverage their data assets to optimize large-scale communication strategies. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="6" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="2" data-aria-level="1">Performing advanced analysis to uncover actionable patterns, trends, and opportunities that directly inform client strategy and decision-making. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="6" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="3" data-aria-level="1">Designing and running test-and-learn programs (A/B tests, incrementality, holdouts) across channels to measure impact and continuously optimize communication performance. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="6" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="4" data-aria-level="1">Partnering with senior stakeholders to define strategic business questions and translating them into robust analytical frameworks and data roadmaps. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="6" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="5" data-aria-level="1">Supporting or leading the data-stream on complex, large-scale projects with globally recognised brands, ensuring that data solutions and integrations are designed and delivered for scalability and business impact. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="6" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="6" data-aria-level="1">Driving ongoing proactive client ideation — identifying new opportunities, use cases, and data-driven initiatives that help clients grow their business. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="6" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="7" data-aria-level="1">Helping drive agentic AI adoption, exploring and embedding agentic solutions into our data and insights workflows to enhance efficiency and client value. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="6" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="8" data-aria-level="1">Providing answers and insights to business-related questions via automated reporting solutions as well as ad-hoc data analyses, including building reports and insights dashboards within marketing platforms such as Adobe and Salesforce. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="6" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="9" data-aria-level="1">Mentoring, reviewing, and advising less senior team members — elevating quality, fostering technical excellence, and supporting their professional growth. </li> <li data-leveltext="" data-font="Symbol" data-listid="6" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="10" data-aria-level="1">Collaborating with highly skilled specialists including Account Managers, Architects, Developers, Creatives, Strategists, Data Scientists and Marketing Operations experts to service our clients coherently. </li> </ul> <h2>Who are you going to work with?</h2> You will join a team of hands-on Data Insights Consultants, Data Scientists and Data Engineers who are passionate about bringing value and knowledge from data. We are all about unlocking insights from data through analytics and making that insight applicable in 1:1 data-driven communication and CRM. Your work will always be firmly anchored in data in a cross-disciplinary setting, collaborating closely with highly enthusiastic experts from Strategy or Creative backgrounds.  <h2>What do you bring to the table?</h2>   As a person, you possess a strong consultancy mindset, demonstrating resilience, curiosity, and an eager-to-learn attitude. You combine this with strong business acumen, allowing you to understand and anticipate client needs effectively. You are outgoing and love being part of interdisciplinary projects and solutions. You are eager to learn and quick to understand the complexity of high-tech dialogues and solutions.  Furthermore, you have the drive, enthusiasm, and technical credibility to act as the primary data and insights advisor for senior client leadership, guiding them through complex challenges and inspiring them to grow their business. It's an advantage if you have consulting, agency experience or marketing domain knowledge, but it's not a requirement.  In addition, you have:  Technical skills  <ul> <li data-leveltext="" data-font="Symbol" data-listid="7" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1">A minimum of 5 years of experience in a consultant/business liaison role related to data, BI, analytics or reporting solutions. Can independently design, build, and optimize modern analytics solutions that are scalable, maintainable, and ready for real-world production use. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="7" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="2" data-aria-level="1">Write, debug, and optimize complex SQL queries, ensuring clarity, efficiency, and production readiness. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="7" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="3" data-aria-level="1">Design and build scalable dimensional data models from raw source systems (fact/dimension structures, performance-aware design). Apply strong data modelling principles, governance standards and practices that ensure data accuracy, consistency, and security. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="7" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="4" data-aria-level="1">Develop and manage DBT transformations using layered architecture, including testing and documentation best practices. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="7" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="5" data-aria-level="1">Build production-ready Power BI semantic models and dashboards, including advanced DAX measures, performance optimization, and secure data access (RLS). </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="7" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="6" data-aria-level="1">Work collaboratively using GitHub, following structured branching, pull request, and code review workflows. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="7" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="7" data-aria-level="1">Familiarity with or a strong interest in the application of AI and agentic frameworks, and machine learning principles to generate conversational analytics, predictive and advanced marketing insights. </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="7" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="8" data-aria-level="1">Comfortable working in modern cloud data environments (e.g., Snowflake, BigQuery, Databricks, Fabric). </li> <li data-leveltext="" data-font="Symbol" data-listid="7" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="9" data-aria-level="1">Understanding the data structures and reporting capabilities within major marketing and martech platforms (e.g., Adobe Campaign/AJO, Salesforce Marketing Cloud). Ability to build and deliver reports and insights dashboards natively within these tools is a strong advantage </li> </ul> <h2>A leader in personalized customer experiences</h2> WPP Enterprise Solutions MAP is a world-leading Centre of Excellence that helps businesses humanize the relationship between the brand and the customer through hyper personalization at scale, marketing automation and CRM. With the brain of a consultancy, the heart of an agency and the power of technology and data, we work with some of the world's most admired brands to help them on their transformation journey to becoming truly customer-centric. Together, we are 1000 + technology specialists, data scientists, strategic thinkers, consultants, operations experts, and creative minds from 55+ nationalities. <h2>A global network</h2> We are part of the global WPP network that encompasses more than 30,000 employees across 150+ offices in 60+ markets, each contributing to a culture that values connection, belonging, and the power of differences.  #LI-NAMER <div class="content-conclusion">WPP (MAP/VML) is an equal opportunity employer and considers applicants for all positions without discrimination or regard to characteristics. We are committed to fostering a culture of respect in which everyone feels they belong and has the same opportunities to progress in their careers.  When you click “Apply now” below, your information is sent to MAP/VML. To learn more about how we process your personal data during when you apply for a role with us, on how you can update your information or have the information removed please read our <a href="https://wt-map.com/privacy-policy" data-outlook-id="1be1ea03-7c74-4825-b023-8bda1dc2d911">Privacy policy</a>. California residents should read our <a href="https://www.wundermanthompson.com/california-recruitment-privacy-notice" data-outlook-id="02863cf9-cae6-4a11-b7f1-4f68ba8e0816">California Recruitment Privacy Notice</a>.</div>