Business Intelligence Developer

It's fun to work in a company where passion meets profession, and every team member is not just an employee but a dedicated enthusiast, making the work journey truly enjoyable and fulfilling!

About You :

The Business Intelligence Developer is crucial in developing and maintaining the company's BI applications. This role includes mining data for insights, reporting on business performance, and resolving code and data issues.

The individual will play a pivotal role in understanding client needs and supporting business goals through data analytics.

Key aspects of this position include collaboration, innovation, and expertise sharing within the team, focusing on creative problem-solving and effective communication.

In this role, you’ll get to experience :

Data Quality Administration & BI (70%)

• Aggregate, merge, link, and reshape data for analysis.
• Conduct data integrity audits.
• Assist in establishing and managing data structures and management systems.
• Design, analyze, and maintain the Data Warehouse (DWH).
• Develop BI reporting tools, visualizations, and applications.
• Automate recurring data management tasks and reporting for efficiency.
• Identify process improvement opportunities.
• Design, code, and test SQL queries for internal team information.
• Work with various company data repositories (e.g., Sybase, V9, Aviator, Magenta).
• Implement cross-team quality control and training.

Analytics & Reporting (30%)

• Conduct both basic and advanced data analysis to identify trends and patterns.
• Facilitate analytic work from specification to presentation for solving business problems.
• Derive business insights from analysis and collaborate on business recommendations.
• Prepare and present findings to various stakeholders.
• Create, maintain, and deliver accurate, informative automated reports.
• Continuously enhance analytical skills and contribute to the data expert community.

Performance Measures

• Achieve departmental KPIs.
• Analyze system and operational issues.
• Follow prescribed software development and maintenance procedures.
• Generate reports (e.g., census, premiums, claims) from internal platforms.
• Ensure the data quality through database content and relationship analysis.

What you bring :

• College / University degree in a relevant field (e.g., computer science, statistics, mathematics) or equivalent experience.
• 5+ years of experience in data analysis and report creation.
• Experience in the insurance or financial services industry is an asset.
• Experience with structured and unstructured data is an asset.

What do you need to succeed?

• Proficiency in English; and French is beneficial.
• Willingness for on-call rotation.
• Expertise in SQL, T-SQL, and ETL processes.
• Familiarity with Power BI, SQL Server, Excel, Integration Services, and Reporting Services.
• Skilled in relational and multidimensional modeling.
• Ability to translate business requirements into technical solutions.
• Open to change and innovation.
• Independent and team-oriented work capability.
• Detail-oriented with strong problem-solving and documentation skills.
• Ability to multitask and prioritize under tight deadlines.
• Desirable : Data mining, understanding of data life cycles, predictive / prescriptive analytics techniques, Python proficiency.

What’s in it for you :

• Hybrid work environment
• Excellent health benefits
• Employee assistance program
• Wellness account
• RRSP matching
• Minimum 3 weeks’ vacation
• Generous amount of sick and flex days
• Tuition reimbursement program
• Opportunities to learn new skills, grow, and move into different roles
• A work environment that embraces diversity and promotes inclusivity.
• Supportive leadership prioritizes your success and cares about your well-being.
• A growth trajectory designed to expand vertically and horizontally, providing opportunities to pursue your passions and acquire new skills.

Additional Notes

• The hours for this position are 9 am-5 pm Monday to Friday.
• A laptop will be provided

MSH is an Equal Opportunity Employer

MSH Americas is an equal opportunity employer and does not discriminate against any employee or applicant for employment based on race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity, or any other protected status under applicable law.

We encourage and welcome applicants from all backgrounds to apply for our open positions. Removing obstacles to offer fair access to jobs is our top priority.

When a candidate asks for reasonable accommodation throughout the application process, a Human Resources professional will assist them.

The information provided during the accommodation request process will be handled, saved, and utilized by the laws that apply to it and the rules of MSH International.