BI / Dashboard Developer

BizFirst; Washington; On-site; USD 90,000 - 130,000; Part time

Benefits offered by this job

Family Health Care

Family Dental

Unlimited Leave

401k matching

Job summary

BizFirst is recruiting a skilled BI / Dashboard Developer to support the U.S. Department of Transportation program. The role focuses on building OA drill-down billing views, semantic models, and secure data access across multiple administrations.

Responsibilities include data segregation, disclosure controls, and end-to-end validation from inputs to Delphi. Proficiency in Looker/LookML, Power BI, SQL, and Google Cloud tools is highly valued, with federal context a plus.

Qualifications

• Hands-on implementation experience with cost models, billing cycles, and automations.
• Delivery of stakeholder-facing dashboards with drill-through from summary to transaction-level data.
• Experience implementing report-layer security for multi-tenant audiences.

Responsibilities

• Design and build OA drill-down billing views in Looker and Looker Studio.
• Ensure view-equals-bill reconciliation and publish only when aligned to Delphi.
• Apply row-level access controls and test roles prior to releases.
• Highlight frontend clarity: include estimates, accruals, true-ups, and posting dates.
• Deliver accessible Section 508-compliant reports and dashboards.

Skills

LookML

Power BI

SQL

Data Visualization

BigQuery

Looker Studio

Education

Bachelor’s degree in Computer Science or related field

Tools

Looker

LookML

Power BI

SQL Server

BigQuery

Job description

Washington, United States | Posted on 08/06/2026

• Security Clearance: Public Trust or the abilityto obtain one.
• Job Type: Part-time (W2) or 1099 independentcontractor
• Benefits: Our client provides full benefits toW2 employees, including part-time.
• Program Name: Working Capital Fund (WCF), Officeof Financial Management (OFM) - WCF IT Financial Management, Cost ModelDevelopment, and Systems Integration Support
• Agency name: U.S. Department of Transportation(DOT), Office of the Secretary (OST)
• Work Location (FYI): DOT Headquarters, 1200 NewJersey Ave SE, Washington, DC 20590

BizFirst is assisting our clientwith recruiting a skilled and experienced BI / Dashboard Developer. Thisposition supports the following program: U.S. Department of Transportation(DOT), Office ofthe Secretary (OST), Working Capital Fund (WCF), OfficeofFinancial Management (OFM) — WCF IT Financial Management, Cost ModelDevelopment, and Systems Integration Support.

Our client is a boutiqueconsulting firm that employs consultants and professionals with unique skillsets to support the federal government with strategic execution, financialprocess enablement, IT systems, and Enterprise Resource Planning (ERP) softwareimplementation.

What will you do

Own the customer-facing proof: acertified drill-down billing view where each of 11 Operating Administrationscan see its actual bill, the outputs billed, the rates charged, thecalculations behind them, and the inputs those calculations used — five layers,one click at a time. The governing discipline: the reporting layer exposescontrolled data; it never becomes a second source of truth. The clientenvironment is Google-based — Google Workspace (Sheets, Drive, Chat, AppSheet,Apps Script) and Google Cloud analytics (BigQuery, Dataform, Looker), alongsideDelphi, ServiceNow, and PRISM. Candidates with Microsoft-stack depth (Power BI,Power Automate, Power Query, SQL Server) and the aptitude to transfer arestrong fits; direct Google-stack experience is a significant plus.

Responsibilities:

• Design and build the OA drill-down billing viewsin 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; implementview-equals-bill reconciliation checks so publication is blocked until thecustomer view ties to the issued bill and the bill ties to Delphi.
• Implement OA data segregation in the semanticlayer (Looker access filters and user attributes) aligned to the data-layerrow-level policies; test roles before every release.
• Enforce display discipline: estimates, accruals,proxies, true-ups, and pending corrections labeled and visually distinct fromposted actuals; prior-period corrections linked, never blended; refresh dateand period-covered shown on every page.
• Deliver Section 508-conformant reports and viewsas a release-readiness requirement, not an afterthought.
• Build the operational metrics views: dispute andexception aging, unexplained adjustments, cycle time, and bill-linetraceability against DOT-set baselines.
• Document the semantic model and view logic soGovernment personnel can maintain and extend the reporting layer.

Requirements:

• Security Clearance: Public Trust or the abilityto obtain one.
• Candidates whose experience is limited toadvisory, 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, andoperational financial products.
• Bachelor’s degree in Computer Science,Information Systems, Data Analytics, or a related field, or equivalentadditional experience.
• 4+ years of BI development with semantic-layermodeling (LookML, Power BI datasets/DAX, or equivalent) and strong SQL.
• Demonstrated delivery of stakeholder-facingfinancial dashboards with drill-through from summary to transaction-levelsupport.
• Experience implementing report-layer securityfor multi-tenant or multi-customer audiences.
• Design judgment for executive and analystaudiences — clarity at the summary, completeness at the detail, honesty in thelabeling.

Desired Skills

• Looker and LookML; Looker Studio; BigQuery asthe backing store; Connected Sheets for analyst access.
• Power BI or Tableau depth with clear transferaptitude — semantic modeling and row-level security patterns carry directly.
• Federal financial reporting context (WCFbilling, audit-ready lineage); Section 508 / accessibility testing experience.

Benefits (provided by ourclient; W2 employees only, including part-time):

• Family Health Care (54% cost covered for theentire family)
• Family Dental (54% cost covered for the entirefamily)
• Family Vision (54% cost covered for the entirefamily)
• Overutilization bonuses for Time and Materials(T&M) contracts
• Lifetime Event Bonuses (e.g., child, marriage)
• Profit-sharing arrangement for any work broughtinto the company
• Unlimited Leave with Approval
• 401k 100% employer match on first 4% invested

BizFirst LLC is an Equal Opportunity Employer and does not discriminate on the basis of race or ethnicity, religion, sex, national origin, age, veteran disability or genetic information or any other reason prohibited by law in employment.