Power BI Developer - Hybrid Dashboards & Data ETL

Constellation Inc; Washington (District of Columbia); Hybrid; USD 100,000 - 115,000; Full time

Benefits offered by this job

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

Job summary

Constellation is seeking a Power BI Developer to join our Homeland Security Team in Washington, D.C. The role focuses on designing, building, and maintaining Power BI dashboards that combine operational and financial data to deliver meaningful insights for stakeholders.

The ideal candidate will have advanced SQL skills and experience in ETL with data sources such as SQL databases, SharePoint, and Excel. The position is client-facing and requires excellent communication to translate complex

Qualifications

• 4+ years of experience with large datasets in a data visualization tool (Power BI/Tableau/Qlik).
• Advanced SQL skills: queries, CTEs and complex joins.
• Advanced Excel proficiency (pivot tables, VLOOKUP, complex formulas).
• Bachelor’s degree in Data Science, Computer Science, Statistics, or related field.
• U.S. citizenship and ability to pass a client background investigation; DHS clearance preferred.
• Experience with Python (Pandas) for data analysis preferred.
• Experience developing PowerApps and Power Automate preferred.

Responsibilities

• Build, maintain, and optimize dashboards, reports, and data models using Power BI and other tools.
• Design, build, and maintain ETL pipelines from sources like SQL databases, SharePoint, and Excel.
• Collaborate with end users and technical resources to integrate data outputs into visuals.
• Translate complex data findings into clear insights for stakeholders to support decision-making.
• Ensure data accuracy, consistency, and integrity across reports and dashboards.

Skills

Data visualization

Communication

Requirements gathering

Education

Bachelor’s degree in Data Science, Computer Science, Statistics or related field

Tools

Power BI

Tableau

Qlik

SQL

Excel

Python (Pandas)

PowerApps

Power Automate

Job description

Constellation is seeking a Power BI Developer to join our Homeland Security Team in Washington, D.C. The role focuses on designing, building, and maintaining Power BI dashboards that combine operational and financial data to deliver meaningful insights for stakeholders.

The ideal candidate will have advanced SQL skills and experience in ETL with data sources such as SQL databases, SharePoint, and Excel. The position is client-facing and requires excellent communication to translate complex