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