Quick overview
Job description
Description
- Analyze existing reports, universes, data sources, schedules, security requirements, and business processes in SAP Business Objects Enterprise (BOE)
- Develop, enhance, test, document, and maintain Microsoft Power BI reports, dashboards, semantic models, dataflows, and related analytics products
- Support the agency's transition from SAP Business Objects Enterprise reporting to Microsoft Power BI and Microsoft Fabric when appropriate
- Develop and document standards and procedures for Power BI and Fabric development, testing, deployment, naming, ownership, workspace administration, and support
- Support implementation of shared ownership and service-account practices so production analytics assets are not dependent on individual employee accounts
- Gather reporting requirements, analyze data, develop prototypes, coordinate user acceptance testing, and deliver production-ready reporting solutions
- Work with database administrators, data management staff, application teams, and Microsoft platform administrators to implement secure and supportable access to Oracle and other approved agency data sources
- Develop reusable semantic models, documented data definitions, and governed reporting datasets
- Assist with Power BI and Fabric capacity, refresh, gateway, security, performance, deployment, troubleshooting, documentation, and knowledge transfer
Years of Experience
- Seven years of progressively responsible professional experience in senior-level data analysis and enterprise data functions, including data analytics, data warehousing, data modeling, data integration, extract-transform-load (ETL) or extract-load-transform (ELT) processes, data pipelines, data quality, metadata, reporting, and work with relational databases or enterprise data platforms
- At least three years developing or supporting Microsoft data and analytics technologies, such as Power BI, Microsoft Fabric, Power Platform, Azure data services, or comparable Microsoft reporting and integration capabilities
- Experience in requirements analysis, solution design, development, testing, documentation, troubleshooting, production support, and coordination with technical and business stakeholders
- Preferred: graduation from an accredited four-year college or university with major coursework in data science, business analytics, computer science, computer information systems, management information systems, accounting, finance, mathematics, statistics, economics, or a related field
Required Skills
- Advanced knowledge of Microsoft Power BI development, including Power Query, DAX, data modeling, semantic models, and report performance optimization
- Experience with Power BI workspaces, deployment practices, refresh schedules, gateways, access controls, and shared ownership
- Experience integrating Power BI with Oracle or comparable relational databases through approved and governed connection methods
- Ability to analyze and document existing enterprise reports, data sources, reporting processes, security requirements, and support procedures
- Ability to gather requirements, develop prototypes, facilitate user acceptance testing, and implement production reporting solutions
- Ability to establish practical naming, documentation, ownership, testing, deployment, and support standards
- Strong analytical, troubleshooting, written communication, and stakeholder coordination skills
- Ability to produce technical documentation, user guidance, and knowledge transfer materials
Preferred Skills
- Experience with Microsoft Fabric, including Lakehouse, Warehouse, Dataflows Gen2, pipelines, notebooks, or related analytics capabilities
- Experience with SAP Business Objects Enterprise, Crystal Reports, universes, Web Intelligence, or scheduled enterprise reports
- Experience migrating or modernizing reports from SAP Business Objects to Power BI
- Experience with Microsoft Power Automate and Power Platform governance
- Experience with Microsoft Purview, data catalogs, lineage, metadata management, or data governance
- Experience supporting public-sector or regulated enterprise environments
- Microsoft Certified: Power BI Data Analyst Associate or comparable demonstrated experience
Scope / Responsibilities
- Inventory and assessment of assigned BOE, Power BI, Fabric, and related reporting assets
- Prioritized recommendations for report migration, consolidation, remediation, or retirement
- Production-ready Power BI reports, dashboards, semantic models, and dataflows
- Documented requirements, data definitions, lineage, security requirements, test results, and support procedures
- Power BI and Fabric workspace, naming, ownership, deployment, and documentation standards
- Recommendations and implementation support for service-account or shared-ownership practices
- Documented development, test, user acceptance, and production deployment procedures
- Troubleshooting and performance recommendations for refreshes, gateways, data models, and reports
- Knowledge-transfer sessions and reusable guidance for agency staff and business-office report developers
- A transition plan identifying ongoing administration, support, governance, and staffing requirements
Role Description: Senior Data Analyst
- Consults with internal and external customers to identify user needs
- Analyzes data using standard statistical tools, methods, and techniques
- Identifies data gaps, errors, anomalies, inconsistencies, and redundancies by analyzing the content, structure, and relationships within data
- Identifies and interprets data patterns and trends and assesses data quality
- Cleans and prunes data to discard irrelevant information
- Prepares concise, comprehensive technical reports to present and interpret data, identify alternatives, and make and justify recommendations on data revisions
Experience and Education
- Bachelor's degree and at least five (5) years of experience in data analysis, research, compilation, and/or reporting work
- Knowledge of statistics and analyzing data sets
- Knowledge of running queries, report writing, and presenting findings
- Knowledge of data models, database design and development, data mining, and segmentation techniques
- Knowledge of record keeping, including security procedures for handling, protecting, and distributing confidential data
Similar jobs
- AS
Telco Billing Data Analyst (Oracle SQL & Python)Recently posted
AgreeYa Solutions · Atlanta, GA · On-site · Posted 16 Nov 2026 🇺🇸
OraclePL/SQLSQL+5TechnologySalary not listed - E-

