BI Developer-Analyst

Salary

The salary range for this position is CAD $38.88/Hr. - CAD $55.89/Hr.

Job Accuracy Posting Flag

The hours of work, including start and stop times, days off, work area and work site may be subject to change consistent with operations requirements and applicable provisions of the Collective Agreement and statutes. Testing may be required. *A criminal record check may be required

Summary

Help build the tools that make healthcare work smarter.

PHC's Data Analytics team is now hiring a temporary full-time BI Developer-Analyst to help transform data into practical solutions that support better decision-making across the organization. Reporting to the Senior Data Scientist and working alongsied Analysts and technical teams, you’ll contribute to a variety of projects ranging from process automation and application development to business intelligence solutions and data analytics initiatives. This is an opportunity to leverage your expertise in SQL, data visualization, automation, and data analytics to help improve the systems and processes that support healthcare delivery across PHC.This is a primarily remote position, with occasional in-person work required. The current scheduled end date for this temporary position is October 1st, 2027. This posting is scheduled to close at 11:59PM on Friday, July 31st.

What you will be doing

• Supporting automation and analytics initiatives:Collaborating on projects involving automation, process improvement, application development, and innovative solutions that enhance business operations.

• Developing data solutions and visualizations: Designing and maintaining dashboards, reports, data models, and analytical solutions that transform complex data into meaningful insights for decision-making.

• Building and optimizing data workflows: Developing and supporting ETL processes, data integrations, queries, and data structures to improve data quality, reliability, and accessibility.

• Partnering with stakeholders to solve data challenges: Working with Data Analytics teams, business users, and technical partners to understand requirements, troubleshoot issues, and deliver solutions that meet organizational needs.

What You Bring

Education

• Bachelor's Degree in Computer Science, Business Analytics, Statistics, Mathematics, Engineering or related field plus a minimum of five (5) years' recent, related experience with data modeling, data visualization and reporting tools (specifically, Tableau, SAP Crystal Reports, SSRS and Power BI), ETL, Microsoft BI tools (SSAS, SSRS, and SSIS), advanced T-SQL (Microsoft Transact SQL) and analyzing business requirements or an equivalent combination of education, training and experience.

Significant recent experience is also required in the following:

• Business analysis and project management;
• Coordinating and documenting the change management process for complex information systems
• Upgrading/migrating to SQL Server Platforms - SQL Server 2019
• Writing T-SQL
• Programming experience in C#, VB.net, Java, etc.

Skills and Abilities

• Advanced knowledge of Microsoft Business Intelligence Stack, SSIS, SSAS, SSRS.
• Expert proficiency in Tableau and other Analytical and Reporting tools. Strong analytical/modeling skills with the ability to convert raw data into actionable business insights.
• Demonstrated knowledge of OLAP technologies and dimensional modeling.
• Strong background in data architecture, data quality, data mapping, and data structures.
• Strong understanding of database and business intelligence concepts.
• Proven ability to interpret data files and record layouts to map fields between multiple systems and database tables.
• Work effectively in an ETL framework driven environment with proven ability to prepare, maintain and publish ETL documentation, including source-to-target mappings and business-driven transformation rules.
• Strong understanding of business processes and transactional systems within the business domain.
• Demonstrated ability to understand and prioritize user and business requirements, and to conceptualize information processing solutions in response to them, including analyze, scope and define work effort required to correct program deficiencies and problems.
• Strong interpersonal relationship management skills, a team player with a client/user orientation.
• Excellent oral and written communica