Data Analyst
Worldgroup Careers
Toronto, ON
MRM//McCann is a leading Customer Experience Agency that puts people first. This philosophy guides our approach to creating moments that matter to both people and brands. Through data infused insights and engaging creative that is enabled through technology, we build seamless, connected experiences that result in profitable relationships. The agency is part of the Interpublic Group (NYSE: IPG) and a lead agency in the McCann Worldgroup network, with 40+ offices across North America, Latin America, Europe, the Middle East and Asia-Pacific. For more information, please visit www.mrm-mccann.com.

About the Role:
The Data Analyst role will be responsible for executing a wide variety of database focused analysis activities in support of a variety of analysts and strategists. In this role, the analyst will also have exposure to a wide variety of data analysis and Business Intelligence tools such as Oracle, SQL Server, Tableau and Teradata and will be expected to apply these tools when opportunities arise.

Responsibilities:
Serve a multitude of functions including but not limited to: business analysis, data extractions, file creation, data analysis, report/dashboard design/creation
Run exception reports and provide results to clients, vendors and peers
Research data discrepancies in source enterprise databases
Gather data requirements for reports/dashboards, proof-of-concepts for larger enterprise-wide BI initiatives
Construct and execute queries based on customer needs
Execute existing jobs, update dashboards and reports based on a set schedule
Develop methodologies for aggregating results from various programs and campaigns
Confirm data integrity

Education and Experience:
Highly accountable self-starter with the ability to work well within a group, as well as independently
Bachelor degree in Computer Science, Mathematics, Information Technology preferred
Must have strong communication skills, both verbal and written.
Must have general knowledge of MS Office (Word, Excel and PowerPoint). Advanced Excel skills a plus.
Web-Savvy with good internet research skills
Confident and energetic with good follow-though
Strong problem solving and analytical skills
Demonstrated ability to learn new technologies and business requirements
Some experience writing SQL queries in Oracle, SQL Server or another database technology
Experience with Tableau or another BI technology considered a plus
Highly accountable

If you are a qualified, passionate Data Analyst, we would love to hear from you. McCann Canada offers amazing opportunities, great compensation packages with excellent benefits and employee perks program. We truly appreciate everyone’s interest but only those selected for an interview will be contacted. We offer a competitive compensation package with enviable benefits and an extensive employee perks program.

McCann Canada embraces the diversity of all people, including those with disabilities, and aims to maintain an inclusive and equitable workplace where employees feel valued, respected, and supported. If you require an accommodation, we would be happy to work with you to meet your needs.

About McCann Worldgroup

McCann Worldgroup, part of the Interpublic Group (NYSE: IPG), is a leading global marketing services company with 24,000 employees in more than 100 countries, comprising McCann (advertising), MRM//McCann (digital marketing/relationship management), Momentum Worldwide (total brand experience), McCann Health (professional/dtc communications), CRAFT (global adaptation and production), UM (media management), Weber Shandwick (public relations), FutureBrand (consulting/design), ChaseDesign (shopper marketing) and PMK-BNC (entertainment/brand/popular culture).

Required Skills

Required Experience