Data Analyst with Security ClearanceRecently posted
E-INFOSOL LLC · Washington, DC · Hybrid · Posted 16 Nov 2026 🇺🇸
SQLMicrosoft ExcelMicrosoft PowerPoint+4TechnologySalary not listed - AA
DATA ANALYSTRecently posted
AaraTechnologies Inc · Washington, DC · Hybrid · Posted 17 Nov 2026 🇺🇸
SQLMicrosoft ExcelTableau+2TechnologySalary not listed - MS

Data AnalystRecently posted
Market Street Talent · Portland, ME · Hybrid · Posted 16 Nov 2026 🇺🇸
SQLDatabricksJupyter+3TechnologySalary not listed - EX

Sr. Healthcare Data AnalystRecently posted Auto Apply
EXL · United States · Remote · Posted 17 Nov 2026 🇺🇸
SQLMicrosoft ExcelTableau+6Technology$93.9k - $154.2k/yr - SH

Senior Analyst, Data GovernanceRecently posted Auto Apply
Sherwin-Williams · Cleveland · Hybrid · Posted 17 Nov 2026 🇺🇸
Microsoft ExcelPayrollData AnalysisSalary not listed - WY
Target Digital Network Analyst (TDNA) with Security ClearanceRecently posted
Wyetech · Columbia, MD · Hybrid · Posted 16 Nov 2026 🇺🇸
Technology$10k/yr - PG

Data Analyst – Power BI, SQL, Healthcare | Onsite - 71668Recently posted
PRIMUS Global Services Inc. · Garrison, MD · On-site · Posted 16 Nov 2026 🇺🇸
OracleSQLETL+2TechnologySalary not listed - KT

Data Analyst - ERP & Master DataRecently posted
Kforce Technology Staffing · Fort Myers, FL · Hybrid · Posted 17 Nov 2026 🇺🇸
SQLMicrosoft ExcelData AnalysisTechnologySalary not listed - AG
Senior VMS Data AnalystRecently posted Auto Apply
Allegis Global Solutions · Troy, MI · Hybrid · Posted 17 Nov 2026 🇺🇸
Microsoft ExcelPower BIProject Management+1TechnologySalary not listed - CO
Director of Food Safety Data Analytics, Bureau of Environmental Surveillance and PolicyRecently posted Auto Apply
City of New York · New York City, NY · On-site · Posted 17 Nov 2026 🇺🇸
Microsoft ExcelProject ManagementData AnalysisHuman ResourcesSalary not listed - CO
Relay Operations Analyst, Bureau of Alcohol and Drug UseRecently posted Auto Apply
City of New York · Long Island City, NY · On-site · Posted 17 Nov 2026 🇺🇸
Microsoft ExcelMicrosoft PowerPointMental Health+1Operations & Project ManagementSalary not listed