Power BI Developer / Data Analyst

Power BI Developer / Data Analyst

Washington DC 20416

A. Roles and Responsibilities

• Perform deep analysis of budget, acquisition, finance, and investment-portfolio data and deliver Power BI solutions that surface key drivers of performance.
• Mine, import, cleanse, and transform data from multiple sources; collect, audit, compile, and validate data for accuracy and completeness.
• Build and maintain semantic models, relationships, DAX measures, and, where required, machine-learning models or AI visuals.
• Create custom charts, calculations, filters, and interactive dashboards; produce ongoing and ad hoc reports using statistical or relational techniques.
• Document data models, relationships, algorithms, and lineage; maintain a data dictionary.
• Develop and implement enterprise BI and data-integration frameworks, workspace standards, and a Power BI roadmap for business process improvement.
• Support the OCIO training manager with Power BI training content; collaborate with process-improvement SMEs to visualize workflows; produce website trend-analysis reports.
• Ensure Power BI reports conform to Section 508 (alt text, tab order, contrast, accessible themes).

B. Experience and Qualifications

• 5+ years of BI/analytics experience; 3+ years developing Power BI solutions in an enterprise environment.
• Demonstrated experience analyzing financial, budget, or acquisition data and presenting findings to non-technical leadership.
• Experience establishing BI standards or governance (workspace structure, naming, certification of datasets) and delivering user training.
• Bachelor's degree in Data Analytics, Statistics, Computer Science, Finance, or related field (or equivalent experience).
• Certification: Microsoft Certified Power BI Data Analyst Associate (PL-300) or Fabric Analytics Engineer Associate (DP-600). Preferred: Azure Data Fundamentals (DP-900); Trusted Tester or 508 report-accessibility training.
• Eligible for a federal Public Trust background investigation and PIV credential.

C. Skill Sets

Technical Skills

• Power BI Desktop and Service: workspaces, apps, gateways, deployment pipelines, row-level security
• DAX (measures, time intelligence, calculation groups)
• Power Query (M), dataflows, incremental refresh
• Dimensional modeling (star schema), SQL (T-SQL), SharePoint/Excel/Dataverse connectors
• Statistical analysis; Python or R for advanced analytics; Azure ML or Power BI AI visuals
• Data documentation tools, data dictionaries, lineage views
• Accessible report design (WCAG/508 for Power BI)

Functional Skills

• Financial and acquisition data analysis and KPI design
• Data quality auditing and validation
• BI governance, standards, and roadmap development
• Training content development and delivery
• Process and workflow visualization

Professional Skills

• Translating business questions into analytical designs
• Storytelling with data for executive audiences
• Collaboration with finance, acquisition, and program SMEs
• Attention to detail and data stewardship