Senior Data Insights Consultant

MAP•Austin, TX

17h•$65,000 - $115,000

About The Position

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: 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. Performing advanced analysis to uncover actionable patterns, trends, and opportunities that directly inform client strategy and decision-making. Designing and running test-and-learn programs (A/B tests, incrementality, holdouts) across channels to measure impact and continuously optimize communication performance. Partnering with senior stakeholders to define strategic business questions and translating them into robust analytical frameworks and data roadmaps. 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. Driving ongoing proactive client ideation — identifying new opportunities, use cases, and data-driven initiatives that help clients grow their business. Helping drive agentic AI adoption, exploring and embedding agentic solutions into our data and insights workflows to enhance efficiency and client value. 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. Mentoring, reviewing, and advising less senior team members — elevating quality, fostering technical excellence, and supporting their professional growth. Collaborating with highly skilled specialists including Account Managers, Architects, Developers, Creatives, Strategists, Data Scientists and Marketing Operations experts to service our clients coherently.

Requirements

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.
Write, debug, and optimize complex SQL queries, ensuring clarity, efficiency, and production readiness.
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.
Develop and manage DBT transformations using layered architecture, including testing and documentation best practices.
Build production-ready Power BI semantic models and dashboards, including advanced DAX measures, performance optimization, and secure data access (RLS).
Work collaboratively using GitHub, following structured branching, pull request, and code review workflows.
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.
Comfortable working in modern cloud data environments (e.g., Snowflake, BigQuery, Databricks, Fabric).
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

Nice To Haves

Consulting experience
Agency experience
Marketing domain knowledge

Responsibilities

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.
Performing advanced analysis to uncover actionable patterns, trends, and opportunities that directly inform client strategy and decision-making.
Designing and running test-and-learn programs (A/B tests, incrementality, holdouts) across channels to measure impact and continuously optimize communication performance.
Partnering with senior stakeholders to define strategic business questions and translating them into robust analytical frameworks and data roadmaps.
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.
Driving ongoing proactive client ideation — identifying new opportunities, use cases, and data-driven initiatives that help clients grow their business.
Helping drive agentic AI adoption, exploring and embedding agentic solutions into our data and insights workflows to enhance efficiency and client value.
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.
Mentoring, reviewing, and advising less senior team members — elevating quality, fostering technical excellence, and supporting their professional growth.
Collaborating with highly skilled specialists including Account Managers, Architects, Developers, Creatives, Strategists, Data Scientists and Marketing Operations experts to service our clients coherently.