SQL Developer

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

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.