We’re in the business of helping organizations help their people, because we believe that engaged people are the driving force behind society. Each day, the expertise of our 2,600 employees is recognized as essential to the financial security, health and productivity of our clients and their people.

We’re always looking for talented professionals and strategic leaders who will embrace the long-term client relationships we value, and will listen and work together with colleagues and our clients to deliver integrative solutions that fit.

As we continue to grow, we’re presently engaging with exceptional candidates interested in the following opportunity. If we sound like a career solutions that fits you, read on.

Business Intelligence Analyst (Bilingual English / French)

Employee Assistance Programs (EAP)

Mississauga, ON

Full-time

Employee Assistance Programs (EAP)

Shepell.fgi’s industry-leading employee assistance program supports employees and eligible family members in assessing their work, life, and health issues, and is delivered in-person, telephonically, through e-counselling, video counseling, First Chat, and our myEAP mobile application.

Our Business Intelligence Analyst’s main objective is to provide statistical reporting to meet contractual reporting requirements for external clients to meet or exceed the commitments for quality and timeliness. Reporting is provided to internal customers including Senior Account Managers, Business Development, Marketing, Finance, and Executive. Strong analytical skills will be used to determine special reporting needs and develop the appropriate templates and reports to satisfy these special requests. The role is also to assist with selecting, blueprinting, gathering requirements, designing, and rolling out BI solutions to end users. Overall, it is the job of the BI Analyst to ensure high levels of business intelligence availability through support functions and in-depth testing.

Additional responsibilities will include:
• Creating standard reports for both internal and external clients
• Creating custom or ad hoc reports for both internal and external clients
• Liaising with internal stakeholders to conduct analysis for determination of content and attributes to fulfill requests for reports
• Resolving data and analytical problems quickly and efficiently
• Writing queries and macros to automate reporting functions
• Proofing and validating report contents for accuracy
• Maintaining and confirming the quality of data in the data repositories
• Working with the various departments to determine how use of Corporate data can be used to establish a competitive advantage
• Understanding customer requirements to facilitate a quality customer experience
• Development and use of meaningful metrics to drive a high performance culture
• Ability to work independently

Succeeding as a Business Intelligence Analyst will require the following core qualifications and skills:

Education:
• Related post-secondary degree, diploma or equivalent experience
• Post secondary education in Business Administration is an asset
• College diploma or university degree in the field of computer science, information systems, or computer engineering

Experience:
• Knowledge of statistical concepts and trending analysis
• Experience with tier-one applications such as MS SQL Server, Crystal and Access is an asset
• Demonstrated ability with MS Windows
• Experience with Crystal Report development
• Advance MS Excel proficiency
• Strong understanding of relational database structures, theories, principles, and practices
• Experience with data processing flowcharting techniques
• Exceptional analytical, conceptual, and problem-solving abilities
• Strong understanding of the organization’s goals and objectives
• Strong written and oral communication skills
• Strong presentation and interpersonal skills
• Strong analytic skills
• Able to prioritize and execute tasks in a high-pressure environment
• Experience working in a team-oriented, collaborative environment

Knowledge/Skills:

• Fluency in English and French required

• Excellence in problem solving to resolve data errors and determine the best approach to meet expected client outcomes
• Demonstrated strength in communication
• Strong sense of personal and business integrity; commitment to ethical business behaviour
• Demonstrated ability to make decisions based on requirements analysis
• Superior negotiation and conflict resolution skills
• Demonstrated proficiency at stakeholder assessment, engagement and developing support in implementation
• Demonstrated ability to take on a challenge and work effectively under high levels of change
• Ability to design and implement multiple endeavours simultaneously
• Ability to implement quality improvement processes/procedures required to achieve customer and business goals/objectives, including operational efficiency, revenue growth and customer loyalty programs

At www.morneaushepell.com you can explore our careers page to learn more about the solutions we deliver and the great people who help us do it. Follow us on LinkedIn and Twitter (Morneau_Shepell, Shepellfgi).

We are thankful for your interest, but unfortunately, we can only personally connect with those selected for an interview.