Federal BI Dashboard Architect - Power BI Analytics

Aalis Management Consulting; Washington (District of Columbia); On-site; USD 85,000 - 125,000; Full time

Job summary

Aalis Management Consulting seeks a BI / Dashboard Developer to support a federal agency's IT Financial Management modernization, WCF reporting, and data analytics initiatives.

You will design, develop, and maintain interactive dashboards, data models, and automated reporting workflows using Power BI, turning complex financial data into actionable insights for leadership and program managers. This onsite Washington, DC role requires collaboration with analysts and government stakeholders.

Qualifications

• Bachelor's degree in Business, Finance, Accounting, Information Systems, Data Analytics, Computer Science, or related field.
• 5+ years building BI solutions, dashboards, reporting tools, or data visuals.
• Hands-on experience with Microsoft Power BI.
• Experience gathering requirements and translating them to reports.
• Experience with complex data sets and data analysis.
• Experience with data validation and quality assurance activities.
• Experience using SQL or similar tools.

Responsibilities

• Design, develop, test, and maintain executive dashboards and reporting solutions.
• Develop interactive dashboards and data visualization products using Microsoft Power BI.
• Analyze financial and operational data to identify trends, performance indicators, risks, and improvement opportunities.
• Translate financial management requirements into dashboard designs, reporting specifications, and analytics solutions.
• Develop data models, dashboards, scorecards, and reporting products to support: Working Capital Fund reporting; Cost model analysis; Financial performance tracking; Budget execution monitoring; Resource utilization analysis; Executive decision-making.
• Create automated reporting solutions to reduce manual data collection and reporting processes.
• Collaborate with financial analysts and business stakeholders to define KPIs and reporting requirements.
• Perform data validation, quality checks, and reconciliation to ensure dashboard accuracy.
• Integrate data from multiple sources and systems into reporting solutions.
• Develop dashboards supporting: Financial metrics, Cost allocation, Billing activities, Rate analysis, Program performance, Operational reporting.
• Support data visualization standards, reporting governance, and dashboard best practices.
• Document dashboard functionality, data sources, calculations, and user procedures.
• Troubleshoot reporting issues and resolve data quality challenges.
• Support audit readiness by maintaining reporting documentation, data lineage, and analytical records.
• Collaborate with technical teams supporting data integration, automation, and enterprise reporting solutions.

Skills

Power BI

Data analysis

Business requirements gathering

SQL

Stakeholder communication

Education

Bachelor's degree in Business, Finance, Accounting, Information Systems, Data Analytics, Computer Science, or related field

Tools

SQL

Job description

Aalis Management Consulting seeks a BI / Dashboard Developer to support a federal agency's IT Financial Management modernization, WCF reporting, and data analytics initiatives.

You will design, develop, and maintain interactive dashboards, data models, and automated reporting workflows using Power BI, turning complex financial data into actionable insights for leadership and program managers. This onsite Washington, DC role requires collaboration with analysts and government stakeholders.