Senior Data Analyst
Job Summary
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 agencys 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.
- Location: Hybrid. 3 days on site
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. The experience must include 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 should include requirements analysis solution design development testing documentation troubleshooting production support and coordination with technical and business stakeholders. v 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 is preferred.
- 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. v 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.
- 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.
- 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 IRD staff and business-office report developers.
- A transition plan identifying ongoing administration support governance and staffing requirements.
Resource Category | Role Description | Experience and Education |
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. | Bachelors Degree and at least five (5) years of experience in data analysis research compilation and/or reporting work. |
Required Skills:
Senior Data Analyst Power BI / Microsoft Fabric Position Overview We are seeking an experienced Senior Data Analyst with strong expertise in Microsoft Power BI enterprise reporting data analytics and data integration. The ideal candidate will support reporting modernization develop scalable BI solutions improve data quality and establish enterprise reporting standards. Experience & Education 7 years of experience in data analytics business intelligence data warehousing data modeling ETL/ELT and enterprise reporting. 3 years of hands-on experience with Microsoft technologies including Power BI Microsoft Fabric Power Platform or Azure data services. Bachelors degree in Data Science Computer Science Business Analytics Information Systems Mathematics or a related field preferred. Required Skills Advanced Power BI development including DAX Power Query semantic models and performance optimization. Experience with Power BI workspaces gateways scheduled refreshes security and deployment. Experience integrating Power BI with Oracle or other relational databases. Strong requirements gathering report development testing and production support experience. Ability to document reporting processes data sources security requirements and technical procedures. Strong analytical troubleshooting and communication skills. Preferred Skills Microsoft Fabric: Lakehouse Warehouse Dataflows Gen2 pipelines and notebooks. SAP BusinessObjects Crystal Reports Universes and Web Intelligence. Experience migrating SAP BusinessObjects reports to Power BI. Microsoft Power Automate and Power Platform governance. Microsoft Purview data lineage metadata and data governance. Public-sector or regulated enterprise experience. Microsoft Power BI Data Analyst certification preferred. Key Responsibilities Assess existing SAP BOE Power BI Fabric and enterprise reporting environments. Identify opportunities for report migration consolidation improvement or retirement. Develop and maintain Power BI dashboards reports semantic models and dataflows. Establish reporting standards for workspace management naming ownership security and deployment. Gather business requirements and coordinate testing and user acceptance. Troubleshoot reporting data refresh gateway and performance issues. Maintain technical documentation and reporting procedures. Conduct knowledge-transfer sessions and support internal teams. Develop transition plans for ongoing administration governance and support. Resource Classification: Senior Data Analyst Bachelors degree with at least 5 years of experience in data analysis research reporting or related functions. The resource should have knowledge of: Statistical analysis and data interpretation. SQL queries database design and report development. Data modeling data mining and segmentation. Data cleansing validation and quality assessment. Technical documentation and stakeholder reporting. Confidential data handling and information security practices.