SQL Developer

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

Data Engineer / SQL Developer

At INTEGRITYOne Partners, we are a federal technology company focused on DevSecOps and agile software development, analytics and AI, cloud engineering, and data management. Our people are known for being technical Swiss army knives that are depended on by our clients to support a myriad of highly complex, technical problems within rapidly changing missions. We enable federal law enforcement clients to execute high-tempo, mission-critical work that ultimately improves the lives of the people they serve. Our culture is entrepreneurial, mission-first, and meritocratic, giving you direct access to decision-makers and real influence over how we win and deliver.

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

Required Skills

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

Preferred Skills

• Federal financial data.
• Financial data modeling.
• Microsoft/Azure environments.
• Python.
• Data pipeline automation.
• SharePoint integration.
• Government cloud environments.
• FileOnQ.
• CMM or similar financial/cost-management applications.

Location & Work Requirements

• Candidates must be local to the Washington, DC metropolitan area and prepared to work onsite as needed based on business requirements.
• U.S. citizenship is required for this position.
• This position is contingent upon contract award.

Preferred certifications:

Microsoft Azure/Data certifications, SQL/database certifications, Power BI or equivalent.

Salary Range

130,000-140,000

At INTEGRITYOne Partners, we have high standards for the members of our team –– and when our people meet these standards, the personal and professional rewards are plentiful. We help INTEGRITYOne Partners’ employees grow in their careers by gaining enhanced Federal knowledge and experience, sought-after skills, greater discipline and drive, and targeted education and training

INTEGRITYOne Partners is an equal opportunity employer Minorities / Females / Veterans / Disabilities. All qualified applicants will be considered without regard to race, ethnicity, color, national origin, religion, sexual orientation, gender identity, veteran status, or status as a qualified individual with a disability or any other personal characteristic protected by law.