Power BI Integration Specialist

Please note the base salary will be determined by the successful candidate's education, skills and experience. The listed salary range serves as a general pay guideline for this position's pay level.

Power BI Integration Specialist

Location: Remote - Anywhere in Canada OR Hybrid

Empire life is looking to hire a Power BI Integration Specialist to join our Data Analytics team! As a Power BI Integration Specialist, you will be responsible for designing, developing, and implementing Power BI solutions to meet business requirements. You will work closely with stakeholders to understand their data needs to aid in the design and implementation of moderately complex to complex data models, connecting data from diverse sources. This role involves integrating Power BI with various data sources, optimizing data models, and ensuring data accuracy and consistency.

Why pursue this opportunity

1. Impactful work - get the opportunity to work on meaningful projects that have a positive impact on our customers, our company, and society as a whole.

2. Play an integral role - this is an opportunity that allows for you to grow your skills, while directly contributing to the business unit you are a part of.

3. The opportunity - collaborate with cross-functional teams and work on a variety of projects that will keep you engaged and continuously learning.

4. Diversity, equity, and inclusion - we are committed to creating a diverse, equitable, and inclusive workplace and welcome candidates who share this commitment.

What you’ll be working on

• Design and implement processes to integrate data from various sources into Power BI  

• Develop automated data pipelines to ensure accurate and timely data availability for reporting

• Develop and maintain robust data models for analytics and reporting

• Optimize data models to improve performance of Power BI dashboards

• Provide training and support to business users on using Power BI tools effectively

• Troubleshoot and resolve issues related to Power BI implementations

• Collaborate with stakeholders to gather requirements and understand data insights needed for decision-making

• Work closely with IT and business teams to ensure that the BI solutions align with business goals

• Communicate complex concepts and the results of the analyses in a clear and effective manner

• Conduct rigorous testing and validation of BI tools and data to ensure accuracy

• Implement best practices for BI development and maintain documentation for all processes

• Create interactive dashboards and reports using Power BI to meet the business requirements

• Collaborate with stakeholders to understand their needs and customize visualizations accordingly

What we’re looking for you to have

• Minimum of 3 years of experience in a BI role with a strong focus on Power BI

• Experience leading and delivering business intelligence application solutions from specification through to end-user acceptance testing

• Proven experience working with Power BI, DAX, M, and Power Query

• Proficient in SQL and experience with data integration tools

• Good understanding of database management and data warehousing principles

• Excellent analytical, problem-solving, and organizational skills

• Excellent communication and stakeholder management abilities

• Excellent communication and stakeholder management abilities

• Knowledge of ETL processes and tools

• 2-3 years experience with Life Insurance/Financial Services data 

• Basic experience in database administration is desirable

• Basic experience in business process engineering and modeling is desirable

• Working knowledge of GitHub, Jira and other DevOps tools

• Bachelor’s degree in Computer Science, Information Systems, Business Analytics or a related field

• If you are applying for a position which is open to applicants across Canada, unless otherwise indicated in the position, language proficiency in English is required for communicating with customers, advisors, or employees across Canada.

Beyond the salary

For regular full-time positions, Empire Life offers a comprehensive total rewards package that includes:

• Competitive salaries with annual pay increases

• Annual bonus program, which recognizes both strong company performance and individual contributions, for non sales positions

• Competitive uncapped commission, for sales positions

• A comprehensive employer-funded benefits package starting from day one of employment, that includes life insurance, disability, health and dental and a generous health account

• Flexible work arrangements and an annual allotment of personal health days.

• Four weeks annual vacation from hire date

• A defined contribution pension plan with generous employer matching

• Top up programs for parental leave and compassionate leave

• Employer-sponsored wellness and recognition programs

• A cash employee referral program

To learn more about working at Empire Life, visit https://www.empire.ca/workatempire.

Get to know us

Empire life is proud to be an equal opportunity employer. We celebrate diversity, are committed to creating an inclusive environment, and welcome everyone to participate in our application process. We encourage those of all backgrounds and experiences to apply, even if you don't believe you meet each unique qualification outlined. Applicants will receive equal consideration without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, disability, or age. 

Empire Life welcomes applications from people with disabilities and disabled people. Accommodations are available upon request for candidates taking part in all aspects of the screening and selection process. If you need this job posting in an alternative format or have any accessibility questions, please contact recruitment@empire.ca