SQL Developer

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

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 hold ourselves and our team members to high standards—and when our people meet those standards, the personal and professional rewards are meaningful. We are committed to helping our employees grow their careers by providing opportunities to build valuable Federal knowledge and experience, develop in-demand skills, strengthen their professional capabilities, and access targeted education and training.

INTEGRITYOne Partners is an equal opportunity employer. It is our policy to provide equal opportunity to each individual without regard to race, color, religion, gender, national origin, age, disability, veteran status, marital status, family responsibility, pregnancy, political affiliation or any other status protected by applicable law. This policy applies to all aspects of employment including, but not limited to, recruitment, hiring, training, compensation, benefits, promotion or termination. These decisions will be based on merit, qualifications and abilities.