Power BI Financial Analyst

Pay: $145,000.00 - $155,000.00 per year Job Description: Power BI Financial Analyst Constellation seeks a Power BI Developer Financial Analyst to join our Homeland Security Team in Washington, DC. This role requires advanced dashboarding and data analysis skills. The analyst will design, build, and maintain Power BI dashboards that integrate operational and financial data to create meaningful, actionable insights for stakeholders. This role requires a strong understanding of SQL and coordination with other developers for extraction, transformation, and loading of data. This position is client-facing and requires excellent communication to translate complex technical outputs into clear business value. Key Responsibilities: Build, maintain, and optimize dashboards, reports, and data models using Power BI and other visualization tools. Design, build, and maintain data ETL pipelines from sources such as SQL databases, SharePoint, and Excel. Track, monitor, and reconcile program budgets, spend plans, obligations, and expenditures, providing regular financial status updates to leadership. Collaborate with end users and technical resources to understand and integrate data outputs into visualizations effectively. Translate complex data findings into clear, digestible insights for stakeholders to support data-driven decision-making. Ensure data accuracy, consistency, and integrity across reports and dashboards. Ensure compliance with DHS/CBP financial policies, procedures, and reporting requirements. The ideal candidate must have the following experience, background, and credentials: At least 4 years of experience working with large datasets in a Data Visualization tool like Power BI, Tableau, Qlik. Bachelor’s degree is required, with major in Data Science, Computer Science, Statistics, or a related field preferred. Minimum 5 years of experience in program financial management, budgeting, or acquisition support for government programs. Advanced understanding of SQL including