Senior BI & Analytics Engineer

SPN Solutions Inc. is seeking a Senior BI & Analytics Engineer to deliver trusted dashboards and AI-assisted views for a federal agency’s attorneys, field offices, and program staff.

Responsibilities

• Facilitate time-boxed working sessions with each office plus agency data and CIO staff
• Define each analytics product: supported decision, data grain, system of record, inclusion rules, authorized audiences, and an example that demonstrates correctness
• Develop dbt models with declared grain and quality checks for uniqueness, non-null keys, referential integrity, and accepted values
• Create scheduled extracts that publish only after the full expected volume arrives
• Reconcile every released figure to a control count the office already trusts
• Build Apache Superset datasets directly on top of dbt models (no ad hoc SQL), then implement dashboards and AI-assisted views on top
• Run acceptance testing with office users: reconcile values, confirm citations open, validate restricted roles see only permitted data, and ensure keyboard usability
• Pair each chart with a supporting data table; avoid conveying meaning via color alone; verify contrast; test end-to-end tasks using a screen reader
• Write an onboarding playbook, user documentation, and administrator documentation; deliver enablement sessions
• Document each pipeline: sources, schedules, dependencies, failure behavior, and ownership

Requirements

• United States citizenship and ability to obtain a Public Trust Tier 2 determination
• 5+ years across data engineering and business intelligence
• Advanced SQL
• Python with pandas
• Production experience with Power BI, Tableau, Looker, or Apache Superset
• Git
• Proven track record building for non-technical users and driving adoption of delivered products

Technologies

• dbt
• Apache Superset (including Apache Superset datasets)
• PostgreSQL (including PostgreSQL read replica)
• Python, pandas
• Power BI, Tableau, Looker
• Git
• Accessibility and testing: NVDA, JAWS, ANDI, axe, screen reader, contrast analyzer
• PIV credential

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

Working Environment

• 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
• Data catalog with registration of every curated dataset
• Agency Git repositories and CI/CD, with commits from day one
• Python with pandas plus visualization and reconciliation libraries
• Accessibility tools for verification (screen readers such as NVDA or JAWS, ANDI or axe, contrast analysis)

First 90 Days

• Days 1 to 30: suitability forms filed on day one; Superset ramp with the Architect; working-session kit built; first office discovery held
• Days 31 to 60: first office definition approved by the agency; dbt models with tests built in dev; second office discovery scheduled
• Days 61 to 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 Work Is Judged

• First product accepted and in active use by month 7, and one per office by month 10
• Every released figure reconciles to its control count
• Every product passes all four acceptance confirmations
• Adoption package delivered by month 9 and used by agency staff themselves by month 11

What Sets a Candidate Apart

• Active Public Trust Tier 4 or Secret
• dbt in production
• Apache Superset and PostgreSQL
• WCAG testing experience or DHS Trusted Tester certification
• Experience working with legal, investigative, or case-management data
• PL-300 or DP-600
• Living in the Washington, DC area

Terms and Application

• Full time, W-2, salaried (exempt); employed by SPN Solutions
• Target start date: 19 October 2026
• Hybrid: based in Fairfax, Virginia; some days in Washington, DC when needed (living in the Washington, DC area preferred)
• Government-furnished laptop with PIV credential used for all customer work
• DHS Trusted Tester training completed in month 2 or 3 if not already held (free)
• If coming from Power BI, Tableau, or Looker, first 2 to 4 weeks include a Superset ramp with the Architect
• Apply via the provided link with your resume
• A recruiter reviews applications and responds within two business days
• Application prompt: submit two to three lines about one product you built that non-technical users relied on, and how you verified the numbers were correct