Power BI Developer

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 Inc. in Washington, D.C. seeks a Power BI Developer to design, build, and maintain dashboards that merge operational and financial data for actionable insights.

You will leverage SQL, ETL processes, and collaboration with developers to deliver clear business value. The ideal candidate has 4+ years with BI tools (Power BI/Tableau/Qlik), strong SQL, advanced Excel, and excellent communication to support data-driven decisions for stakeholders.

Qualifications

• Bachelor’s degree in Data Science, Computer Science, Statistics, or related field.
• 4+ years of experience with Power BI, Tableau or Qlik for large datasets.
• Strong SQL including optimization, CTEs, and complex joins.
• Advanced Excel for data analysis (pivot tables, VLOOKUP, complex formulas).
• US citizenship and ability to pass client background investigation; DHS/CBP/ICE preferred.
• Experience developing in Python (Pandas) and with PowerApps/Power Automate preferred.

Responsibilities

• Build, maintain, and optimize dashboards, reports, and data models in Power BI.
• Design and maintain ETL pipelines from SQL, SharePoint, and Excel sources.
• Collaborate with users to translate data outputs into visualizations.
• Translate data insights into clear, actionable recommendations for stakeholders.
• Ensure data accuracy and consistency across reports and dashboards.

Skills

Data visualization

SQL proficiency

Excel

Communication

Citizenship/background check

Education

Bachelor's degree in Data Science/CS/Statistics

Tools

Power BI

Tableau

Qlik

Python (Pandas)

PowerApps

Power Automate

Job description

Pay: $110,000.00 - $130,000.00 per year

Job Description: Power BI Developer

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:

• Building, maintaining, and optimizing dashboards, reports, and data models using Power BI and other visualization tools.
• Designing, building, and maintaining data ETL pipelines from sources such as SQL databases, SharePoint, and Excel
• Collaborating with end users and technical resources to understand and integrate data outputs into visualizations effectively.
• Translating complex data findings into clear, digestible insights for stakeholders to support data-driven decision-making.
• Ensuring data accuracy, consistency, and integrity across reports and dashboards.

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 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: Hybrid (Washington, D.C.)

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:

• 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

Application Question(s):

• This position requires U.S. citizenship. Are you a U.S. citizen currently residing in the U.S.?
• Do you have a DHS or DOD clearance?