Sql jobs in Canada

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.

As Business Intelligence Analyst you will report to a Team Leader within our BI COE and Reporting Services team. Leveraging your strong Microsoft BI Tools experience, you will play a key role in the delivery of business intelligence solutions through collaboration with business and IT. You will support our Business Intelligence Center of Excellence through working closely with your business and IT peers.

• Successfully deliver report, data and dashboard solutions to Medavie's internal and external partners through understanding our business initiatives and the proficient use of our Business Intelligence tooling.
• Ensure that Business Intelligence governance standards and best practices are followed in all deliverables within your responsibility, be a champion of these standards, and support our Business Intelligence strategies including business self‑serve through each key delivery.
• Establish and maintain strong, productive working relationships and a proactive approach to meeting our Business Intelligence reporting, data and dashboard needs.

Education: Bachelor's degree in Computer Science, Business or related field or College Diploma in related filed of study and/or equivalent experience

Work Experience: Minimum 3 to 5 years of experience successfully working in Business Intelligence Tools. Professional confident communicator with Data Warehouse and Microsoft BI tooling experience.

• Experienced in Advanced SQL development, with proficiency in Power BI, SSRS, DAX, and tabular models, including the creation of reports, data sets, and dashboards. Demonstrated experienced in Advanced SQL, SSRS, DAX, Power BI, and tabular models, including the creation of reports, data sets, and dashboards.
• Possess strong thinking and technical skills with ability to adapt and work in a fast‑paced environment.
• Proficient in developing, publishing, and scheduling using Microsoft BI tools.
• Knowledge and experience in prototyping, designing, and requirement analysis.
• Excellent analytical thinking for translating data into informative visuals and reports.

English required, Bilingualism is considered an asset.

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.

• A background in health and life insurance industry with the functional and technical knowledge and skills to do the job at a high level of achievement.
• Analytical Thinking: High attention to detail, using logic and good judgment in decision making for when different situations and skills may call for different approaches
• Possess strong communication skills (oral, written, listening) and deliver information clearly and confidently. Demonstrates the ability to tailor information and delivery to suit the nature of the material, audience and situation
• Builds rapport, constructive and effective relationships. Can understand where our clients are coming from and place the appropriate level of urgency as required.
• Prioritizes and effectively copes with change. Ability to organize work and information in a well thought out manner to deliver on specific tasks and reporting deadlines. Exhibits high levels of energy and perseverance in the pursuit of established goals.
• Demonstrates an understanding of how the job contributes to the overall work unit and takes the initiative to help with problem situations. Easily gains trust and support of peers, encourages collaboration and is composed. Seeks and is receptive to feedback and enjoys working with people both as part of a team and one‑on‑one.

What makes us a different kind of employer? In this role, it's the opportunity to have exposure to every 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
• 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

#LI-VS1

#CBM2

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: Medavie.Recruitment@medavie.ca.