BI Data Warehouse Developer

Medavie; Dartmouth; On-site; CAD 70,000 - 90,000; Full time

Job summary

A national health solutions partner seeks a BI Data Warehouse Developer to enhance their data solutions. In this role, you'll design and develop critical enterprise reporting and integration solutions while collaborating with cross-functional teams. The position offers a chance to impact millions of lives in Canada while enjoying a benefits package that emphasizes work-life balance and professional development opportunities.

Benefits

Bonus Program

Employee and Employer matching Pension Program

Comprehensive health and dental plan

Wellness benefits and resources

Opportunities for personal and professional growth

Qualifications

• Minimum of 1-3 years of experience in Oracle and Microsoft data warehousing.
• Experience writing advanced SQL stored procedures and managing ETL processes.
• Familiarity with analytics tooling and database optimization.

Responsibilities

• Design and develop Business Intelligence solutions compliant with data warehouse standards.
• Translate business requirements into specifications for data modeling and reporting.
• Support continuous improvement and adoption of best practices.

Skills

Business Intelligence

SQL

Data Modeling

Data Warehouse

Power BI

SSIS

ETL Processes

Education

Post-secondary diploma or degree in business technology or engineering

Job description

If youre looking for a fulfilling career that can make a real difference in your life and the lives of others youve 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 8000 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 its 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.

Whats 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 its 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 youre 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

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 : .

Key Skills

Business Intelligence,Cognos,SQL,Power BI,QlikView,Microsoft SQL Server,ssrs,Tableau,SSIS,T Sql,Data Modeling,Data Warehouse

Employment Type : Full-Time

Experience : years

Vacancy : 1

Create a job alert for this search