BI Developer

Constellation Inc

United States

Remote

USD 100,000 - 115,000

Full time

7 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

401(k)
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. is seeking a Power BI Developer to join our Homeland Security Team with a remote work option. The role focuses on designing, building, and maintaining dashboards that merge operational and financial data to deliver actionable insights for stakeholders.

The ideal candidate has 4+ years of experience with Power BI/Tableau/Qlik, advanced SQL, and strong Excel skills, plus a related Bachelor's degree. U.S. citizenship and DHS-related clearance are preferred.

Qualifications

  • 4+ years of experience with large datasets in Power BI/Tableau/Qlik.
  • Advanced SQL knowledge: CTES and complex joins.
  • Advanced Excel skills (pivot tables, VLOOKUP, formulas).
  • Excellent communication to translate data findings for non-technical stakeholders.
  • Bachelor's degree in Data Science/CS/Statistics.
  • Must be a U.S. citizen; able to pass DHS background check.
  • Experience with Python (Pandas) for data analysis.
  • Experience with PowerApps and Power Automate is a plus.

Responsibilities

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

Skills

Power BI
SQL
Excel
Communication
Python

Education

Bachelor's degree (Data Science/CS/Statistics)

Tools

Power BI
PowerApps
Power Automate
Python (Pandas)

Job description

Pay: $100,000.00 - $115,000.00 per year

BI Developer - Remote

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.
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: Remote

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

Experience: Power BI ORTableau 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?
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

BI Developer
BI Developer

Constellation Inc • Oregon

Hybrid
USD 100,000 - 115,000
401(k)
Medical insurance
Dental insurance
+7
BI Developer
BI Developer

Constellation Inc • Washington

Remote
USD 100,000 - 115,000
401(k)
Medical insurance
Dental insurance
+7
BI Developer
BI Developer

Constellation Brands • Washington

Hybrid
USD 100,000 - 115,000
401(k)
401(k) contribution
Medical insurance
+8
Power BI Developer
Power BI Developer

Constellation Inc • Washington

Hybrid
USD 100,000 - 115,000
401(k)
401(k) contribution
Medical insurance
+8
Power BI Developer
Power BI Developer

Constellation Brands • Washington

Hybrid
USD 100,000 - 115,000
401(k)
Medical insurance
Dental insurance
+7
Power BI Developer
Power BI Developer

Amatriot Group • United States

Remote
USD 100,000 - 118,000
Remote BI Visualization Specialist - Power BI & Dashboards
Remote BI Visualization Specialist - Power BI & Dashboards

Constellation Inc • United States

Remote
USD 100,000 - 115,000
401(k)
Medical insurance
Dental insurance
+7
Power BI Analyst
Power BI Analyst

LMI • Tysons (VA)

Remote
USD 76,000 - 131,000
Power BI Developer
Power BI Developer

ASRC Federal • United States

Remote
USD 90,000 - 130,000
BI Developer / Data Analyst
BI Developer / Data Analyst

ProSidian Consulting, LLC • Alexandria (VA)

Hybrid
USD 70,000 - 95,000
Competitive compensation and performance incentives
Group medical, dental, and vision insurance
401(k) retirement plan with company match
+4