Senior SQL Engineer – Federal Data & Analytics

INTEGRITYOne Partners; Washington; On-site; USD 130,000 - 140,000; Full time

Job summary

INTEGRITYOne Partners in the Washington, DC area seeks a Data Engineer / SQL Developer to design, build and troubleshoot data extracts, transform data into reliable datasets, and support monthly, quarterly and annual processes for federal programs.

Required: 5–8+ years in data engineering, a Bachelor’s in CS or related field, advanced SQL, ETL, data validation, and experience with Power BI or Tableau. On-site work and US citizenship required; salary range 130,000–140,000 USD.

Qualifications

• 5–8+ years in data engineering, database development, SQL development or related technical roles.
• Bachelor’s degree required in computer science, information systems, data analytics, engineering or related discipline.
• Advanced SQL development.
• Data extraction, transformation and reporting.
• Relational databases and data structures.
• Building and maintaining repeatable data extracts.
• Data validation and reconciliation.
• Data integration and troubleshooting.
• Advanced Excel.
• Working knowledge of Power BI/Tableau or comparable visualization platforms.
• Ability to document technical processes, data definitions and data flows.

Responsibilities

• Design, build, maintain and troubleshoot data extracts and SQL queries supporting CMM, CBM and program reporting.
• Transform source data into reliable datasets for financial and operational analysis.
• Support automation of recurring monthly, quarterly and annual processes.
• Perform data validation and reconciliation and assist analysts with identifying anomalies and data-quality issues.
• Support interfaces between CSP systems/tools and analytics/reporting capabilities.

Skills

Data engineering

SQL development

Relational databases

Data validation

Data integration

Advanced Excel

Power BI/Tableau

Documentation

Education

Bachelor’s degree in computer science or related field

Tools

Power BI

Tableau

Python

Job description

INTEGRITYOne Partners in the Washington, DC area seeks a Data Engineer / SQL Developer to design, build and troubleshoot data extracts, transform data into reliable datasets, and support monthly, quarterly and annual processes for federal programs.

Required: 5–8+ years in data engineering, a Bachelor’s in CS or related field, advanced SQL, ETL, data validation, and experience with Power BI or Tableau. On-site work and US citizenship required; salary range 130,000–140,000 USD.