BI Developer: Power BI Dashboards & ETL (Hybrid, DC)

Constellation Inc; Washington (District of Columbia); Hybrid; USD 110,000 - 130,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 BI Developer to join the Homeland Security Team in Washington, D.C. Hybrid work arrangement. You will design, build, and maintain Power BI dashboards that combine operational and financial data to provide actionable insights for stakeholders.

The ideal candidate has 4+ years of experience with Power BI/Tableau/Qlik, strong SQL and Excel skills, and excellent communication to translate technical outputs into business value. U.S. citizenship and DHS clearance preferred.

Qualifications

• 4+ years of experience with large datasets in a data visualization tool (Power BI/Tableau/Qlik).
• Advanced SQL skills including optimization, CTEs, and complex joins.
• Advanced Excel skills for data analysis (pivot tables, VLOOKUP, formulas).
• Excellent communication to translate data findings for non-technical stakeholders.
• Bachelor's degree in Data Science/CS/Statistics or related field preferred.
• U.S. citizenship and ability to pass background investigation; DHS clearance preferred.
• Experience with Python (Pandas) for data analysis preferred.
• Experience with 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 SQL, SharePoint, and Excel sources.
• Collaborate with end users and tech teams to integrate data into visualizations.
• Translate complex data findings into clear insights for stakeholders.
• Ensure data accuracy, consistency, and integrity across reports.

Skills

Data visualization

SQL proficiency

Excel proficiency

Communication skills

Education

Bachelor's degree in Data Science/Computer Science/Statistics

Tools

Power BI

Tableau

Qlik

Python (Pandas)

Job description

Constellation is seeking a BI Developer to join the Homeland Security Team in Washington, D.C. Hybrid work arrangement. You will design, build, and maintain Power BI dashboards that combine operational and financial data to provide actionable insights for stakeholders.

The ideal candidate has 4+ years of experience with Power BI/Tableau/Qlik, strong SQL and Excel skills, and excellent communication to translate technical outputs into business value. U.S. citizenship and DHS clearance preferred.