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
Owns the Small Commercial Product AI investment roadmap and portfolio from intake and prioritization through execution, adoption, and performance measurement. Drives cross-functional AI initiatives, coordinates with Product, Data Science, Technology, and AI enablement teams, establishes business cases and KPIs, supports responsible AI governance, and promotes adoption of AI tools. Requires strong program management, stakeholder influence, analytical expertise, and knowledge of insurance product, pricing, underwriting, and predictive modeling.
Top Skills:
AIEmblemExcelPowerPointPredictive ModelingSASSQL
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Handles inbound calls and warm leads, consults customers on insurance needs, recommends appropriate Property and Casualty coverages, and converts prospects into policyholders. Completes paid licensing and sales training, represents the Liberty Mutual brand, provides customer-focused service, and meets sales goals. Requires a flexible schedule covering four weekdays and one weekend day, plus a compliant home workspace and high-speed wired internet connection.
Top Skills:
Cable/Fiber/Dsl InternetPc
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 coverages, and convert prospects into policyholders. The role includes paid training and licensing, customer-focused sales, brand representation, schedule flexibility, and remote work requirements. Representatives must meet performance goals, communicate persuasively, maintain strong organizational skills, and work four weekdays plus one weekend day on assigned shifts.
Top Skills:
PcWired High-Speed Internet
What you need to know about the Seattle Tech Scene
Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.
Key Facts About Seattle Tech
- Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Amazon, Microsoft, Meta, Google
- Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Madrona, Fuse, Tola, Maveron
- Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute
