Senior Analyst, Business & Insights Reporting

Reporting to the Manager of Planning & Strategy, the Senior Analyst, Business & Insights Reporting is responsible for translating business requirements into technical reporting requirements across end-to-end processes in our e-Commerce Studio. This role is responsible for formulating clear recommendations for developing data pipelines and key performance indicators to power reporting, and crafting compelling data visualization for efficient consumption and powerful insight extraction. The ideal candidate will work cross-functionally, embrace coaching and have a collaborative style, with the ability to influence and motivate to drive performance results.

Responsibilities

Business Reporting & Data Analysis (60%)

• In collaboration with domain experts, translate all Studio strategic and growth initiatives into operational metrics and dashboards to monitor project performance, as well as ensuring methods for reporting are maintained
• Collaborate with the Manager of Planning & Strategy to design a reporting and dashboarding strategy that meets the current needs of business owners, as well as anticipated future data needs
• Develop, and implement reporting solutions with AWS tools like Athena, Tableau, and Looker
• Carry out ad-hoc reporting and data analysis requests, articulate metrics and establish analytical models
• Migrate SAAS, excel sheets and CSV reports to interactive and automated dashboards
• Support in the design, development, and maintenance of various user-friendly dashboards in Tableau and Looker, using multiple reproducible data sources, stored procedures, views, calculations, parameters, and overall performance
• Drive the execution on actionable objectives, translated from reporting requests, including identifying criteria, fields, grouping, summary options, time frames and other components required to build a successful report

Data Governance (40%)

• Participate in continuous improvement initiatives for refining / streamlining data or visualisation standards, as well as change management practices for deployment; inclusive of scalable approach to deprecating and removing legacy reports and dashboards
• Define clear and consistent metric definitions, comprehensive capture and up-to-date documentation of operational and analytical reporting requirements
• Help support Data Engineers in the implementation of data pipelines and participate in the validation processes
• Work closely with business and technical teams to ensure clear governance standards, along with the process to manage and maintain them over time
• Design agile approach for managing ad hoc reporting requests
• Evaluate and improve the data quality and completeness of Studio data available in the enterprise data lake
• Provide support to develop specification documents to guide the data ingestion, validation, transformation and aggregation processes for new data sources
• Develop standard design principles for dashboards, reporting, and workflow visualisations

• Knowledge of process mapping software (Lucidchart, Visio) an asset
• 2+ years of experience with data visualization tools, including, but not limited to, Tableau, Looker, AWS QuickSight, etc
• Excellent English written and verbal communication skills, French an asset
• Extensive experience with data manipulation using SQL or other means to extract and transform data is a must
• 3-5 years experience in analytics, business intelligence, data engineering, or a similar role, specifically working with SQL and relational database
• Bachelors Degree in Computer Science, Information Systems, Mathematics, Statistics, Data Science, Software Engineering, or another relevant field
• Experience with information design principles and data visualization methods, best practices, and software packages and APIs such as Tableau or equivalent analytics tools
• Advanced knowledge of the Microsoft Office Suite, in particular Excel and PowerPoint

Skills

• Ability to identify, prioritize and articulate high impactful initiatives
• Creative out-of-the-box thinking with excellent problem-solving abilities
• Strong collaboration and prioritization skills
• Team player with solid leadership and interpersonal skills
• The ability to translate operational issues into workable data solutions
• Strong organizational and time management skills
• Advanced data analysis skills, and an expert in using supporting tools
• Strong communication skills, with an ability to influence cross-functional teams