About the Role

This position is listed as Onsite; the resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location.

Responsibilities

- Data architecture for ADDS Power BI solution (representing 40% of time)
- - Solution Architecture Document
- Data Flow Diagrams
- Conceptual/Logical/Physical Data Models
- Databricks Lakehouse Design
- Power BI Semantic Model Design
- Role model and security design, including Row-Level Security Design
- Data Governance Framework
- Data Lineage Documentation
- Performance & Capacity Plan
- Environment and Continuous Integration and Continuous Delivery (CI/CD) pipeline design
- Non-Functional Requirements
- Architecture review and Sign-Off Package
- - Hands on Power BI development for reports (representing 60% of time)
- - Design and develop Power BI semantic models
- Connect and integrate Databricks data sources
- Implement DAX measures and KPIs
- Build dashboards and reports
- Configure security and RLS
- Optimize performance
- Support testing and deployment, and provide technical documentation and knowledge transfer

Qualifications

- 5+ years of Power BI development experience
- 7+ years of experience in data architecture

Required Skills

- Public Sector Experience
- - 3 years public sector/healthcare experience
- - Business Intelligence hands-on development skills
- - 7+ years of Business Intelligence and Data Analytics experience




- 5+ years of Power BI development experience
- Expert-level DAX, Power Query, and data modeling skills
- Advanced SQL and data warehouse development experience
- Ability to design enterprise semantic models and reporting architectures
- Strong stakeholder management and leadership skills
- Experience mentoring developers and leading BI initiatives
- - Business Analysis Skills
- - Strong experience of working with business team to identify and gather requirements for Business Intelligence enhancements or defect fix items
- Experience in performing deep-dive data analysis to resolve data issues and answer questions from business
- Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills
- - Data Architecture Skills
- - 7+ years of experience in data architecture
- Expert knowledge of dimensional modeling, star schemas, and enterprise data warehouse design
- Robust experience designing Power BI semantic models and enterprise reporting solutions
- Strong expertise with Databricks, Azure Data Factory, Data Lake, Synapse, and SQL Server
- Proven experience implementing data governance, security, and performance optimization strategies
- Ability to translate business requirements into scalable data architecture solutions

Pay range and compensation package

Not specified in the provided .

Equal Opportunity Statement

We are committed to diversity and inclusivity in our hiring practices.

📌 Business Intelligence Specialist (Toronto)
🏢 ThoughtStorm
📍 Toronto