Business Intelligence Specialist

Position: Business Intelligence Specialist Location: Toronto, ON Job ID#: RQ11427 Duration: 12 Months Role Overview We are seeking a highly skilled Business Intelligence Specialist with strong expertise in data architecture, Power BI development, and enterprise reporting solutions. This role combines strategic data architecture responsibilities with hands-on development of business intelligence solutions to support enterprise analytics and reporting needs. This is an onsite position requiring attendance five days per week. Key Responsibilities Data Architecture (Approximately 40%) Develop Solution Architecture Documents. Create Data Flow Diagrams. Design Conceptual, Logical, and Physical Data Models. Develop Databricks Lakehouse architecture and design. Design Power BI Semantic Models. Create role models and security frameworks, including Row-Level Security (RLS). Develop Data Governance Frameworks. Produce Data Lineage Documentation. Create Performance and Capacity Plans. Design environments and CI/CD pipeline structures. Define Non-Functional Requirements. Prepare Architecture Review and Sign-Off Packages. Power BI Development (Approximately 60%) Design and develop Power BI semantic models. Connect and integrate Databricks data sources. Develop DAX measures and KPI calculations. Build dashboards, reports, and analytics solutions. Configure security models and Row-Level Security (RLS). Optimize report and query performance. Support testing, deployment, and implementation activities. Prepare technical documentation and provide knowledge transfer. Qualifications Business Intelligence & Analytics Skills 7+ years of Business Intelligence and Data Analytics experience. 5+ years of Power BI development experience. Expert-level knowledge of DAX, Power Query, and data modeling. Advanced SQL and data warehouse development experience. Experience designing enterprise semantic models and reporting architectures. Strong stakeholder management and leadership skills. Experience mentoring developers and leading BI initiatives. Data Architecture Skills 7+ years of data architecture experience. Expert knowledge of dimensional modeling, star schemas, and enterprise data warehouse design. Strong experience designing Power BI semantic models and enterprise reporting solutions. Expertise with Databricks, Azure Data Factory, Data Lake, Synapse, and SQL Server. Experience implementing data governance, security, and performance optimization strategies. Ability to translate business requirements into scalable data architecture solutions. Business Analysis Skills Experience working with business stakeholders to identify and gather requirements for BI enhancements and issue resolution. Strong data analysis and troubleshooting capabilities. Excellent analytical, problem-solving, and decision-making skills. Strong verbal and written communication skills. Effective interpersonal and negotiation skills. Public Sector Experience 3 years of public sector and/or healthcare experience preferred. Mandatory Requirements 5+ years of Power BI development experience. 7+ years of data architecture experience. About Symbiotic Digital. Symbiotic Digital provides the IT Experts you need that solve problems and get things done. See what the top 2% in their field can do for you. (Symbiotic Digital is a division of Symbiotic Group Inc.) We serve customers in two ways, we provide: Digital Experts: IT Consulting expertise. Bright Minds That Produce Proven Results Recruitment: Find The Right People You Need Serving IT & Business leaders, Symbiotic Digital provides a business system that enable us to provide the Expert Technical staff needed to solve challenging business and IT problems. IT leaders in the most reputable organizations in Canada have relied on Symbiotic Digital to help them staff difficult assignments with proven Experts uniquely evaluated by our proven QMS- Quality Management System Staff Development Model. We are a 100% Indigenous owned company. Learn more online at https://www.symbioticgroup.com/home-sd/. Please submit your most recent resume to: [email protected] View All Jobs online at: https://www.symbioticgroup.com/view-jobs/

The role involves developing data architecture solutions, including data models and lakehouse designs, while leading the creation of enterprise reporting and analytics. You will be responsible for building Power BI semantic models, optimizing query performance, and ensuring robust data governance and security frameworks.

Candidates must have at least 7 years of experience in data architecture and 5 years of hands-on Power BI development. Proficiency in DAX, SQL, and enterprise data warehouse design is mandatory, along with strong analytical and stakeholder management skills.

• Power BIPreferred
• SQLPreferred
• CI/CDPreferred

Identified from the job description. Confirm important requirements above.

• Power BI
• Data Architecture
• Databricks
• DAX
• SQL
• Data Modeling
• Azure Data Factory
• Data Governance
• Row-Level Security
• Enterprise Reporting
• Data Warehouse Design
• Semantic Models
• CI/CD
• Stakeholder Management
• Performance Optimization
• Data Lineage
• Business Intelligence (BI) Solutions
• Data Lakes
• Healthcare Industry Knowledge
• Reporting Solutions
• Data Analysis Expressions (DAX)
• Knowledge Transfer
• Enterprise Analytics
• Query Performance
• Quality Management Systems
• Data Analysis
• Business Intelligence
• Business Analysis
• Dashboard
• Business Requirements
• Business Systems
• Decision Making
• Communication
• Consulting
• Training And Development
• Data Flow Diagram
• Data Warehousing
• Dimensional Modeling
• Functional Requirement
• Leadership
• Scalability
• Problem Solving
• Key Performance Indicators (KPIs)
• Mentorship
• Negotiation
• Solution Architecture
• SQL (Programming Language)
• Technical Documentation
• Troubleshooting (Problem Solving)
• Synapse Citrix

• Data & Analytics
• Technology
• Software
• Consulting
• Government & Public Sector
• Business Intelligence Specialist
• Business Intelligence Developer / Architect
• Software Developers

Minimum experience

7+ years

Posting language

English

Working hours

40 hours per week