INTEGRITYOne Partners→
SQL Developer at INTEGRITYOne Partners in Washington, DC
Skills
Job Description
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.
- 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.
- 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.