Data Engineer I

Knowesis Inc.; Washington (District of Columbia); Remote; USD 159,000 - 180,000; Full time

Benefits offered by this job

Health insurance

401k matching

Dental and Vision

Job summary

Knowesis, Inc. is seeking an experienced Data Engineer to support the Pandemic Response Accountability Committee (PRAC) by designing, building, and maintaining scalable data pipelines for analytics, fraud detection, and investigative work across federal programs.

You will develop and optimize ETL processes and lakehouse environments using Azure Databricks, SQL Server, Power BI, and graph databases, collaborating with data scientists, investigators, and OIG partners in a fast-paced oversight

Qualifications

• Minimum of three years of professional data engineering experience.
• Strong proficiency in SQL and Python, with experience in ingesting and transforming data from diverse sources.
• Experience with Databricks Unity Catalog and SQL Server managed instances.
• Familiarity with data governance, data quality, and EDM standards.
• Experience supporting fraud detection, anomaly detection, or financial analytics environments.

Responsibilities

• Design, build, and maintain scalable ETL pipelines to ingest, transform, and prepare data from diverse sources.
• Develop and optimize data ingestion workflows supporting fraud analytics and investigative use cases.
• Implement data quality control processes ensuring accuracy, lineage, and performance.
• Prepare analytic-ready datasets for machine learning, graph analytics, and fraud detection models.
• Collaborate with investigators and data scientists to deliver analytics-ready datasets.

Skills

SQL

Python

ETL pipelines

Data governance

Data quality

Fraud analytics

Cloud platforms

Education

Bachelor’s degree

Master’s degree (preferred)

Tools

Databricks Unity Catalog

SQL Server

Azure Databricks

neo4j

Power BI

Job description

Location: Remote, with occasional site visits to PRAC locations as required

Work Environment: Remote Clearance Required: Public Trust (HSPD-12)

Salary Range: $159,300 – $180,300 per year

Knowesis , Inc. is seeking an experienced Data Engineer to support the Pandemic Response Accountability Committee (PRAC) by designing, building, and maintaining scalable data pipelines that enable advanced analytics, investigative intelligence, and fraud detection across federal programs. The PRAC delivers data - driven oversight of pandemic relief and OBBBA Act funds and works closely with federal Offices of Inspectors General (OIGs) and federal law enforcement to ensure covered funds are used appropriately and not subject to fraud, waste, or abuse.

The Data Engineer will play a critical role within the PRAC Analytics Center, developing and optimizing ETL pipelines, ingestion frameworks, and Lakehouse - based data environments that support machine learning, graph analytics, anomaly detection, and investigative case development. This position ensures high - quality, reliable, and well - governed data flows into PRAC ’ s cloud - based analytic platform, which leverages Azure Databricks, Microsoft SQL Server, Microsoft Power BI, neo4j, and other advanced technologies.

Working within agile sprints and Integrated Project Teams (IPTs), the Data Engineer will collaborate with data scientists, investigators, and PRAC stakeholders to deliver analytic - ready datasets, integrate new data sources, and uphold enterprise data management (EDM) standards. The role requires strong technical expertise , attention to detail, and the ability to support both analytic and investigative missions in a fast - paced oversight environment.

The Job Duties and Responsibilities include but are not limited to the following:

• Design, build, and maintain scalable ETL pipelines to ingest, transform, and prepare structured and unstructured data from diverse sources (flat files, JSON, XML, Excel, APIs, graph databases).


• Develop and optimize data ingestion workflows supporting fraud analytics, anomaly detection, and investigative use cases.


• Implement robust data quality control processes, ensuring accuracy, completeness, lineage, reliability, and performance across all analytic datasets.


• Support data scientists and analysts by preparing analytic-ready datasets for machine learning, graph analytics, and fraud detection models.


• Maintain and enhance data pipelines and transformation logic to ensure continuity of service and no degradation in analytic output quality.


• Prepare and deliver high-quality datasets used for investigative analysis, link analysis, and case development.


• Support investigative teams by rapidly ingesting new data sources and preparing structured datasets for fraud pattern identification.


• Ensure data used in investigative products meets PRAC standards for reliability, traceability, and evidentiary integrity.


• Collaborate with OIG and law enforcement partners to support data needs for investigative leads, referral packages, and case summaries.


• Evaluate emerging data engineering tools, ingestion frameworks, and Lakehouse technologies; provide recommendations aligned with PRAC mission needs.


• Collaborate with PRAC’s OCIO, OCISO, and OCDO to configure and optimize data environments, including Databricks Unity Catalog and SQL Server managed instances.


• Support ingestion and integration of new data sources, including schema design, transformation logic, and quality control.


• Assist PRAC in analyzing new data engineering technologies and providing documentation to support Government procurement decisions.


• Maintain awareness of evolving fraud schemes and data engineering best practices to enhance PRAC’s analytic capabilities.

Required Qualifications:

• Minimum of three (3) years of professional experience in data engineering or a closely related field.


• Demonstrated ability to design, build, and maintain scalable ETL pipelines across diverse data sources.


• Strong proficiency in SQL and Python, or equivalent technologies, with experience ingesting and transforming data from flat files, JSON, XML, Excel, APIs, and graph databases.


• Experience loading, managing, and optimizing data within platforms such as Databricks Unity Catalog and SQL Server managed instances, including work with streaming and batch ingestion frameworks and modern Lakehouse architecture.


• Proven capability implementing data quality control processes to ensure data quality, lineage, reliability, and performance.


• Familiarity with data governance, data quality, and data management practices consistent with enterprise data management (EDM) standards.


• Experience supporting fraud detection, anomaly detection, or financial analytics environments.

Preferred Qualifications:

• Experience supporting analytic environments within federal oversight, OIG, or law enforcement contexts.


• Experience integrating multi-agency or multiprogram datasets into scalable pipelines.


• Experience with cloud-based analytic platforms (Azure Databricks, AWS Glue, etc.).


• Experience collaborating with data scientists, investigators, and analysts in cross-functional teams .

Required Education: Bachelor’s degree (BA/BS) in Computer Science, Data Engineering, Information Systems, or a related technical field.

Preferred Education: Master’s degree (MS/MA) in Data Engineering, Data Science, Information Systems, or a related discipline.

• Health (PPO & HDHP) Insurance, Dental, Vision, STD & LTD, Basic Life Insurance, 401k Company Match, & Voluntary Products.

Knowesis is committed to providing equal employment opportunities to all individuals based on merit and qualifications. We prohibit discrimination in all aspects of employment as required by Title VII of the Civil Rights Act and other applicable federal laws. Our company values all applicants and employees and fosters a work environment where everyone is treated with respect and dignity.