The Role
Designs, builds, maintains, and troubleshoots SQL queries and data extracts for financial and operational reporting. Transforms source data into reliable datasets, automates recurring processes, validates and reconciles data, identifies quality issues, and supports integrations between systems and analytics platforms. The role also documents data flows and technical processes while supporting federal law enforcement clients.
Summary Generated by Built In
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
Required Skills
Preferred certifications: Microsoft Azure/Data certifications, SQL/database certifications, Power BI or equivalent.
Salary Range 130,000-140,000
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
Skills Required
- 5-8+ years of experience in data engineering, database development, SQL development, or related technical roles
- Bachelor's degree in computer science, information systems, data analytics, engineering, or a related discipline
- Advanced SQL development
- Data extraction, transformation, and reporting experience
- Experience with relational databases and data structures
- Experience building and maintaining repeatable data extracts
- Data validation and reconciliation experience
- Data integration and troubleshooting experience
- Advanced Excel skills
- Working knowledge of Power BI, Tableau, or comparable visualization platforms
- Ability to document technical processes, data definitions, and data flows
- Federal financial data experience
- Financial data modeling experience
- Microsoft or Azure environment experience
- Python experience
- Data pipeline automation experience
- SharePoint integration experience
- Government cloud environment experience
- FileOnQ experience
- CMM or similar financial or cost-management application experience
- Microsoft Azure or data certification
- SQL or database certification
- Power BI or equivalent certification
- Local presence in the Washington, DC metropolitan area and ability to work onsite as needed
- U.S. citizenship
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
INTEGRITYOne Partners is a business and technology services company delivering mission-critical results to leaders working on our nation’s top priorities. We assist organizations within the Federal Government with addressing current and future challenges by creating and sustaining an appropriate business strategy, managing process transformation, implementing organizational change, facilitating information sharing, and effectively architecting and deploying technology solutions.
