Title

Business Intelligence Specialist

Description

NOTE

Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond the maximum contract value and any extension options included in the original SOW.

Assignment Type : 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

Skills

Experience and Skill Set Requirements

Public Sector Experience

· 3 years public sector/healthcare experience

5 points





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.
- · Solid stakeholder management and leadership skills.
- · Experience mentoring developers and leading BI initiatives.

55 points

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

10 points

Data Architecture Skills

- · 7+ years of experience in data architecture.
- · Expert knowledge of dimensional modeling, star schemas, and enterprise data warehouse design.
- · Strong 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.

30 points Assignment Type: Onsite - 5 days in the office

MUST HAVES:

· 5+ years of Power BI development experience.

· 7+ years of experience in data architecture.

📌 Business Intelligence Specialist – Power BI (5+ yrs), Data Architecture (7+ yrs), Advanced SQL, DAX, Databricks, Azure Data Factory
🏢 CCI- Computer Consultants International
📍 Toronto