Microsoft Power BI Developer

Foxhole Technology, Inc.•Fort Meade, MD

28d•$120,000 - $140,000•Hybrid

About The Position

Discover an exciting career at Foxhole Technology, an innovative IT Engineering firm founded in 2007. As leaders in cybersecurity, DEVSEC OPS, Agile Development, Cloud and IT support for federal civilian and defense agencies, we're at the forefront of addressing complex technology challenges. Our talented employee-owners provide agile, scalable solutions, bridging operational gaps, operating critical systems, and securing enterprises worldwide. If you're ready to be part of a team driving impactful innovations, apply today and shape the future of IT with us! Foxhole Technology is looking for a hands-on Microsoft Power BI Developer. This role is expected to work within a team managing a high-profile project that involves the migration of a marquee system within the Federal Government. The ideal candidate has experience with owning the full lifecycle of on-prem (PBIRS) reporting: updating existing Power BI reports, building new reports and measures/KPIs, optimizing the SQL they depend on, and validating visuals end-to-end.

Requirements

8 yrs experience working IT, Information Security and Information System projects.
3+ years building production Power BI reports and semantic models (DAX, calculation groups, field parameters).
Bachelor's Degree or above
Strong DAX skills; confident with queries and incremental refresh concepts.
Strong SQL Server / T-SQL skills, including query writing and optimization.
Proven experience with Power BI Report Server (PBIRS) or willingness to work primarily in an on-prem environment.
Solid understanding of data modeling (star schemas, fact/dimension design) and KPI design/validation.
Strong skillset with Git workflows: branching, committing, pull requests, and peer review.
Clear written and verbal communication; able to explain metrics and assumptions to non-technical users.
Experience converting cloud PBIX to PBIRS (visual/feature compatibility, RS-optimized Desktop).
Exposure to SSRS/SSIS or automating PBIRS deployments.
Prior work in federal or regulated environments.
Experience in Microsoft SQL Server
Strong documentation and communication skills
Must have strong oral and written communication skills and with the ability to tie organization objectives to mission critical objectives
Excellent problem-solving abilities

Nice To Haves

The Microsoft Power BI intelligence platform
SQL and SQL Server Reporting Services (SSRS)
Power BI Report Server (PBIRS)
Experience with Microsoft Office, including Word, PowerPoint, Project, Excel, and Visio

Responsibilities

Update and maintain existing Power BI reports and datasets (Power BI Report Server).
Build new reports, measures, and KPIs using DAX; design clean, actionable visuals for business stakeholders.
Optimize and improve underlying SQL (views, stored procedures, indexing) to improve report performance and reliability.
Create and execute test plans for data connections, refreshes, visuals, drill-downs, and row-level logic; validate numbers against source systems.
Refresh legacy PBIX to PBIRS with documented refresh paths.
Validate key measures/KPIs against source systems and signed off by business owners.
Migrate and re-platform cloud PBIX, where needed, to PBIRS-compatible solutions.
Document datasets, measures, refresh logic in clear SOPs.
Use Git for version control and code reviews.
Work with development teams and product managers to scope and deliver software solutions
Test software to ensure responsiveness and efficiency
Create technical documentation
Design and develop web services components for cross-application solutions
Implement best practices to maintain quality and ensure responsiveness of applications
Coordinate and prioritize application modifications and bug fixes

Benefits

Foxhole Technology offers a competitive benefits package for our employees and their dependents, including health, dental, and vision care, paid leave, retirement plans (401K, Roth, and ESOP), life and disability insurance, flexible spending accounts, and education and training assistance.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume