Senior BI & Analytics Engineer

SPN Solutions Inc. is seeking a Senior BI & Analytics Engineer to support a federal agency’s attorneys, field offices, and program staff with dashboards and AI-assisted views built for everyday decisions. This role focuses on translating agreed requirements into governed, tested data products that the agency accepts and uses, with strict reconciliation to trusted counts and accessibility validated for real users. What you will do Lead time-boxed working sessions with each office and the agency’s data and CIO staff to align on decisions and data expectations. Define every product, including the decision it supports, the grain, the system of record, inclusion rules, who can view it, and an example that demonstrates correctness. Develop dbt models using declared grain and tests for uniqueness, non-null keys, referential integrity, and accepted values. Create scheduled extracts that publish only after the full expected volume lands. Reconcile every released figure to a count the office already trusts before publishing. Build Apache Superset datasets over dbt models only (no ad hoc SQL), then create dashboards and AI-assisted views on top. Run acceptance testing with office users, including reconciliation checks, citation accessibility, and validation that restricted roles see only what they should. Ensure keyboard-accessible interfaces, pair charts with data tables, and validate that meaning is not conveyed by color alone, including contrast checks and screen reader testing. Produce an onboarding playbook, user and administrator documentation, and deliver enablement sessions. Document each pipeline end-to-end: source, schedule, dependencies, failure behavior, and owner. Required qualifications United States citizenship, with the ability to obtain a Public Trust Tier 2 determination. 5+ years experience across data engineering and business intelligence. Advanced SQL. Python with pandas. Production experience with Power BI, Tableau, Looker, or Apache Superset. Git. Demonstrated ability to build for non-technical users and drive adoption. Technologies and tools dbt, Apache Superset, PostgreSQL Python, pandas Power BI, Tableau, Looker Git, Apache Superset datasets Accessibility and testing tools: NVDA, JAWS, ANDI, axe, screen reader testing, and contrast analysis PIV, PostgreSQL read replica Work environment A governed PostgreSQL read replica of the agency’s case system. The agency’s dbt project for model and test development. Apache Superset with a developer role in dev and test. A data catalog where every curated dataset is registered. Agency Git repositories with CI/CD practices, with work committed from day one. Python with pandas and visualization libraries for reconciliation and analysis. Accessibility tooling including screen readers such as NVDA or JAWS, contrast analyzers, ANDI or axe. First 90 days Days 1–30: Suitability forms filed on day one; ramp with the Architect for Superset; working-session kit built; first office discovery held. Days 31–60: First office definition approved by the agency; dbt models with tests built in dev; second office discovery scheduled. Days 61–90: First Superset product in dev with AI features embedded and reconciled to the office’s control count; accessibility checks passing; acceptance script ready for month 4. How success is measured The first product accepted and actively used by month 7, with one for each office by month 10. Every released figure reconciles to its control count. Every product passes all four acceptance confirmations. Adoption materials delivered by month 9 and used by agency staff by month 11. Benefits Medical and prescription coverage Dental and vision Short-term disability Life and accidental death insurance Competitive 401(k) 11 paid federal holidays Paid vacation Paid sick leave Parental leave Tuition and professional development assistance Position details Location: Fairfax, VA (hybrid) Employment: Full time, W-2, salaried (exempt), employed by SPN Solutions Target start: 19 October 2026 Scheduling: Hybrid with some days in Washington, DC when needed; living in the Washington, DC area is preferred. Customer work uses a government-furnished laptop with a PIV credential. DHS Trusted Tester training is required in month 2 or 3 if not already held, and the training is free. If coming from Power BI, Tableau, or Looker, the first two to four weeks include a Superset ramp with the Architect. #J-18808-Ljbffr DataJobs.com