Position Type:
Permanent

If you're looking for a fulfilling career that can make a real difference in your life, and the lives of others, you've come to the right place.

As a national health solutions partner, we put people first in everything we do - and that begins with our team of 8,000+ professionals who bring a cross-section of diverse life experiences and career expertise to Medavie. By collaborating and innovating together, our employees are creating industry-leading solutions in insurance, primary care and emergency medical services that impact millions of lives in Canada each year.

Our mission is to improve the wellbeing of Canadians so that every life can be lived to the fullest - and it's reflected in our award-winning culture. We celebrate individuality and value the diverse perspectives and skills our employees contribute. We go beyond providing competitive pay and comprehensive benefits to offer opportunities for personal and professional growth, flexible work options, meaningful experiences, and supportive leadership. Medavie is where employees can be their best selves, feel they belong, and achieve their full potential. Be part of it by applying for a position with us today.

The Opportunity

As a Business Intelligence Analyst, you will gain an understanding of our Group, Individual and Government client benefit business, including how they are structured and managed from a technical perspective. You will interact with other key business areas such as Finance, Business Development, Case Management, Underwriting, Federal/Provincial Programs, other IT teams and customers. This role will be responsible to design, develop and rollout Business Intelligence solutions from a Data Warehouse perspective. This is purely a Business Intelligence / Data Warehouse Application Development team that can assist in your career objectives and work with you to leverage your capabilities and intuition.

• Design solutions for projects which are compliant with BI Enterprise Data Warehouse (EDW) and Enterprise architectural standards
• Design and develop modern Business Intelligence (BI) solutions including Performance Management Dashboards, Business Analytics Models and Visualizations, OLAP and Reporting
• Provide modern information architecture technical designs and specifications for data integration and data storage to support new BI solutions
• Translate business requirements into specifications that will be used to drive Data Modeling/Data Warehouse/Data integration/Analytics and Reporting.
• Use Extract/Transform/Load - OLTP & OLAP processes to load data store(s)/ data warehouse(s)/ data mart(s).
• Design Relational, Dimensional and Tabular Data Structures for organizational data and reporting
• Provide support as required to ensure the availability and performance of enterprise data and BI environments for our customers.
• Ensure proper configuration management and change controls are implemented for your sphere of influence
• Provide technical assistance and cross training to other team members
• Design and implement technology best practices, guidelines and repeatable processes

What's in it for you?

A fast track to understanding how Business and customer needs can be satisfied through data product delivery solutions. A Business Intelligence (BI) Specialist is a BI solution expert who has vast knowledge of BI Industry best practices in a Data Warehouse environment with business acumen. A BI Specialist is responsible for the design, development, implementation, management and support of mission-critical enterprise BI reporting, ETL, Data Modelling and Analytical solutions.

Working with cross-functional teams, you will be required to gather, document, and approve business requirements for data analysis, data integration and reporting projects for business ready solutions.

What makes us a different kind of employer? In this role, it's the opportunity to have exposure to every signal facet in our organization. Common goals and collaboration to deliver outstanding service is what our team is all about, we offer:

• A diverse team of colleagues with multiple fields of expertise
• A stimulating and flexible working environment
• Bonus Program
• Employee and Employer matching Pension Program
• Comprehensive health and dental plan that is 100% employer paid effective on your first day
• Emphasis on work life balance, providing wellness benefits, health resources and fitness center discounts
• An organization where we encourage personal learning and growth
• If getting involved in charitable causes is something you're passionate about, we support and offer plenty of opportunities to give back

Qualifications
Education: University degree or college diploma in Computer Science or similar program
Work Experience: Experience with doing requirements gathering and analysis work. Knowledge of software development life-cycle methodologies; Working knowledge of business domain and/or application

Security Clearance: Security Clearance Requirement: In conjunction with our contract with the Federal Government, you will be required to have Reliability Status Clearance (Enhanced Level B). This includes Fingerprinting, Criminal Record Check, Credit Check and you must have resided in Canada for at least 5 years and hold Permanent Resident or Citizenship Status.

Skill and experience:

• Experience with creating, deploying, and managing SSAS within the SQL Server environment including XMLA.
• Thorough knowledge and experience implementing multidimensional data models, hierarchies, levels, measures, and how to design efficient models for analytical queries.
• Superior understanding of implementing dimensional modeling, optimizing cube design with effective aggregations, partitioning data strategically, writing efficient MDX queries, monitoring performance metrics, utilizing query cache effectively, managing memory usage, and troubleshooting performance bottlenecks within the Analysis Services environment.
• Capability to design dimensional models by defining dimensions, measures, and relationships between them, considering data granularity and performance optimization.
• Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX) experience.
• Proficiency in designing and building both multidimensional and tabular models, optimizing cube performance through partitioning and aggregations, managing security, deploying cubes to production environments, and effectively translating business requirements into analytical solutions, alongside strong data modeling and query optimization skills using MDX and DAX.
• Experience in DevOps tooling and processes
• Support continuous improvement and adoption of best practices including Lean Agile, DevOps, Continuous Delivery Pipeline, and ITIL.
• Experience leading technical design and project leadership.

What you need to succeed:

• You are a good communicator - you are a clear, concise and friendly but know how to communicate to different audiences such as clients, members and internal stakeholders.
• You have earned a post-secondary diploma or degree and/or relevant working experience in business, technology or engineering
• You are a problem-solving master, you are able to understand client requirements and have the ability to transform this into IT solutions.
• You are detailed oriented person, you like the little details with the big picture in mind.
• You have been successful in roles that involve either detailed analysis, quality assurance or systems management
• This role could be a good fit for someone in an HRIS, engineering/process management or IT analyst career path

#CBM2

#LI-VS1

We believe our employees should reflect the communities we serve and welcome applications from candidates of all backgrounds. To provide the best experience possible, we will support you with accommodations or adjustments at any stage of the recruitment process. Simply inform our Recruitment team of your needs. We are committed to making sure recruitment, retention, advancement, and compensation are fair and accessible while following all relevant human rights and privacy laws . We appreciate everyone who has shown interest in this position. Only those selected for an interview will be contacted.

If you experience any technical issues throughout the application process, please email: [email protected] .