Data Analyst

MRM McCann; Salt Lake City (UT); On-site; USD 65,000 - 90,000; Full time

Job summary

MRM McCann in Salt Lake City seeks a Data Analyst to support measurement and performance analytics for client programs. You will handle routine reporting, ad-hoc analytics, and build dashboards in Tableau or Power BI, with Google Analytics and BigQuery exposure.

Ideal candidates have a Bachelor's in Statistics, Data Science or Analytics and 0–3 years of experience, with basic Python/SQL skills and strong communication to translate data into actionable insights.

Qualifications

• Bachelor's degree in a relevant field with 0–3 years' experience.
• Basic Python and SQL skills.
• Familiar with Google Analytics/BigQuery and data visualization tools.

Responsibilities

• Handle routine reporting and present findings on a bi-weekly/quarterly basis.
• Answer ad-hoc analytics questions and requests promptly.
• Assist website analytics initiatives via tag management and reporting.
• Create dashboards in Tableau/Power BI to monitor performance.
• Support automation of recurring reports and campaign analysis.

Skills

Analytical thinking

Communication skills

Team collaboration

Problem solving

Education

Bachelor's degree in Statistics/Data Science/Analytics or related field

Tools

Python

SQL

Tableau

Power BI

Google Analytics

BigQuery

Excel

Job description

Agency:

Omnicom Precision Marketing

Job Function:

Data and Analytics

Job Subfunction:

Data Science and Analytics

Job Description:

MRM is part of theOmnicomPrecision Marketing activation practice.This practice integrates CRM platform expertise, journey management, and first-party data capabilities with creative excellence and performance capabilities, enablingOmnicomto 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 visitwww.mrm.com.

MRM is looking for a Data Analyst. The ideal candidate must be able to proactively communicate ideas and opportunities, as well as conduct in depth analysis to support client recommendations and insights. The candidate should have a solid background in measurement and performance analytics, with an openness to learn and expand skills.

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:

(You don't have to be an expert in any of these, but we are looking for someone with a basic understanding and a willingness to learn / grow these skills):

• 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.