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

Experience 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.


• Strong 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.


• Robust 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

Supplier Comments

Closing Date – 2026-08-25, 1:30 p.m.

Maximum Number of Submissions – 1 (one)

Assignment Type: Onsite – 5 days in the office

MUST HAVES:

• 5+ years of Power BI development experience.


• 7+ years of experience in data architecture.