Ascension LLC is seeking a skilled, mission-focused Power BI Data Analyst to support Military Programs Business Intelligence products for the U.S. Army Corps of Engineers. This role is central to helping USACE employees understand program conditions, improve visibility into operational data, and make timely, data-informed decisions.

The ideal candidate is an experienced data analytics professional who can translate business needs into actionable dashboards, reports, dataflows, database queries, and user-facing analytics products. The PWS assigns a significant portion of the workload to the Data Analyst, including Power BI dashboards, Power BI reports, Power BI Dataflows, data quality support, database queries, testing, documentation, and help desk support for bugs and change requests. The role requires a hands-on analyst who can work across business users, technical teams, and Government stakeholders to maintain reliable reporting products and improve how data is accessed, visualized, tested, and explained.

Position Summary

The Power BI Data Analyst will support the full lifecycle of MPBI analytics products, including gathering and analyzing reporting requirements, developing and maintaining Power BI dashboards and reports, supporting data extraction and database query development, testing analytic products, resolving user-submitted tickets, and preparing user guides and documentation. The candidate must be comfortable working in a structured Agile environment where work is planned and tracked through story points, sprint priorities, support tickets, user acceptance testing, and documented deliverables.

This position requires a detail-oriented, technically capable analyst who is comfortable troubleshooting data discrepancies, investigating report performance issues, updating data models, supporting dataflow changes, implementing metrics, and providing clear guidance to users. The successful candidate will bring strong Power BI, SQL, reporting, dashboard, data quality, and documentation skills, along with the judgment to escalate issues when requirements are unclear or when dependencies require Government coordination.

The PWS identifies Power BI Dataflows, Power BI Dashboards, Power BI Reports, Microsoft Azure Data Factory, Crystal Reports, and Web Intelligence as supported technologies under the Data Analytics task area. It also requires acknowledgment of user requests within one business day and resolution of validated requests within the assigned sprint or, for simple tickets, within three business days.

Anticipated Day-to-Day Activities

The Power BI Data Analyst will be expected to:

• Develop Power BI dashboards, reports, and visualizations that help USACE stakeholders understand program conditions, trends, performance, and operational needs.
• Retrieve and analyze information from USACE Automated Information Systems and related data sources to support reporting, dashboards, and decision-support products.
• Write and maintain database queries to extract, validate, transform, and prepare data for reporting and visualization.
• Create Power BI Dataflows, data model updates, report modifications, metrics, and data quality improvements in alignment with sprint priorities.
• Convert or support conversion of legacy reports, including Crystal Reports, into Power BI Paginated Reports while maintaining data integrity, functional parity, formatting, parameters, and source logic.
• Collaborate with Government users, business analysts, developers, and project leadership to clarify requirements, document report needs, and confirm acceptance criteria.
• Conduct testing and validation of dashboards, reports, dataflows, data models, and migrated reports before deployment or user acceptance.
• Troubleshoot data discrepancies, performance issues, complex calculations, cross-system integration concerns, and user-reported report defects.
• Respond to help desk tickets, acknowledge user requests within required timeframes, and support bug fixes, change requests, and minor enhancements.
• Prepare user guides, training materials, functional requirements documentation, and clear instructions for MPBI analytics products.
• Support Agile ceremonies, backlog refinement, sprint planning, sprint reviews, and work item updates in the Government-approved Application Lifecycle Management tool, such as Azure DevOps.
• Document analytic logic, report changes, data source updates, testing outcomes, and knowledge transfer materials to reduce dependency on individual team members.
• Maintain professional communication with Government stakeholders while operating within a non-personal services environment.
• Apply data quality practices to identify, explain, and correct inaccurate, incomplete, inconsistent, or outdated reporting data.
• Support capacity planning, progress reporting, and sprint workload visibility by maintaining accurate task status and effort estimates.