Senior Consultant, Data Science

  • Full-time

Company Description

Merkle Cardinal Path, part of Dentsu Aegis Network, is a leading digital analytics and digital marketing firm focused on delivering insight, understanding, and outcomes that create a competitive advantage for our clients. We engage at the strategic, business, and technical levels to generate tangible and quantifiable value for our partners. Merkle Cardinal Path’s mission is: To know. To Share. To be our Partners’ competitive advantage. And our company culture reflects the importance of our people's expertise, wellness, and happiness in everything we do. 

Merkle Cardinal Path is rapidly expanding its Google Marketing Platform strategy with our clients, including media strategy, activation, platform management, analytics, and managed services to deliver transformational outcomes.

Job Description

We are looking for experienced and passionate data engineers to help solve our client’s most complex business problems utilizing marketing data to deliver modern solutions that scale. 

The Analytics Engineer will build the foundational database architecture, integrations, pipelines, and datasets that will enable our team to perform analysis, create visualizations, and build models. We work with hundreds of brands across every vertical and look for individuals that can thrive working across multiple teams. If working on the leading edge of marketing analytics sounds interesting this is the career for you. An ideal candidate will have very strong technical skills and experience in the marketing domain - preferably web analytics or paid media. The tools of our trade are SQL and Python. We work across clouds and experience in Google Big Query, Microsoft Azure SQL DB / Synapse, Snowflake is essential. Data integration experience with platforms such as Fivetran, dbt, Airflow, and DataBricks is important. Experience in the digital data and analytic ecosystem including Google Analytics or Adobe Analytics is a major plus, as well as experience in working with data from marketing technology platforms such as Google Ads, Campaign Manager, and Facebook. Familiarity with R, and visualization environments such as Tableau, Looker, DOMO, or Power BI is beneficial.

Responsibilities Include:

  • Act as primary consultant to clients for data engineering services coordinating across other support and consultant roles
  • Collect client project requirements and create solution designs to solve for clients business and technical needs
  • Create datasets and views of data that will be consumed by teams of analysts and data scientists to support data mining, analytics, reporting, and dashboards
  • Develop, implement, and support methodologies, standards, documentation and tools for data management, considering innovation and data security at all times
  • Estimate projects involving data integration, data architecture, business analysis or application development and collaborate with sales and client success teams to grow accounts
  • Participate in product roadmap discussions and identifying key areas for improvement of products and services
  • Provide subject matter expertise on industry trends for database-related technologies
  • Ability to build cooperative, productive relationships with clients and vendors, have excellent communication skills, and interact effectively with all levels of management
  • Promote best practices and provide leadership to a team of developers and data engineers
  • Be actively engaged in the pursuit of advancing the company and team, acting as a self-starter and demonstrating proactive initiative

Qualifications

  • Bachelor’s degree in a technical field of study (Information Systems, Computer Science, Engineering, Mathematics, Statistics, Business Analysis, etc) with a minimum of 3-5 years experience with database development 
  • Can accommodate at least a 70% overlap of working time with North American teams and clients, based on central time zone (CT)
  • Advanced skills in SQL and Python
  • Experience with cloud / big data technologies such as BigQuery (preferred), Azure SQL DB/Synapse, Snowflake, or Amazon Redshift
  • Deep knowledge of ETL tools and how they can be applied to a big data environment
  • Familiarity with analyzing digital marketing, advertising and ecommerce data
  • API expertise for Google Analytics, Facebook, Twitter, etc. is a plus
  • Familiarity with web analytics tools such as Adobe Marketing Cloud or Google Analytics
  • Experience with building and maintaining DevOps workflows
  • Experience with optimizing BI or visualization tools such as Tableau, Looker, DOMO or Power BI
  • Experience with cloud platforms such as AWS, Azure, and Google Cloud
  • Knowledge of technologies such as Spark, Hadoop, and Airflow
  • 3+ years experience in marketing technology/data/analytics roles

Additional Information

Merkle Cardinal Path, part of Dentsu Aegis Network, is a leading digital analytics and digital marketing firm focused on delivering insight, understanding, and outcomes that create a competitive advantage for our clients. We engage at the strategic, business, and technical levels to generate tangible and quantifiable value for our partners. Merkle Cardinal Path’s mission is: To know. To Share. To be our Partners’ competitive advantage. And our company culture reflects the importance of our people's expertise, wellness, and happiness in everything we do. 

Merkle Cardinal Path is rapidly expanding its Google Marketing Platform strategy with our clients, including media strategy, activation, platform management, analytics, and managed services to deliver transformational outcomes.

The anticipated salary range for this position is $78,000-$121,500. Salary is based on a wide range of factors that include relevant experience, knowledge, skills, other job-related qualifications, and geography. A range of medical, dental, vision, 401(k) matching, paid time off, and/or other benefits also are available. For more information regarding dentsu benefits, please visit https://dentsubenefitsplus.com/

#LI-PB1

About dentsu international

Part of Dentsu Group, Dentsu International is a network designed for what’s next, helping clients predict and plan for disruptive future opportunities and create new paths to growth in the sustainable economy. Dentsu delivers people-focused solutions and services to drive better business and societal outcomes. This is delivered through five global leadership brands - Carat, Dentsu Creative, dentsu X, iProspect and Merkle, each with deep specialisms.

Dentsu International’s radically collaborative team of diverse creators unifies people, clients and capabilities through horizontal creativity to help clients create culture, change society, and invent the future.

Powered by 100% renewable energy, Dentsu International operates in over 145 markets worldwide with more than 46,000 dedicated specialists, and partners with 95 of the top 100 global advertisers.
www.dentsu.com

We are champions for meaningful progress and we strive to be a force for good—for our people, for our clients, for the industry and for our society. We keep our people at the center, creating space for growth, understanding and learning so they can thrive. We embed diversity, in our mindset, in our solutions and in our teams to empower an inclusive, equitable and culturally fluent environment. Building this culture within our teams makes us better collaborators with each other and with our clients, driving better outcomes for all.

Dentsu (the "Company") is committed to a policy of Equal Employment Opportunity and will not discriminate against an applicant or employee of the Company, on the basis of age, sex, sexual orientation, race, color, creed, religion, ethnicity, national origin, alienage or citizenship, disability, marital status, veteran or military status, genetic information, or any other legally-recognized protected basis under federal, state or local laws, regulations or ordinances. Applicants with disabilities may be entitled to reasonable accommodation under the terms of the Americans with Disabilities Act and/or certain state or local laws. A reasonable accommodation is a change in the way things are normally done that will ensure an equal employment opportunity without imposing an undue hardship on the Company. Please contact [email protected] if you need assistance completing any forms or to otherwise participate in the application process or to request or discuss an accommodation in connection with a job at the Company to which you are applying. 

Privacy Policy