Senior BI & Analytics Engineer - AI Dashboards for Data

DataJobs; Fairfax (VA); Hybrid; USD 120,000 - 170,000; Full time

Benefits offered by this job

Medical coverage

Dental & Vision

401(k)

Paid vacation

Parental leave

Professional development

Holidays and time off

Sick leave

Life insurance

Disability insurance

Job summary

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.

You will translate requirements into governed data products with trusted counts and accessibility validated for real users. Responsibilities include defining products, developing dbt models, building Superset datasets, and conducting acceptance testing with users.

Qualifications

• U.S. citizenship with ability to obtain Public Trust Tier 2.
• 5+ years of experience across data engineering and business intelligence.
• Advanced SQL proficiency.
• Python with pandas.
• Production experience with Power BI, Tableau, Looker, or Apache Superset.
• Git version-control experience.
• Demonstrated ability to build for non-technical users and drive adoption.

Responsibilities

• 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 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.

Skills

Advanced SQL

Python

Pandas

Non-technical user enablement

Data warehousing concepts

Tools

dbt

Apache Superset

PostgreSQL

Power BI

Tableau

Looker

Git

Job description

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.

You will translate requirements into governed data products with trusted counts and accessibility validated for real users. Responsibilities include defining products, developing dbt models, building Superset datasets, and conducting acceptance testing with users.