Data Analyst

AA1 McCann-Erickson USA, Inc.; United States; Hybrid; USD 65,000 - 90,000; Full time

Job summary

Omnicom Precision Marketing (MRM) is seeking a data analytics professional to support routine reporting, ad-hoc analysis, and website analytics initiatives. You will implement tracking, generate dashboards, and assist in campaign performance analysis while collaborating with cross-functional teams.

We value fundamentals in statistics, SQL, Python and data visualization tools with an emphasis on independent work in a fast-paced environment.

Qualifications

• Bachelor’s degree in Statistics, Data Science, Analytics, Mathematics or similar.
• 0-3 years’ professional experience.
• Basic knowledge of Python and data/plotting libraries.
• Basic SQL capabilities: joining tables, group by, case statements.
• Familiar with Google Tag Manager or Google Analytics.
• Basic fundamentals of data visualization using at least one tool (Tableau/Power BI/Looker Studio).
• Basic to intermediate Excel skills: Pivot tables.
• Strong written and verbal communication.
• Comfortable working independently in a fast-paced, cross-functional environment.

Responsibilities

• Handle routine reporting and presenting (bi-weekly and quarterly).
• Manage ad-hoc analytics questions and requests.
• Assist in website analytics initiatives including Google Tag Manager and Google Analytics.
• Run custom analytics reports in BigQuery.
• Create custom analytics dashboards in Tableau or Power BI.
• Assist in report automation and campaign performance analysis.

Skills

Python basics

SQL basics

Statistics knowledge

Communication skills

Independent work

Cross-functional collaboration

Education

Bachelor’s degree in Statistics or Data Science

Tools

Google Tag Manager

Google Analytics

Tableau

Power BI

Looker Studio / Data Studio

Plotly / Seaborn

Job description

Agency: Omnicom Precision Marketing Job Function: Data and Analytics Job Subfunction: Data Science and Analytics

MRM is part of the Omnicom Precision Marketing activation practice. This practice integrates CRM platform expertise, journey management, and first-party data capabilities with creative excellence and performance capabilities, enabling Omnicom to deliver intelligent activation across the full funnel with data-driven decisioning at scale to help clients move faster and deliver more connected customer experiences. MRM is a modern relationship marketing agency dedicated to building enduring brand relationships. MRM's specialized capabilities drive relationship lifetime value and span CRM, Customer Experience, and Commerce with data and martech at the core. MRM operates in a borderless, integrated way to enable greater collaboration, creativity, and true speed to market.

For more information, please visit www.mrm.com.

Responsibilities:

• Handle routine reporting and presenting (primarily bi-weekly and eventually, quarterly reports).
• Manage ad-hoc analytics questions & requests in a timely fashion.
• Assist in website analytics initiatives, including website tag implementation in Google Tag Manager and running custom analytics reports using Google Analytics and Big Query.
• Create custom analytics dashboards in Tableau, PowerBI or similar tools.
• Assist in report automation.
• Assist in campaign planning and performance analysis.

Education and Experience:

• Bachelor’s degree preferably in Statistics, Data Science, Analytics, Mathematics or similar with 0-3 years’ professional experience.
• Basic knowledge of Python & data and plotting libraries, with a keen interest in developing their programming skills.
• Basic SQL capabilities: joining tables, using ‘group by’ clauses, case statements.
• Basic understanding of statistical concepts such as hypothesis testing, confidence intervals, statistical tests (chi-squared, etc) and how to use them.
• Knowledge or experience working within Google Tag Manager or Google Analytics.
• Familiar with the basic fundamentals of data visualization, and at least one data visualization tool or package (Tableau, PowerBI, LookerStudio/Data Studio Plot.ly, Seaborn, ggplot etc).
• Basic to intermediate skills in Excel: Pivot tables, etc.
• Strong communication skills, both written and verbal.
• Comfortable working independently (once properly on-boarded).
• Comfortable working in a fast-paced, cross-functional environment.

Preferred, but not required:

• Interest or background in machine learning / predictive modelling.
• Knowledge or experience working with Firebase.
• Experience working with scientific polling data—bonus if applicant has experience with large .sav files and either SPSS / pyreadstat.
• Experience with automated data collection (web scraping, APIs).
• Experience writing VBA macros a plus.
• Experienced and comfortable collaborating remotely.

Omnicom’s policy requires employees to work in the office for a minimum of three days a week, unless additional in-office days are directed by their agency or manager. Our objective is to increase this requirement over time, and many of our agencies as well as Omnicom’s corporate group already require five days of in-office attendance.

Omnicom is committed to hiring and developing exceptional talent. We agree that talent is uniquely distributed, and we’re focused on developing inclusive teams that can bring the best solutions to everything we do. We strongly believe that celebrating what makes us different makes us better together. Join us—we look forward to getting to know you.

We will process your personal data in accordance with our Recruitment Privacy Notice.

Link to Recruitment Privacy Notice: https://www.omc.com/privacy-notice

For US Job Seekers: It is the policy of Omnicom and any of its affiliates to provide equal employment opportunities to all employees and applicants for employment without regard to race, religion, color, ethnic origin, gender, gender identity, age, marital status, veteran status, sexual orientation, disability, or any other basis prohibited by applicable federal, state, or local law. EOE/AA/M/D/V/F.

At Omnicom Group, careers are designed for growth. We’ve purposefully crafted a transformative talent experience built with accountability in action - focused on community, impact, and opportunity.