About the role
Job Description:
On behalf of our public sector client, Affinity Healthcare Solutions is looking for an Integration BI Software Developer to drive the migration of legacy SAP BusinessObjects reports to modern Power BI solutions. Lead the design and implementation of a scalable Power BI framework, including data modeling, DAX optimization, and security protocols. Develop automated reporting workflows using Power Automate, and prototype advanced dashboards to validate architecture. Collaborate cross-functionally to translate business needs into technical solutions, mentor internal teams, and provide strategic guidance on governance, licensing, and platform capabilities.
Responsibilities:
• Report Migration and Development: Lead the hands-on conversion and rewriting of legacy SAP BusinessObjects reports (Crystal Reports and Web Intelligence)
• Technical Leadership & Framework Development:
Design, establish, and document a comprehensive Power BI development framework. This includes defining best practices for data modeling, DAX patterns, security implementation (RLS/OLS), workspace management, and performance optimization.
• Development & Prototyping:
Lead the hands-on development of complex Power BI reports, dashboards, and data models. Drive a Proof-of-Concept (POC) pilot to validate the framework and solution architecture.
• Automation & Integration:
Develop and implement automated report distribution and data refresh workflows using Power Automate and other relevant tools within the Power Platform.
• Mentorship & Knowledge Transfer:
Act as a technical mentor to Fraser Health employees. Provide hands-on guidance, conduct knowledge transfer sessions, and perform peer reviews to build a self-sufficient internal Power BI team.
• Strategic Guidance:
Advise the Project Manager and stakeholders on key technical decisions, including data source connectivity, licensing considerations, governance models, and leveraging the full capabilities of the Power BI platform.
• Collaboration:
Work closely with the Business Analyst/Report Writer to translate functional requirements into robust and efficient technical solutions.
Qualifications:
• Minimum 8+ years of experience in Business Intelligence and Data Analytics, with at least 5 years of intensive, hands-on development within the Microsoft BI ecosystem.
• Expert-level, hands-on development experience with SAP BusinessObjects, including Crystal Reports and Web Intelligence, encompassing complex report design and universe data structures.
• Expert-level proficiency in Power BI, including:
• Power Query (M)
• Advanced DAX
• Data modeling
• Performance tuning
• Administration of Power BI Service (workspaces, gateways, security)
• Mandatory: Strong, demonstrated experience using Power Automate to create automated workflows for report distribution, notifications, and data-related tasks.
• Proven experience in establishing BI frameworks, development standards, and best practices in an enterprise environment.
• Experience in a technical leadership or mentorship role, with a strong ability to transfer knowledge to junior and intermediate developers.
• Experience migrating from a legacy reporting platform (e.g., SAP BOE, Cognos, Tableau) to Power BI is highly desirable.
• Experience working in the healthcare sector is a strong asset.
Certifications and Professional Standing (Preferred):
• SAP Certified Application Associate
• Microsoft Certified: Power BI Data Analyst Associate (PL-300)
• Microsoft Certified: Azure Enterprise Data Analyst Associate (DP-500)
Affinity Earn:
Know someone who’s great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/
About Affinity:
Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.
For more information on Affinity, please visit www.affinity-group.ca
Job Number: 12592
About Affinity
Welcome to Affinity Group — your trusted partner in business and technology consulting. As a carbon-neutral company certified by ClimatePartner and recognized by the Globe and Mail as one of Canada's fastest-growing companies, we are dedicated to delivering an unrivalled experience for our employees, consultants, and clients.
Professional Excellence Across Disciplines:
- Cyber Security Solutions: Protecting your operations with cutting-edge security measures.
- Data Analytics and Business Intelligence: Transforming data into strategic insights.
- Digital Transformation: Pioneering digital innovations to future-proof your business.
- Enterprise Applications: Streamlining business processes through advanced software solutions.
- Project Management: Delivering projects with precision and efficiency.
- Technology Strategy & Architecture: Crafting robust IT frameworks to support scalable growth.
Delivering Tailored Solutions: We provide flexible, bespoke solutions designed to meet the specific demands of your business, driving your success forward with precision and innovation.
Global Reach with Affinity International: Expand your capabilities with our international talent solutions. Discover how we bring global expertise to your local and international projects at affinity-group.ca/international-companies.
Empowering Our Consultants: We are committed to facilitating professional growth and success. Explore a wide array of job opportunities through our referral program, AffinityEARN. Find your next challenge on our jobs page at affinity-group.ca/jobs or LinkedIn.
Ready to Enhance Your Business? Contact us today to discuss how we can support your goals. Email us at Sales@affinity-group.ca for inquiries and solutions tailored to your needs.
Join the innovative and supportive environment at Affinity Group, where we transform challenges into opportunities and individual potential into achievements. Discover more about how we can collaborate on our website below!
About the role
Job Description:
On behalf of our public sector client, Affinity Healthcare Solutions is looking for an Integration BI Software Developer to drive the migration of legacy SAP BusinessObjects reports to modern Power BI solutions. Lead the design and implementation of a scalable Power BI framework, including data modeling, DAX optimization, and security protocols. Develop automated reporting workflows using Power Automate, and prototype advanced dashboards to validate architecture. Collaborate cross-functionally to translate business needs into technical solutions, mentor internal teams, and provide strategic guidance on governance, licensing, and platform capabilities.
Responsibilities:
• Report Migration and Development: Lead the hands-on conversion and rewriting of legacy SAP BusinessObjects reports (Crystal Reports and Web Intelligence)
• Technical Leadership & Framework Development:
Design, establish, and document a comprehensive Power BI development framework. This includes defining best practices for data modeling, DAX patterns, security implementation (RLS/OLS), workspace management, and performance optimization.
• Development & Prototyping:
Lead the hands-on development of complex Power BI reports, dashboards, and data models. Drive a Proof-of-Concept (POC) pilot to validate the framework and solution architecture.
• Automation & Integration:
Develop and implement automated report distribution and data refresh workflows using Power Automate and other relevant tools within the Power Platform.
• Mentorship & Knowledge Transfer:
Act as a technical mentor to Fraser Health employees. Provide hands-on guidance, conduct knowledge transfer sessions, and perform peer reviews to build a self-sufficient internal Power BI team.
• Strategic Guidance:
Advise the Project Manager and stakeholders on key technical decisions, including data source connectivity, licensing considerations, governance models, and leveraging the full capabilities of the Power BI platform.
• Collaboration:
Work closely with the Business Analyst/Report Writer to translate functional requirements into robust and efficient technical solutions.
Qualifications:
• Minimum 8+ years of experience in Business Intelligence and Data Analytics, with at least 5 years of intensive, hands-on development within the Microsoft BI ecosystem.
• Expert-level, hands-on development experience with SAP BusinessObjects, including Crystal Reports and Web Intelligence, encompassing complex report design and universe data structures.
• Expert-level proficiency in Power BI, including:
• Power Query (M)
• Advanced DAX
• Data modeling
• Performance tuning
• Administration of Power BI Service (workspaces, gateways, security)
• Mandatory: Strong, demonstrated experience using Power Automate to create automated workflows for report distribution, notifications, and data-related tasks.
• Proven experience in establishing BI frameworks, development standards, and best practices in an enterprise environment.
• Experience in a technical leadership or mentorship role, with a strong ability to transfer knowledge to junior and intermediate developers.
• Experience migrating from a legacy reporting platform (e.g., SAP BOE, Cognos, Tableau) to Power BI is highly desirable.
• Experience working in the healthcare sector is a strong asset.
Certifications and Professional Standing (Preferred):
• SAP Certified Application Associate
• Microsoft Certified: Power BI Data Analyst Associate (PL-300)
• Microsoft Certified: Azure Enterprise Data Analyst Associate (DP-500)
Affinity Earn:
Know someone who’s great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/
About Affinity:
Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.
For more information on Affinity, please visit www.affinity-group.ca
Job Number: 12592
About Affinity
Welcome to Affinity Group — your trusted partner in business and technology consulting. As a carbon-neutral company certified by ClimatePartner and recognized by the Globe and Mail as one of Canada's fastest-growing companies, we are dedicated to delivering an unrivalled experience for our employees, consultants, and clients.
Professional Excellence Across Disciplines:
- Cyber Security Solutions: Protecting your operations with cutting-edge security measures.
- Data Analytics and Business Intelligence: Transforming data into strategic insights.
- Digital Transformation: Pioneering digital innovations to future-proof your business.
- Enterprise Applications: Streamlining business processes through advanced software solutions.
- Project Management: Delivering projects with precision and efficiency.
- Technology Strategy & Architecture: Crafting robust IT frameworks to support scalable growth.
Delivering Tailored Solutions: We provide flexible, bespoke solutions designed to meet the specific demands of your business, driving your success forward with precision and innovation.
Global Reach with Affinity International: Expand your capabilities with our international talent solutions. Discover how we bring global expertise to your local and international projects at affinity-group.ca/international-companies.
Empowering Our Consultants: We are committed to facilitating professional growth and success. Explore a wide array of job opportunities through our referral program, AffinityEARN. Find your next challenge on our jobs page at affinity-group.ca/jobs or LinkedIn.
Ready to Enhance Your Business? Contact us today to discuss how we can support your goals. Email us at Sales@affinity-group.ca for inquiries and solutions tailored to your needs.
Join the innovative and supportive environment at Affinity Group, where we transform challenges into opportunities and individual potential into achievements. Discover more about how we can collaborate on our website below!