Sr. Consultant, Data Science - Marketing Analytics

  • 515 N State St, Chicago, IL 60654, USA
  • Employees can work remotely
  • Full-time

Company Description

The purpose of this role is to deliver analysis inline with client business objectives, goals, and to maintain, develop and exceed client performance targets.

Job Description

"Remote Opportunity"

The Senior Consultant, Data Science role will have proven expertise in system architecture, database design, data integrations, and be an expert in SQL and Python. Experience with delivering in big data platforms such as Google BigQuery, Microsoft Azure SQL DB/Synapse, or Amazon Redshift is essential. Expertise with traditional RDBMS platforms such as SQL Server or Oracle and NoSQL and Hadoop environments would complement. Data integration experience using ETL platforms such as AirFlow, Talend, Alteryx, or Fivetran is important.

Experience in the digital data and analytic ecosystem and intermediate knowledge in Web Analytic tools (Google Analytics or the Adobe Marketing Cloud), and API expertise is a major plus!!

  • Act as primary consultant to clients for data engineering services, managing the client relationship and coordinating across other support and consultant roles
  • 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
  • Collect client project requirements, focusing on needs & impacts and necessary technical outcomes
  • Create solution designs to solve for clients business and technical needs while keeping within budget
  • Produce documentation of data pipeline design and solution architecture for data warehousing and ETL, following Cardinal Path's documentation standards
  • Create datasets, extracts, or 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, and tools for data management, considering innovation and data security
  • Create ongoing standards and process for overall data architecture team, including developing governance, support and testing models
  • Perform exploratory data validation with analysts to ensure quality data standards are in place and ensure data integrity during all transformation steps.


  • Bachelor’s degree in Statistics, Mathematics, Business Analytics or related field quantitative field, required with a minimum of 3-5 years experience with database development 
  • Experience with cloud / big data technologies such as BigQuery, Azure SQL DB/Synapse, Amazon Redshift is required
  • Experience with relational database systems including SQL Server, Oracle, MySql, Postgres
  • Advanced skills in data scripting and database development technologies (SQL, Python, R)
  • 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
  • Familiarity with web analytics tools such as Adobe Marketing Cloud or Google Analytics
  • 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
  • Familiar with NoSql database technologies such as MongoDB
  • Knowledge of technologies such as Spark, Hadoop, and Airflow

Additional Information

Employees from diverse or underrepresented backgrounds encouraged to apply. 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