Financial Analyst, Power BI

Job not on LinkedIn

🔥 2 minutes ago

🏛️ District of Columbia, Washington – Remote

🏛️ District of Columbia – Remote ☕ Washington – Remote

💵 $145k - $155k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

📊 Business Intelligence Developer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Constellation Inc

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 2006

💼 Consulting

🏛️ Government

🔐 Security

Consulting • Government • Security

Constellation Inc. is a U. S. federal government professional services firm that delivers data-driven consulting and technical solutions to national security and homeland security agencies. For over two decades it has supported DHS, FEMA, CBP and other federal clients with analytics and automation, program management, digital transformation, enterprise architecture, and intelligence community services. Constellation provides cleared personnel and focuses on modernizing legacy systems, improving operational performance, and delivering measurable mission outcomes.

📋 Description

• 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.

🎯 Requirements

• 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 query optimization, common table expressions (CTEs), and complex joins for deep-dive analysis. • Advanced proficiency in Excel for standard data analysis tasks (pivot tables, VLOOKUP, complex formulas). • Support strategic financial projects, including the development of tools, dashboards, and reports to improve visibility into financial management activities. • Prepare financial briefings, reports, and recommendations for senior executives and stakeholders. • Excellent communication skills with the ability to gather requirements, present solutions, and translate complex data findings into clear insights for non-technical stakeholders. • Experience developing PowerApps and Power Automate solutions is preferred. • Experience using SAP is preferred. • Be a U.S. citizen able to pass a background investigation by the client agency. • DHS clearance with CBP or DHS preferred.

🏖️ Benefits

• 401(k) • 401(k) contribution • Medical insurance • Dental insurance • Vision insurance • Life & Disability Insurance • Flexible Spending Account • Paid time off • Professional development • Employee assistance program • Work-life balance