Power BI Dashboard Developer/Consultant

Goldschmitt and Associates; United States; Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

401(k) with immediate vesting

Paid Federal Holidays

Tuition Reimbursement

Medical Insurance, including Vision & 

Disability Insurance

Life Insurance

FSA/HSA Programs

Commuter Benefits

Adoption Assistance

Employee Assistance Program

Caregiver Support Program

Health Advocacy Program

Financial Wellbeing Support

Job summary

Goldschmitt and Associates seeks a Power BI Dashboard Developer/Consultant to design and develop analytical tools, dashboards, data models, and decision-support solutions for a federal engagement.

You will collaborate with logistics, security, operations, and Government stakeholders to translate requirements into transparent, maintainable dashboards and reusable analytic tools that deliver actionable insights on performance, staffing, inventory, and costs.

Qualifications

• Bachelor’s degree and 5+ years in BI, analytics, dashboards, or data visualization
• 3+ years hands-on Power BI development
• Ability to pass and maintain eligibility for a Public Trust investigation
• Experience translating business requirements into analytical solutions
• Experience documenting data sources and technical guidance

Responsibilities

• Gather and document business, reporting, analytics, and dashboard requirements from Government stakeholders
• Design Power BI data models integrating data from multiple sources
• Develop dashboards, reports, scorecards, and analytical tools for inventory, staffing, cost, and operations
• Create measures, calculations, and business logic using DAX
• Use Power Query to transform and integrate source data
• Develop data relationships and dimensional models for scalable reporting
• Validate data and reconcile outputs with source systems
• Prepare user guides and training materials

Skills

Power BI

DAX

Power Query

Data modeling

SQL

Excel

Documentation

Communication

Data validation

Analytics

Education

Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Business Analytics, Engineering, Mathematics, Statistics, or related discipline

Tools

Power BI Service

Power Platform

SharePoint

Azure

Microsoft Excel

Job description

At Goldschmitt and Associates LLC (G&A), we’re not just another company—we’re a catalyst for innovation and impact, and we’re inviting passionate, forward-thinking individuals to join us on this journey. Recognized multiple times on the Inc 5000 list of the fastest-growing companies, G&A is a leader in tech transformation and system modernization for some of the nation’s most important federal agencies.

Our culture is built on creativity and collaboration. We offer flexible schedules, telework options, and an environment where your ideas truly matter. At G&A, you won’t just clock in—you’ll be solving real-world challenges and working on projects that make a difference in the lives of millions.

Joining our team means becoming part of a vibrant, connected community where innovation thrives, your voice is heard, and your impact is felt. Whether you’re a tech enthusiast, a strategic thinker, or a problem-solver, at G&A, you’ll have the opportunity to level up your career while making a real-world impact.

If you’re ready to be part of a company that values purpose as much as progress, G&A is the place for you!

Summary:
The Power BI Dashboard Developer/Consultant will support a federal consulting engagement by designing and developing analytical tools, dashboards, data models, and decision-support solutions that transform operational, inventory, staffing, cost, and performance data into actionable information.

The consultant will work directly with logistics, security, operations, and Government stakeholders to understand business requirements, evaluate source data, develop data models and calculations, and create intuitive Power BI dashboards and reusable analytical tools.

This position requires both strong technical Power BI capabilities and the consulting skills necessary to translate complex operational requirements into transparent, maintainable solutions that can ultimately be sustained by Government personnel.

Job Duties and Responsibilities:

• Gather and document business, reporting, analytical, and dashboard requirements from Government stakeholders and project subject matter experts
• Assess source data for completeness, consistency, accuracy, and suitability for analysis and visualization
• Design Power BI data models integrating information from multiple operational and administrative data sources
• Develop dashboards, reports, scorecards, and analytical tools supporting inventory, asset lifecycle, workload, staffing, cost, and operational analysis
• Develop measures, calculations, key performance indicators, and business logic using DAX
• Use Power Query to transform, cleanse, standardize, and integrate source data
• Develop data relationships and dimensional models that support accurate and scalable reporting
• Create visualizations that enable users to identify trends, risks, gaps, workload patterns, lifecycle requirements, and other actionable information
• Support development of staffing models, workload models, cost models, forecasting tools, and decision matrices
• Translate quantitative models and business rules developed by subject matter experts into functional analytical tools
• Develop drill-down and filtering capabilities appropriate for executive, program, regional, facility, or asset-level analysis
• Conduct data validation and reconcile dashboard outputs to authoritative source data
• Perform user acceptance testing and resolve identified defects or data discrepancies
• Optimize dashboards for usability, accessibility, performance, and maintainability
• Document data sources, transformations, calculations, assumptions, business rules, and refresh procedures
• Develop user guides, data dictionaries, technical documentation, and training materials
• Conduct demonstrations and training sessions for Government users
• Support knowledge transfer to enable Government personnel to update, maintain, and modify dashboards without continued contractor dependency
• Collaborate with logistics consultants, operations research analysts, security subject matter experts, and project management personnel
  Necessary Skills and Knowledge:
• Advanced proficiency with Power BI Desktop and Power BI Service
• Demonstrated proficiency with DAX and Power Query
• Experience developing relational and dimensional data models
• Experience integrating, cleansing, transforming, and validating data from multiple sources
• Strong proficiency with Microsoft Excel
• Working knowledge of SQL and relational databases
• Demonstrated experience translating business requirements into analytical and reporting solutions
• Experience developing technical documentation and user-facing guidance.
• Strong analytical, problem-solving, and communication skills
• Ability to explain technical concepts and analytical results to nontechnical stakeholders
• Ability to obtain and maintain required federal background investigation, security, and facility-access requirements
• Minimum Qualifications:
• Possess a Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Business Analytics, Engineering, Mathematics, Statistics, or a related discipline
• Possess at least 5 years of professional experience in business intelligence, data analytics, dashboard development, or data visualization
• Possess at least 3 years of hands‑on experience developing solutions in Microsoft Power BI
• Possess the ability to pass and maintain eligibility for a Public Trust investigation
• Preferred Qualifications:
• Microsoft Certified: Power BI Data Analyst Associate (PL-300)
• Experience supporting federal government consulting engagements
• Experience developing dashboards for logistics, inventory, asset management, workforce planning, physical security, or operational programs
• Experience developing forecasting, workload, staffing, cost, or resource-allocation models
• Experience working with large or complex operational datasets
• Experience designing data structures or databases supporting asset and inventory management
• Knowledge of data governance, data‑quality management, and master‑data concepts
• Experience with Microsoft Power Platform, SharePoint, Azure, or related Microsoft technologies
• Familiarity with Section 508 accessibility requirements for federal information technology
• Experience conducting dashboard training and transferring solutions to Government users

NOTE: This job description is not intended to be an exhaustive list of all duties, responsibilities or qualifications associated with the job. It is intended to describe the general nature and work responsibilities of the position. This job description and the duties of this position are subject to change, modification and addition as deemed necessary by the Company.

Goldschmitt and Associates offers the following benefits:

• 401(k) with immediate vesting
• Paid Federal Holidays
• Tuition Reimbursement
• Medical Insurance, including Vision and Dental Insurance
• Employer-Paid Short-Term and Long-Term Disability
• Employer Paid Life Insurance
• Supplemental Life Insurance
• FSA/HSA Programs
• Commuter Benefits Program
• Adoption Assistance Program
• Employee Assistance Program (EAP)
• Caregiver Support Program
• Health Advocacy Program
• Financial Wellbeing Support

Goldschmitt and Associates is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.