Power BI Developer

Constellation Inc

Washington (District of Columbia)

Hybrid

USD 100,000 - 115,000

Full time

3 days ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

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

Pay

$100,000.00 - $115,000.00 per year

Power BI Developer (Hybrid)

Constellation is seeking a Power BI Developer to join our Homeland Security Team in Washington, D.C. This role requires advanced dashboarding and data analysis skills. The developer 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 optimizedashboards, reports, and data models using Power BI and other visualization tools.
Design, build, and maintaindata ETL pipelines from sources such as SQL databases, SharePoint, and Excel
Collaboratewith end users and technical resources to understand and integrate data outputs into visualizations effectively.
Translatecomplex data findings into clear, digestible insights for stakeholders to support data-driven decision-making.
Ensuredata accuracy, consistency, and integrity across reports and dashboards.

Ideal Candidate Requirements

At least 4 years of experience working with large datasets in a Data Visualization tool like Power BI, Tableau or Qlik.
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).
Excellent communication skills with the ability to gather requirements, present solutions, and translate complex data findings into clear insights for non-technical stakeholders.
Bachelor’s degree is required, with major in Data Science, Computer Science, Statistics, or a related field preferred.
Must be a U.S. citizen, able to pass a background investigation by the client agency. DHS clearance with CBP or ICE preferred.
Experience developing in Python (Pandas) for data analysis is preferred.
Experience developing PowerApps and Power Automate solutions is preferred.

Job Type

Full-time

Work Location

Washington, DC (Hybrid)

Education

Bachelor's Degree with major in Data Science, Computer Science, Statistics, or a related field (Required)

Experience

Power BI OR Tableau OR Qlik: 4 years (Required)

Benefits