Data Engineer 1

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

Benefits offered by this job

Health Insurance

Dental Insurance

Vision Insurance

STD & LTD

Life Insurance

401k Company Match

Voluntary Products

Job summary

Knowesis, Inc. is seeking an experienced Data Engineer I to support the Pandemic Response Accountability Committee (PRAC) by designing, building, and maintaining scalable ETL pipelines that enable advanced analytics, investigative intelligence, and fraud detection across federal programs.

The role is remote with occasional site visits and requires a Public Trust (HSPD-12) clearance. The position offers a salary range of $115,000 – $155,000 per year, with a contingent status upon contract award

Qualifications

• Minimum of three (3) years of professional experience in data engineering or closely related field.
• Experience designing, building, and maintaining scalable ETL pipelines across diverse data sources.
• Strong SQL and Python skills with experience ingesting/transferring data from flat files, JSON, XML, Excel, APIs, and graph databases.
• Experience with Databricks Unity Catalog and SQL Server managed instances including streaming and batch ingestion.
• Experience implementing data quality control processes to ensure data quality, lineage, reliability, and performance.
• Experience with data governance, data quality, and data management practices consistent with 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 data ingestion workflows supporting fraud analytics and investigative use cases.
• Implement data quality control processes, ensuring accuracy, lineage, reliability, and performance across all analytic datasets.
• Prepare analytic-ready datasets for machine learning, graph analytics, and fraud detection models.
• Collaborate with OIG and law enforcement partners to support data needs for investigative leads and case work.
• Evaluate emerging data engineering tools and Lakehouse technologies; provide recommendations for PRAC.

Skills

ETL design

SQL proficiency

Python proficiency

Data governance

Fraud analytics familiarity

Education

Bachelor's degree in Computer Science or related

Master's degree in Data Engineering/Data Science

Tools

Databricks Unity Catalog

SQL Server Managed Instances

Azure Databricks

AWS Glue

Job description

Brief Description

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.

Position: Data Engineer I

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

Work Environment: Remote

Clearance Required: Public Trust (HSPD-12)

Status: Contingent Upon Contract Award

Salary Range: $115,000 – $155,000 per year

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.

Benefits

• 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.