Develop Power BI dashboards, reports, data models, and analytical tools for federal consulting engagements. Gather stakeholder requirements, integrate and validate operational data, create DAX calculations and Power Query transformations, and support forecasting, staffing, cost, inventory, and performance analysis. Optimize and document solutions, conduct testing and training, and transfer knowledge to Government users. Collaborate with logistics, operations research, security, and project management stakeholders.
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
- 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
Similar Jobs
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Leads the Small Commercial Product AI investment roadmap from intake and prioritization through execution, adoption, and performance measurement. Coordinates cross-functional AI initiatives, manages portfolio dependencies and risks, partners with Product, Data Science, Technology, and AI enablement teams, supports responsible AI governance, and champions adoption of AI tools. The role requires program management expertise, business and technical fluency, strong influencing skills, and knowledge of insurance product, pricing, underwriting, and predictive modeling.
Top Skills:
AIEmblemExcelMicrosoft PowerpointPredictive ModelingSASSQL
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Handle inbound calls and warm leads, assess customers’ insurance needs, recommend appropriate property and casualty products, and convert prospects into policyholders. Representatives receive paid training and licensing support, manage customer interactions professionally, and meet sales goals through persuasive, customer-focused communication. The role is remote, requires a schedule of four weekdays and one weekend day, and includes maintaining a dedicated workspace with wired high-speed internet.
Top Skills:
Cable InternetDslFiber InternetPcWired High-Speed Internet
Consumer Web • Coupons • Healthtech • Social Impact • Pharmaceutical
Supports broad-reach paid media and integrated marketing campaigns across television, streaming video and audio, radio, and podcasts. Responsibilities include analyzing channel performance, recommending optimizations, monitoring digital marketing results, managing budgets and pacing, handling invoicing, building tracking assets, supporting campaign planning and launches, conducting competitive analysis, and presenting performance insights. The role collaborates with internal teams and external agency partners.
Top Skills:
C-TrackingCtvGoogle SuiteLinear TvMS OfficeOlvOttPaid MediaPodcastsQr CodesStreaming AudioStreaming VideoTerrestrial RadioUtm Tracking
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
