> Markdown version of [/jobs/ext/2845141-bi-dashboard-developer](https://www.wearedevelopers.com/jobs/ext/2845141-bi-dashboard-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # BI / Dashboard Developer - **Company:** BIZFIRST LLC - **Location:** Washington, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Business Intelligence Development, BigQuery, Delphi (Programming Language), Information Systems, Windows Communication Foundation, Microsoft SQL Server, Prism (Software), Power BI, Product Software Implementation Methods, Oracle Fusion Middleware, Systems Integration, Google Cloud, Microsoft Power Automate, Google Data Studio, Powerquery, Build Management, Information Technology, Data Analytics, Gsuite, Looker Analytics, Servicenow - **Published:** September 11, 2026 - **Apply:** https://www.thejobnetwork.com/job/3b064947-534d-4d6f-ba85-6e1c459178af/bi-dashboard-developer-dot ## About the Role Own the customer-facing proof: a certified drill-down billing view where each of 11 Operating Administrations can see its actual bill, the outputs billed, the rates charged, the calculations behind them, and the inputs those calculations used - five layers, one click at a time. The governing discipline: the reporting layer exposes controlled data; it never becomes a second source of truth. The client environment is Google-based - Google Workspace (Sheets, Drive, Chat, AppSheet, Apps Script) and Google Cloud analytics (BigQuery, Dataform, Looker), alongside Delphi, ServiceNow, and PRISM. Candidates with Microsoft-stack depth (Power BI, Power Automate, Power Query, SQL Server) and the aptitude to transfer are strong fits; direct Google-stack experience is a significant plus., · Security Clearance: Public Trust or the ability to obtain one. · Candidates whose experience is limited to advisory, strategic, or conceptual consulting will not meet this program's bar. The client explicitly requires demonstrated, hands-on implementation experience - deployed cost models, executed billing cycles, delivered automations, and operational financial products. · Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field, or equivalent additional experience. · 4+ years of BI development with semantic-layer modeling (LookML, Power BI datasets/DAX, or equivalent) and strong SQL. · Demonstrated delivery of stakeholder-facing financial dashboards with drill-through from summary to transaction-level support. · Experience implementing report-layer security for multi-tenant or multi-customer audiences. · Design judgment for executive and analyst audiences - clarity at the summary, completeness at the detail, honesty in the labeling. ## Description BizFirst is assisting our client with recruiting a skilled and experienced BI / Dashboard Developer. This position supports the following program: U.S. Department of Transportation (DOT), Office of the Secretary (OST), Working Capital Fund (WCF), Office of Financial Management (OFM) - WCF IT Financial Management, Cost Model Development, and Systems Integration Support. Our client is a boutique consulting firm that employs consultants and professionals with unique skill sets to support the federal government with strategic execution, financial process enablement, IT systems, and Enterprise Resource Planning (ERP) software implementation., · Design and build the OA drill-down billing views in Looker (LookML semantic models) and Looker Studio: bill * outputs * rates * calculations * inputs, with the reconciliation to Delphi one click beneath. · Build against certified datasets only; implement view-equals-bill reconciliation checks so publication is blocked until the customer view ties to the issued bill and the bill ties to Delphi. · Implement OA data segregation in the semantic layer (Looker access filters and user attributes) aligned to the data-layer row-level policies; test roles before every release. · Enforce display discipline: estimates, accruals, proxies, true-ups, and pending corrections labeled and visually distinct from posted actuals; prior-period corrections linked, never blended; refresh date and period-covered shown on every page. · Deliver Section 508-conformant reports and views as a release-readiness requirement, not an afterthought. · Build the operational metrics views: dispute and exception aging, unexplained adjustments, cycle time, and bill-line traceability against DOT-set baselines. · Document the semantic model and view logic so Government personnel can maintain and extend the reporting layer. ## Related Videos - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Data Governance in the Era of AI](https://www.wearedevelopers.com/videos/1622-data-governance-in-the-era-of-ai) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [The Biggest German Tech Companies](https://www.wearedevelopers.com/magazine/424-the-biggest-german-tech-companies) - [Got AI ideas but no money? Here are 10 free ways to level up your AI skills with Google Cloud](https://www.wearedevelopers.com/magazine/600-got-ai-ideas-but-no-money-here-are-10-free-ways-to-level-up-your-ai-skills-with-google-cloud)