Note: The job is a remote job and is open to candidates in USA. Goldschmitt and Associates LLC is a technology transformation and system modernization company supporting federal agencies. The Power BI Dashboard Developer/Consultant will design and develop data models, dashboards, analytical tools, and decision-support solutions while translating operational requirements into maintainable Power BI solutions. The role also involves data validation, documentation, user training, and knowledge transfer to Government personnel.
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
Skills
- 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
- 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
- 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
Benefits
- Flexible schedules
- Telework options
- Opportunity to level up your career
- Collaborative work environment
Company Overview