Data Analyst

Data AnalystMRM 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.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: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. Portland Communications