Type de poste:
PermanentÀ la recherche d’une carrière épanouissante qui changera réellement votre vie et celle des autres? Vous êtes au bon endroit.
À titre de partenaire national en solutions de santé, nous plaçons les gens au cœur de tout ce que nous faisons – en commençant par notre équipe de plus de 8 000 employés et employées qui mettent à profit leurs expériences personnelles et professionnelles diversifiées dans le cadre de leur travail à Medavie. Par l’entremise de la collaboration et de l’innovation, notre équipe crée des solutions d’assurance, de soins primaires et de services médicaux d’urgence à l’avant-garde de l’industrie qui viennent en aide à des millions de Canadiens et Canadiennes chaque année.
Notre mission est d’améliorer le bien-être de la population canadienne afin que chaque personne puisse profiter pleinement de la vie, et cela se reflète dans notre culture d’entreprise primée. Nous célébrons l’individualité des membres de notre personnel et accordons de la valeur à la diversité de leurs points de vue et de leurs compétences. C’est pourquoi en plus de vous offrir une rémunération concurrentielle et une gamme complète d’avantages sociaux, nous vous donnons accès à des possibilités de croissance professionnelle et personnelle, à des modalités de travail flexibles, à des expériences enrichissantes, ainsi qu’à un leadership bienveillant. À Medavie, chaque personne peut donner le meilleur d’elle-même, se sentir à sa place et atteindre son plein potentiel. Joignez-vous à nous en postulant un poste dès aujourd’hui.
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 BI Data Warehouse Developer is a Data solution expert who has vast knowledge of BI Industry best practices in a Data Warehouse environment with business acumen. A BI Data Warehouse Developer 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
Your every day with us:
As a BI Data Warehouse Developer, 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.
Key responsibilities:
Design and develop solutions which are compliant with BI Enterprise Data Warehouse (EDW) and Enterprise architectural standards
Deliver and advise on database fundamentals, including SQL queries, data modeling, Extract, Transform, Load processes. Working with and advising on data warehouse design principles, such as star and snowflake schemas. 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.
Participate in technical design and business data needs to deliver data solutions.
Support continuous improvement and adoption of best practices including Lean Agile, DevOps, Continuous Delivery Pipeline, and ITIL
Skill and experience:
Exposure to scalable data warehouse solutions using Oracle and Microsoft. Monitor and optimize data warehouse performance, ensuring high availability and scalability.
PL/SQL - Experience in writing advanced SQL, stored procedures, functions, packages, database triggers, shell scripts, SQL Loader and external tables
ETL Processes – experience developing, implementing, and managing ETL processes to ensure accurate and timely data integration from various sources. SSIS & Python.
Familiarity with Analytics Tooling – experience integrating data warehouse solutions with various analytics tools (e.g., SQL Server Analytical Services (Dimensional, Tabular, Cubes, Data Marts, Power BI & SSRS) to support business intelligence solutions.
Qualifications and experience - Minimum of 1-3 years of experience in Oracle and Microsoft data warehousing and data architecture.
performance metrics, utilizing query cache effectively, managing memory usage, and troubleshooting performance bottlenecks within the Analysis Services environment.
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 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 a Data Warehouse or Business Intelligence position, HRIS, engineering/process management or IT analyst career path
Security Clearance Requirement: In conjunction with our contract with the Federal Government, you will be required to have Reliability Status Clearance (Enhanced Level B) prior to your start date. 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.
#CBM1
#LI-VS1
Nous croyons que les membres de notre personnel doivent représenter les collectivités que nous servons et nous encourageons les personnes de tous les horizons à poser leur candidature. Pour vous offrir la meilleure expérience qui soit, nous vous proposons des mesures d’adaptation pour chacune des étapes du processus de recrutement. Il vous suffit d’en faire la demande à l’équipe de recrutement. Nous nous engageons à veiller à ce que le recrutement, la fidélisation et le perfectionnement des employés et employées, de même que leur rémunération, demeurent équitables, tiennent compte des besoins en matière d’accessibilité et respectent l’ensemble des droits de la personne et des lois sur la protection de la vie privée qui s’appliquent. Nous remercions toutes les personnes qui ont manifesté de l’intérêt pour ce poste. Veuillez noter que nous communiquerons seulement avec les personnes retenues pour une entrevue.
Si vous rencontrez des problèmes techniques au cours de votre procédure d'application, veuillez envoyer un courriel à : Medavie.Recruitment@medavie.ca.
Welcome to Medavie!
I would be happy to share and discuss our organization, current and future career opportunies.
Many of our roles are able to be remote (work from home) in Canada
- Kristen Drapeau, Senior Recruitment Consultant
-Krysta Duguay, Recruitment Consultant
Who we are
We’re a team of over 8,000 professionals serving clients from coast-to-coast with operations in most provinces. We provide health benefits to nearly 1 in 10 Canadians and manage emergency medical services for nearly 1 in 15 Canadians.
We’ve been a leading health services partner for individuals, employers and governments across Canada for 80 years and a premier all-in-one carrier that provides health, dental, travel, life and disability benefits to individuals and organizations.
We've been recognized as one of Canada's Most Admired Corporate Cultures, one of Canada's Top 100 Employers, and an Imagine Caring Company.
What we value
Our values are inherent to our culture and provide the framework for each interaction we have and transaction we make, while providing a clear set of expectations to empower employees to do the right thing for everyone we serve. We are:
Caring – We show compassion in everything we do
Accountable – We follow through on our commitments
Responsive – We have the courage to act and adapt
Innovative – We encourage and value new ideas
Community-minded – We achieve more together
More than simply a poster on the wall, our mission of improving the wellbeing of Canadians represents the purpose of our organization ― and we align that with our culture.
What we give back
As a not-for-profit organization, we don’t answer to shareholders. Instead, we invest our earnings in our business, our communities and, most importantly, our employees. We use some of these earnings to support:
Programs to support causes that are close to our employees' hearts, matching the volunteer hours and donations they contribute
An annual United Way workplace campaign led by employees in each of our locations
The Medavie Foundation, which invests in community initiatives and organizations that improve the wellbeing of Canadians, focuses on some of the most pressing mental and physical health challenges facing Canadians.
We want to meet you as you are
At Medavie Blue Cross, we foster a culture of openness, understanding and a sense of belonging where everyone can bring their true selves to work. Nearly 70% of our management roles are held by women and we’re committed to creating a diverse, equitable and inclusive workplace where everyone is valued for who they are and what they contribute. We will accommodate people with disabilities during the recruitment, selection and hiring processes.
What we offer
If you live our values and deliver results, you’ll experience meaningful, rewarding work in a purpose-centred, inclusive organization that provides:
Flexible work options: We want you to work where you work best. We offer work from home, from the office, or a hybrid of the two, while ensuring you feel connected to your team and to our purpose. Our flexibility goes beyond location. We also have flexible working hours and part-time options available.
Competitive compensation: We believe in rewarding our employees for the skills they bring to their jobs and the results they deliver. This includes competitive compensation that will reflect your experience and expertise and annual performance-based incentives, a 100% employer-matched defined contribution pension plan, an employee RRSP, one-on-one financial counselling, vacation and personal days to help you rest, refuel and balance your life.
Career Growth: Internal talent mobility and growth are an integral part of our success. Employees are empowered to own their career development and have rewarding experiences in a variety of work areas. Supportive leadership will encourage and coach you to maximize your potential so you can access multiple learning pathways to develop. Our leadership development program and other programs, such as mentoring, performance-based management and education assistance, are offered to provide employees with an environment of lifelong learning.
Outstanding benefits: Wellbeing is at the centre of everything we do and this starts with our employees. To help you take a proactive approach to your health, we provide: