Data Analyst

Job summary

The role involves analyzing data to provide business insights, maintaining data pipelines, and supporting media optimization models. You will also collaborate with cross-functional teams to develop dashboards and present complex data solutions to stakeholders.

Job details

Agency: TBWA Job Function: Data and Analytics Job Subfunction: Data Science and Analytics Job Description: Are you an avid data analyst looking for an exciting career in the world of media? Are you obsessed with ROI? Do you like optimizing stuff? Look no further than this data and analytics team working for one of the top automotive companies in Canada. We at TBWA look to uncover key business insights and solve complex problems with the power of data. Responsibilities: Work closely with business stakeholders to understand business requirements; find and analyze appropriate data sources and provide data-driven solutions to key business problems Help build, maintain and improve the data pipelines and data warehouses that power the team’s reporting and analysis Support the development and maintenance of media optimization models – e.g. market mix models and media investment planning – working alongside senior analysts Help maintain and enhance existing machine learning models, and monitor and analyze their performance on an ongoing basis Contribute to audience and ad campaign planning and measurement solutions on a proprietary data platform Work closely with media, strategy and creative teams in an agency setup to provide overall data analytics support for planning and executing media campaigns Develop and maintain strategic business performance Tableau dashboards Analyze competitive landscape and provide regular share of voice and share of market analyses and projections Explain results of complex data solutions and advanced models to a broad business audience through data visualization and executive presentations Ideal Candidate would have:University Degree in Engineering / Computer Science / Mathematics /Statistics / Engineering /Operations Research or a quantitative field Must Haves Curiosity and attention to detail 2–3 years of experience in data analytics or data science, ideally in a media or marketing environment Fluency in SQL and Python & MS Excel Fluency with data, analytics, and visualization technologies (we use SQL, Python, Tableau) Nice to haves Experience in media agency or marketing is a strong plus Knowledge of media mix modeling, multi-touch attribution and other forms of ROI modeling Experience with Google Marketing Products (GA360/4, DV360, SA360, GOOGLE ADS, CM360) At TBWA we respect and value differences and we pride ourselves in attracting diverse talent from around the world. We encourage and foster an environment in which everyone feels respected and comfortable bringing their authentic selves to work. We appreciate people from different backgrounds with different points of view as this fosters creativity and enhances the quality of our work. We are an inclusive employer and recruit, employ, train, compensate and promote regardless of race, religion, colour, national origin, sex, disability or age. We offer reasonable accommodations to job applicants with disabilities. Accommodations or assistance due to a disability are available upon request for candidates taking part in all aspects of the selection process. All resumes will be reviewed and those selected for interviews will be contacted. 75,000-85,000 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/

What you’ll do

The role involves analyzing data to provide business insights, maintaining data pipelines, and supporting media optimization models. You will also collaborate with cross-functional teams to develop dashboards and present complex data solutions to stakeholders.

Requirements

Candidates must have a university degree in a quantitative field and 2–3 years of experience in data analytics or science. Proficiency in SQL, Python, and Tableau is required, with experience in a media or marketing environment considered a strong asset.

Listed skills

• Data visualization · Preferred
• SQL · Preferred
• Tableau · Preferred
• Data analysis · Preferred
• Machine learning · Preferred
• Python · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• SQL
• Python
• Tableau
• MS Excel
• Data Analysis
• Data Science
• Media Optimization
• Market Mix Modeling
• Data Visualization
• Machine Learning
• Business Intelligence
• Reporting
• Data Pipelines
• Data Warehousing
• Audience Planning
• Campaign Measurement
• Creative Teams
• Reporting and Analysis
• Executive Presentations
• Google Display & Video 360
• Business Problems
• Complex Problem Solving
• Campaign Management
• Curiosity
• Google Search Ads 360
• Planning
• Microsoft Excel
• Operations Research
• Analytics
• Dashboard
• Business Requirements
• Computer Science
• Creativity
• Marketing Mix
• Marketing
• Python (Programming Language)
• Market Environment
• Mathematics
• Media Strategy
• SQL (Programming Language)
• Statistics
• Business Strategies
• Tableau (Business Intelligence Software)
• Multi-Touch Marketing
• Teamwork
• Detail Oriented

Job areas

• Data & Analytics
• Marketing
• Creative & Media
• Technology
• Data Analyst
• Statistical, Mathematical and Related Associate Professionals
• Business Intelligence Analysts
• Data Scientists