Senior SQL & Data Engineer — Federal Analytics

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

Benefits offered by this job

Azure certifications

SQL certifications

Power BI certification

Job summary

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

Ideal candidates have 5–8+ years in data engineering, a CS-related bachelor's degree, advanced SQL, ETL, and experience with Power BI or Tableau. Local onsite work is required; U.S. citizenship is mandatory; position contingent on contract award.

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 validation

Power BI

Advanced Excel

Education

Bachelor's degree

Tools

Microsoft Azure

Python

SharePoint

Job description

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

Ideal candidates have 5–8+ years in data engineering, a CS-related bachelor's degree, advanced SQL, ETL, and experience with Power BI or Tableau. Local onsite work is required; U.S. citizenship is mandatory; position contingent on contract award.