Business Intelligence Specialist – Power BI (5+ yrs), Data Architecture (7+ yrs), Advanced SQL, DAX, Databricks, Azure Data Factory

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

The role involves designing data architecture, including semantic models and CI/CD pipelines, for the ADDS Power BI solution. Additionally, the specialist will develop Power BI reports, implement DAX measures, and optimize performance using Databricks data sources.

Candidates must have over 7 years of experience in data architecture and at least 5 years of Power BI development. Expertise in SQL, DAX, and Azure data tools, along with public sector or healthcare experience, is highly preferred.

• Power BIPreferred
• SQLPreferred
• CI/CDPreferred
• Business analysisPreferred

Identified from the job description. Confirm important requirements above.

• Power BI
• Data Architecture
• SQL
• DAX
• Databricks
• Azure Data Factory
• Dimensional Modeling
• Star Schemas
• Data Governance
• Row-Level Security
• CI/CD
• Power Query
• Data Lake
• Synapse
• Stakeholder Management
• Business Analysis

• Data & Analytics
• Technology
• Government & Public Sector
• Consulting
• Software

Minimum experience

10+ years

Apply by

Sep 23, 2026

Posting language

English

Working hours

37 hours per week

Seniority

Mid-Senior level

Application method

Direct apply is available