Financial Management Data Analyst - Washington, DC

VetJobs; Washington (District of Columbia); On-site; USD 80,000 - 105,000; Full time

Job summary

PotomacWave Consulting in Washington, DC is seeking a Financial Management Data Analyst to support a Federal client. The role focuses on financial and procurement reporting, SharePoint page development, and data integration across systems, while collaborating with the team and stakeholders.

The candidate will design and implement Power Apps and Power Automate solutions, develop Power BI reports, and ensure governance and documentation to advance modernization efforts for CG Common Core and

Qualifications

• Bachelor's degree in Information Technology, Business, or a related field.
• 3-7 years of related experience.
• Excellent communication and customer service skills.
• Experience with SharePoint Online and Power Automate is highly desired.
• Familiar with FRMM and FAR and BI tools including Power BI, Tableau.

Responsibilities

• Develop, run, and analyze financial, procurement, training, and logistics reports and metrics.
• Develop and maintain SharePoint pages and CG Common Core materials.
• Create Power Apps and Power Automate workflows to support business rules and data processes.
• Design SharePoint structures, roles, and access; enable multi-user workflows.
• Develop Power BI reports/dashboards and perform ETL and data modeling.
• Coordinate with USCG stakeholders to gather requirements and translate them into actionable tasks.
• Support migrations, governance, and documentation for the CG Common Core project.

Skills

Power Apps

Power Automate

SharePoint

Power BI

Dataverse

SQL Server

JSON

HTML

Education

Bachelor's degree

Tools

CG Common Core

FSMS Oracle R12

Job description

Job Description

PotomacWave Consulting is looking for a Financial Management Data Analyst to join our team supporting a Federal client in Washington, DC. The Financial Management Data Analyst is familiar with procurement and will develop, manage, and maintain SharePoint pages to track and improve upon the client’s modernization efforts. The Financial Management Data Analyst collaborates and leads work assignments with other team members to ensure overall client satisfaction and PotomacWave's success on the project and in the client organization.

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.

Qualifications

• 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. 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
• Must be a US Citizen able to obtain a security clearance.

Salary range $80,000 - $105,000

Equal Opportunity Employer/Race/Sex/Religion/Disability/Veteran Status/Sexual Orientation/Gender Identity/National Origin/Age.