Financial Management Data Analyst - Washington, DC

Military Spouse Corporate Career Network•Washington, DC

16h•Onsite

About The Position

PotomacWave Consulting is seeking a Financial Management Data Analyst to support a Federal client in Washington, DC. This role involves developing, managing, and maintaining SharePoint pages to track and enhance the client’s modernization efforts. The analyst will collaborate with and lead work assignments for team members to ensure client satisfaction and project success. The position requires familiarity with procurement processes and will involve developing, running, and analyzing various reports, assisting with SharePoint development on CG Common Core, establishing working agreements, and maintaining configuration control boards. A key aspect of the role is developing and managing performance metrics using data from multiple financial systems and creating briefing materials for clients. The analyst will also translate requirements into development tasks, design, develop, test, and deploy Microsoft Power Apps and Power Automate workflows, and manage Power Platform solutions. Experience with connecting these solutions to various data sources like SharePoint Lists, Dataverse, and SQL Server is essential, as is designing SharePoint list structures and implementing role-based access and workflows. The role includes creating Power BI reports and dashboards, performing ETL and data modeling, and troubleshooting issues across the Power Platform and related systems. Creating technical and process documentation is also a responsibility. Other duties as assigned.

Requirements

Bachelor's degree in Information Technology, Business, or a related field.
Three to seven (3-7) years of related experience.
Excellent communication and customer service skills.
Experienced management skills with the ability to lead, facilitate, motivate and organize.
Familiar with the Financial Resource Management Manual (FRMM) and the Federal Acquisition Regulations (FAR).
Skilled in SharePoint development processes, software, and tools for SharePoint Online.
Must be a US Citizen able to obtain a security clearance.

Nice To Haves

Experience with Power Automate highly desired.
Experience with SharePoint migration is a plus.
Familiar with various Business Intelligence tools including: CG Business Intelligence (CGBI) Power BI Tableau Oracle Business Intelligence

Responsibilities

Developing, running, and analyzing financial, procurement, training, and logistics reports, metrics, and system interfaces.
Assisting with development of SharePoint on CG Common Core to meet financial modernization/sustainment objectives.
Establish and maintain working agreements and governance (MOU/MOA/SLA) with CG Common Core customers to facilitate integration of financial synergies and efficiencies.
Assist with maintenance of CG Common Core configuration control board.
Developing, managing, maintaining, and updating SharePoint pages, process tools, workflows, training, and performance metrics on the CG Common Core consistent with standardized processes, best practices, and target audiences.
Assisting with migration of content to SharePoint Online.
Developing, managing, maintaining, and posting performance metrics using financial management and procurement services (FMPS) data captured from CG Common Core, Financial Procurement Desktop (FPD)/Core Accounting System (CAS), Financial System Modernization Solution (FSMS – Oracle R12), and the Coast Guard Data Warehouse (CGDW - SAS Viya).
Develop and maintain CG Common Core briefing material including an updated coversheet/summary of transactions and impacts.
Meet directly with USCG clients and stakeholders to gather, clarify, and document business and technical requirements.
Translating captured requirements into development tasks, application features / enhancements, and establish acceptance criteria.
Design, develop, test, deploy, and maintain Microsoft Power Apps.
Develop Power Fx logic for business rules, data validation, calculations, filtering, search, navigation, permissions, variables, collections, and record updates.
Develop Power Automate workflows that support Power Apps, including notifications, reminders, approvals, file processing, Excel imports, SharePoint record creation, and scheduled processes.
Organize and manage Power Platform solutions containing Power Apps, Power Automate flows, connections, connection references, data sources, environment variables, and other related solution components.
Support the movement and configuration of Power Platform solutions across development, test, and production environments.
Connect Power Apps and Power Automate solutions to SharePoint Lists, Microsoft Dataverse, and Microsoft SQL Server.
Design SharePoint list structures, columns, relationships, choice fields, person fields, permissions, and supporting data models.
Develop role-based access and multi-user workflows for sponsors, POCs, guests, administrators, and super users.
Implement business rules involving dates, times, statuses, availability, capacity limits, approvals, and user permissions.
Create Power BI reports and dashboards using SharePoint, Dataverse, and SQL-based data.
Perform ETL, data transformation, data modeling, validation, and calculation development for reporting solutions.
Build interactive Power BI visualizations, including custom Deneb visuals using JSON.
Use JSON and HTML in Power Apps to create formatted tables, email templates, summaries, reports, and customized interface components.
Query, validate, transform, and integrate Microsoft SQL Server data.
Conduct client demonstrations, gather feedback, and implement iterative enhancements.
Troubleshoot Power Apps, Power Automate, SharePoint, Dataverse, SQL Server, and Power BI issues.
Support application configuration, testing, deployment, version management, and post-production maintenance.
Create technical documentation, process documentation, user guidance, and solution design materials.
Other duties, tasks and projects as assigned.