Assignment: RQ00217 - Report Developer - Senior
Start Date: 2024-12-16
End Date: 2025-03-31
Office Location: 200 Front St W
Client: Supply Ontario
Department: Operations
# Business Days: 72.00
Location: Hybrid 1 day per week
Must Haves:
o 5+ years' experience with advanced expertise in Power BI, including DAX, M query, and Power BI service administration.
o 3+ years' extensive experience with SQL for querying, optimizing, and modeling complex datasets.
o 3+ years' experience as a technical liaison between business users and technical teams, translating requirements into technical specifications with fluency in communication skills.
o 2+ years' experience with implementing data security strategies using Azure Active Directory, Power BI Row-Level Security (RLS), and related tools.
Description Role Overview
This role is responsible for architecting and implementing end-to-end BI solutions, including data modeling, report and dashboard development, and platform optimization. You will focus on building scalable solutions within the Azure ecosystem, working extensively with Power BI, SQL, and data lakes. You will also act as a technical liaison between teams, ensuring alignment of BI solutions with Supply Ontario's strategic goals and data governance standards.
Key Responsibilities Data Architecture and BI Development:

• Architect and implement scalable BI solutions, including data models optimized for analytics and business intelligence.
• Develop and optimize complex Power BI dashboards and reports that provide actionable insights for stakeholders.
• Design, build, and test robust data pipelines and workflows that connect disparate data sources to create a unified reporting infrastructure.
• Prototype and refine data solutions to meet dynamic business requirements, focusing on performance and usability.
• Data Analytics and Reporting:
• Perform in-depth analysis of large datasets to uncover trends, correlations, and actionable insights.
• Implement complex calculations, custom metrics, and KPIs to support decision-making.
• Leverage DAX and M queries to develop advanced functionality in Power BI.

Platform Administration and Optimization:

• Administer and maintain the Power BI platform, including capacity planning, workspace management, and performance tuning.
• Implement data security strategies using Azure Active Directory, Power BI Row-Level Security (RLS), and related tools.
• Optimize Power BI datasets and reports to ensure scalability and reduce latency.

Collaboration and Stakeholder Engagement:

• Act as a technical liaison between business users and technical teams, translating requirements into technical specifications.
• Familiarity with supply chain management principles, including procurement and supplier performance, is an asset. Experience working with supply chain data to identify trends and support decision-making is highly desirable.
• Collaborate with data architects, engineers, and analysts to ensure alignment of BI solutions with organizational data strategy.
• Facilitate workshops and stakeholder meetings to gather requirements and demonstrate BI capabilities.

Process Improvement and Governance:

• Establish and maintain standards for BI development, including naming conventions, documentation, and version control.
• Implement data quality checks and validation processes to ensure the reliability of reports and dashboards.
• Contribute to the development of data governance policies and ensure compliance with organizational standards.

Technical Qualifications Education and Experience:

• Bachelor's degree in Computer Science, Data Engineering, Mathematics, or related technical field. A master's degree is preferred.
• At least 10 years of experience in business intelligence, data engineering, or advanced analytics.

Technical Skills:

• Advanced expertise in Power BI, including DAX, M query, and Power BI service administration.
• Extensive experience with SQL for querying, optimizing, and modeling complex datasets.
• Proven ability to design and build ETL pipelines and manage data integration workflows.
• Experience developing and deploying financial and operational dashboards using enterprise data sources.
• Knowledge of Agile and DevOps methodologies, including CI/CD pipelines for BI projects.

Soft Skills:

• Strong analytical and problem-solving abilities to address complex technical challenges.
• Strong communication skills to articulate technical solutions to both technical and non-technical stakeholders.
• Ability to lead and manage multiple concurrent BI projects effectively.