Senior Data Engineer: Advanced SQL & Federal Data (Onsite)

Integrityone Partners; Washington (District of Columbia); On-site; USD 130,000 - 140,000; Full time

Job summary

INTEGRITYOne Partners is seeking a Data Engineer / SQL Developer in the Washington, DC area to design, build, and optimize data pipelines, SQL queries, and data extracts that power financial and operational reporting.

You will transform source data into reliable datasets, validate data quality, automate recurring processes, and document data flows. The role requires on-site work for contract-driven projects and US citizenship.

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

Data extraction

Data transformation

Data validation

Data reconciliation

Data integration

Advanced Excel

Power BI

Tableau

Documentation of data flows

Education

Bachelor's degree in computer science, information systems, data analytics, engineering or related discipline

Tools

Power BI

Tableau

Job description

INTEGRITYOne Partners is seeking a Data Engineer / SQL Developer in the Washington, DC area to design, build, and optimize data pipelines, SQL queries, and data extracts that power financial and operational reporting.

You will transform source data into reliable datasets, validate data quality, automate recurring processes, and document data flows. The role requires on-site work for contract-driven projects and US citizenship.