What Is the Prescription For A Great Career?
At Rexall, we are community difference makers. Our hearts skip a beat when we meet talent who sees the bigger picture and wants to make an impact in our communities, our teams, and our business. This means finding even better ways to work, share ideas, and making a material difference in the Rexall journey.
We are leaders in health and wellness and a talent destination for over 7000+ Rexall team members. We are proud to be part of the McKesson family, ranked eighth in the fortune 500. Together, we are defining better health through innovation, service, and living the "ICARE" values. Talk about a dream team!
The road ahead is one of adventure and heart. Are you our next all star?
The Mission: BIDW Analyst
The BIDW (Business Intelligence/Data Warehouse) Analyst will facilitate meetings with users and key stakeholders in the organization, capture report and analytic requirements. The incumbent will be responsible for translating the business requests into technical requirements. The individual will be the first line for issue resolution. The individual will assess where report or analytics needs can be met through configuration, setup or non-technical development, and provide a solution. Front end report development within the BI Application will be completed by the BIDW analyst. He/she will support the design and test phases for Business Intelligence & Datawarehouse applications that deliver key metrics to business users. Daily activities include a broad mix of requirements gathering, reporting mockup creation, specification documentation, supporting design and performance testing applications, reports and deliverables before release to business users. In addition, working with the Director BIDW, the incumbent will be responsible for facilitating the Enterprise reporting and analytics steering committee and preparing draft content for executive level review.
Lead business requirements gathering and documentation from various users/departments & stakeholders.
Leads and facilitates discussions with business partners in Merchandising, Pharmacy, Operations and Finance.
Work with BIDW Architect and BIDW Director to prioritize & translate to technical requirements for DWH team.
Manage, track and report back to senior management team on progress related to BIDW requests and initiatives.
Support and execute front end report development and ad hoc queries to support business requirements.
Prepare and lead facilitation of monthly Enterprise reporting steering committee update meetings.
Work with business users to define any reporting or data requirements, data mappings to source systems and format, frequency and structure or reporting or data outputs.
Triage daily issues that come to BIDW team and work with onshore and offshore team to resolve with sense of urgency.
First line root cause analysis and resolution of issues reported from business stakeholders.
Support testing of BIDW deliverables based on business requirements.
Run ad hoc queries and data extracts to support business asks for data and reporting.
Document existing and new MicroStrategy, data warehouse and ETL processes and procedures.
BIDW intake and status tracking including - Weekly documentation of all new BIDW activities and inbound requests, Facilitation of weekly meeting with BIDW team to review status and progress, & business updates on status.
Perform other duties as assigned to support Rexall Pharmacy Group Canada Ltd.
YOU ARE THE IDEAL CANDIDATE IF YOU POSSESS:
4-year bachelor’s degree in computer science or Engineering
5-10 years as a business analyst gathering business requirements and leading translation to technical requirements.
5-10 years data warehouse and business intelligence experience, with experience/exposure in data modelling, SQL, Toad or equivalent, MicroStrategy or equivalent, Informatica or equivalent.
Presentation and executive review documents preparation
Business requirements document preparation
Database Concepts, ETL Basics & Good understanding of development life cycle
Tuning of SQL, Indexing knowledge, External Tables
Loading of data with SQL Loader/Data Pump
Writing reports/data extracts for large amount of data
Good at Analyzing & logical thinking.
Team Player & Self-starter /motivated
Work/coordinate with offshore developers to get the work done as required.
Experience in Inventory/Merchandise Systems Implementation preferred
Good oral and written communication skills
The Rexall DNA:
Ready to make an impact- You are mission-driven and want to make a difference
Builds consensus- Your people-first mindset shows in all that you do
Embraces change- You move fast and change excites you
Drives achievement- You are wired to always exceed your personal best
Overcomes adversity- You see the world as glass half full and embrace a good challenge
Trail blazer- You love creating the path forward and being able to shape the future
Fun- You think laughter is the best medicine and your positive energy is contagious
Side effects may include:
A closely connected culture
Competitive compensation, pension, benefits, personal days, employee discounts, and vacation time
Fully utilizing your talent
Professional growth and development via challenging projects and assignments
Warm and fuzzy feelings knowing you have helped your community, your team, the business and social causes through the Rexall Care Network
Are you #allin?
It's a condition of employment that you be fully vaccinated within 14 days of your start date, and should you receive an offer you will have to attest to this in writing. In addition, you may be required to upload proof of vaccination or have a valid medical or other Human Rights Code-related exemption.
Rexall Pharmacy Group Canada Ltd. is committed to providing an accessible environment for all of our customers, employees, and job applicants. Rexall Pharmacy Group will make available to any selected applicants accommodations and/or accessible formats should he/she require. Candidates are encouraged to discuss any accommodation he/she may need in order to allow for the most effective selection process.