4+ years of experience with large datasets in Power BI, Tableau, or Qlik.
Advanced SQL skills, including query optimization and complex joins.
Proficient in Excel for data analysis tasks like pivot tables and VLOOKUP.
Strong communication skills for translating technical data into business insights.
Bachelor's degree in Data Science, Computer Science, Statistics, or related field required.
U.S. citizenship and ability to pass a background investigation required.
Preferred experience in Python (Pandas) and developing PowerApps/Power Automate solutions.
Responsibilities
Build and optimize dashboards and reports using Power BI and visualization tools.
Design and maintain ETL pipelines from SQL databases, SharePoint, and Excel.
Collaborate with users and technical teams to integrate data into visualizations.
Translate complex data findings into clear insights for stakeholders.
Ensure data accuracy and integrity across reports and dashboards.
Benefits
401(k) plan with contributions
Medical, dental, and vision insurance
Life and disability insurance
Flexible spending account
Paid time off
Professional development opportunities
Employee assistance program
Focus on work-life balance
Full Job Description
Pay: $100,000.00 - $115,000.00 per year
Job Description: 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 optimize dashboards, reports, and data models using Power BI and other visualization tools.
Design, build, and maintain data ETL pipelines from sources such as SQL databases, SharePoint, and Excel
Collaborate with end users and technical resources to understand and integrate data outputs into visualizations effectively.
Translate complex data findings into clear, digestible insights for stakeholders to support data-driven decision-making.
Ensure 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: 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:
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.?
