Data Layer Engineer

Prescient Edge; Town of Florida (NY); On-site; USD 85,000 - 120,000; Full time

Benefits offered by this job

Competitive salary

Comprehensive healthcare benefits

Retirement plan with no vesting schedule

Career development opportunities

Job summary

Prescient Edge is seeking a Data Layer Engineer to support a Federal Government client. This role involves designing a modular data layer architecture, optimizing ETL pipelines, and implementing metadata management solutions.

Ideal candidates will have a Bachelor’s degree in Data Management or Computer Science, with proficiency in ETL processes and cloud storage solutions like AWS S3. The position requires a TS/SCI security clearance and offers competitive salary and benefits.

Qualifications

• Proficient in designing and optimizing data transformation workflows.
• Strong background in databases and cloud storage solutions.
• Experience in developing data governance frameworks.

Responsibilities

• Design and manage a modular data layer architecture.
• Develop and optimize ETL pipelines for mission-relevant data.
• Implement metadata management solutions for governance alignment.

Skills

ETL processes

Data structuring

Schema management

Kubernetes

PostgreSQL/PostGIS

AWS S3

Cloud storage solutions

Education

Bachelor’s degree in Data Management or related field

Certifications in Data Management (optional)

Tools

Databricks Unity Catalog

Collibra

AWS Glue

Azure Purview

Job description

Prescient Edge is seeking aData Layer Engineer to support a Federal Government client.

Please note that the availability of this position is contingent upon contract award.

At Prescient Edge, we believe that acting with integrity and serving our employees is the key to everyone's success. To that end, we provide employees with a best-in-class benefits package that includes:

• A competitive salary with performance bonus opportunities.
• Comprehensive healthcare benefits, including medical, vision, dental, and orthodontia coverage.
• A substantial retirement plan with no vesting schedule.
• Career development opportunities, including on-the-job training, tuition reimbursement, and networking.
• A positive work environment where employees are respected, supported, and engaged.

Description

• Design and manage a modular data layer architecture that supports scalable ingestion, transformation, and serving of geospatial and structured data across containerized environments.
• Develop and optimize ETL pipelines for real-time and batch processing of mission-relevant data, ensuring integration with both ESRI and third-party analytic services.
• Implement metadata management solutions—such as tagging, schema validation, and indexing—to improve lineage tracking and facilitate governance alignment with IL4/IL5 controls.
• Manage data access enforcement mechanisms, including RBAC policies and encryption controls, consistent with NIST 800-53 Rev. 5, FedRAMP, and DoD cybersecurity mandates.
• Shall submit the Data Layer Integration & Optimization Report, detailing Kubernetes performance benchmarks related to data lake interaction, data lifecycle strategies for containerized environments, and cloud resource optimization recommendations.

Job Requirements

Experience

• Knowledge and capability to design, implement, and optimize data transformation workflows for geospatial and non-geospatial datasets. Personnel must be proficient in ETL (Extract, Transform, Load) processes, data structuring, and schema management, with expertise in ESRI geospatial data layers, ArcGIS Enterprise, and cloud-based geospatial services.
• Strong understanding of databases (PostgreSQL/PostGIS, SQL Server, NoSQL), cloud storage solutions (AWS S3, Azure Blob, Google Cloud Storage), and Kubernetes-hosted geospatial applications is required.
• Demonstrated experience in developing and managing data governance frameworks, implementing metadata and data cataloging solutions, and ensuring compliance with DoD and IC data security policies.
• Experience with tools such as Databricks Unity Catalog, Collibra, Alation, AWS Glue, or Azure Purview is required.

Education

• Bachelor’s degree in Data Management, Information Science, Computer Science, or a related field, or five (5) years of equivalent experience in data governance.
• Desirable but not required certifications include Certified Data Management Professional (CDMP), DAMA Certified Data Governance Professional (DGSP), or Microsoft Certified: Azure Data Engineer Associate.

Security clearance

• TS/SCI.

Prescient Edge is an Equal Opportunity Employer (EEO). All applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other characteristic that is protected by law.