Description

<div><p><b>NOTE</b></p>
<p>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.</p>
<p>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.</p>
<h3>Responsibilities:</h3>
<h3>Data architecture for ADDS Power BI solution (representing 40% of time)</h3>
<ul>
<li>Solution Architecture Document</li>
<li>Data Flow Diagrams</li>
<li>Conceptual/Logical/Physical Data Models</li>
<li>Databricks Lakehouse Design</li>
<li>Power BI Semantic Model Design</li>
<li>Role model and security design, including Row-Level Security Design</li>
<li>Data Governance Framework</li>
<li>Data Lineage Documentation</li>
<li>Performance & Capacity Plan</li>
<li>Environment and Continuous Integration and Continuous Delivery (CI/CD) pipeline design</li>
<li>Non-Functional Requirements</li>
<li>Architecture review and Sign-Off Package</li>
</ul>
<h3>Hands on Power BI development for reports (representing 60% of time)</h3>
<ul>
<li>Design and develop Power BI semantic models,</li>
<li>Connect and integrate Databricks data sources,</li>
<li>Implement DAX measures and KPIs,</li>
<li>Build dashboards and reports,</li>
<li>Configure security and RLS,</li>
<li>Optimize performance,</li>
<li>Support testing and deployment, and provide technical documentation and knowledge transfer</li>
</ul>
<h3>Experience Requirements</h3>
<h3>Public Sector Experience</h3>
<ul>
<li>3 years public sector/healthcare experience</li>
</ul>
<p>5 points</p>
<h3>Business Intelligence hands-on development skills</h3>
<ul>
<li>7+ years of Business Intelligence and Data Analytics experience.</li>
<li>5+ years of Power BI development experience.</li>
<li>Expert-level DAX, Power Query, and data modeling skills.</li>
<li>Advanced SQL and data warehouse development experience.</li>
<li>Ability to design enterprise semantic models and reporting architectures.</li>
<li>Strong stakeholder management and leadership skills.</li>
<li>Experience mentoring developers and leading BI initiatives.</li>
</ul>
<p>55 points</p>
<h3>Business Analysis Skills</h3>
<ul>
<li>Strong experience of working with business team to identify and gather requirements for Business Intelligence enhancements or defect fix items</li>
<li>Experience in performing deep-dive data analysis to resolve data issues and answer questions from business</li>
<li>Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills</li>
</ul>
<p>10 points</p>
<h3>Data Architecture Skills</h3>
<ul>
<li>7+ years of experience in data architecture.</li>
<li>Expert knowledge of dimensional modeling, star schemas, and enterprise data warehouse design.</li>
<li>Strong experience designing Power BI semantic models and enterprise reporting solutions.</li>
<li>Strong expertise with Databricks, Azure Data Factory, Data Lake, Synapse, and SQL Server.</li>
<li>Proven experience implementing data governance, security, and performance optimization strategies.</li>
<li>Ability to translate business requirements into scalable data architecture solutions.</li>
</ul>
<p>30 points</p>
<h3>Supplier Comments</h3>
<p>Closing Date – 2026-08-25, 1:30 p.m.</p>
<p>Maximum Number of Submissions – 1 (one)</p>
<p>Assignment Type: Onsite – 5 days in the office</p>
<h3>MUST HAVES:</h3>
<ul>
<li>5+ years of Power BI development experience.</li>
<li>7+ years of experience in data architecture.</li>
</ul></div>
#J-18808-Ljbffr