Senior BI & Analytics Engineer

Why this job exists

The environment you will work in

What you will do

• Run time-boxed working sessions with each office and with the agency's data and CIO staff
• Write each product definition: the decision it supports, the grain, the system of record, the inclusion rules, who may see it, and an example that proves it correct
• Build dbt models with declared grain and tests for uniqueness, non-null keys, referential integrity and accepted values
• Build scheduled extracts that publish only after the full expected volume lands
• Reconcile every figure to a count the office already trusts before it is released
• Build Superset datasets over dbt models, never ad hoc SQL, then the dashboards and AI-assisted views on top
• Run acceptance testing with the office's own users: values reconcile, citations open, restricted roles see only what they should, and the interface works by keyboard
• Pair every chart with a data table, carry no meaning by color alone, verify contrast, and test the whole task with a screen reader
• Write the onboarding playbook, the user and administrator documentation, and run the enablement sessions
• Document every pipeline: source, schedule, dependencies, failure behavior and owner

Your first 90 days

How your work is judged

What you need

What sets a candidate apart

Benefits

• Pay is discussed with you directly when we speak. These are the benefits every full-time SPN employee receives.
• 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

Terms, and how to apply

• Full time, W-2, salaried (exempt), employed by SPN Solutions
• Target start: 19 October 2026
• Hybrid, based in Fairfax, Virginia, with some days in Washington, DC when needed; living in the Washington, DC area is preferred
• All customer work is done on a government-furnished laptop with a PIV credential
• You complete the DHS Trusted Tester training in month 2 or 3 if you do not hold it; the training is free
• If you come from Power BI, Tableau or Looker, the first two to four weeks include a Superset ramp with the Architect
• Apply through the link with your resume. A recruiter reads every application and answers within two business days. Tell us in two or three lines about one product you built that people who are not technical came to rely on, and how you knew the numbers were right.
• SPN Solutions is an Equal Opportunity Employer. All qualified applicants are considered without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.