Data Engineer

Cynet Systems - Durham, NC

Full-time

Durham, NC

Professional, Scientific, and Technical Services

About the position

The Data Engineer position is focused on analyzing, mapping, building, testing, and maintaining database pipeline architectures using Oracle and DB2 for Child Welfare Data Conversion efforts. This role involves collaborating with various stakeholders to understand business requirements and translating them into efficient and scalable technical solutions, particularly as the legacy system migrates to Salesforce. The Data Engineer will play a crucial role in designing, implementing, and optimizing data pipelines and ETL processes to support the extraction, transformation, and loading of data from various Child Welfare sources into Salesforce.

Responsibilities

• Analyze, map, build, test, and maintain database pipeline architectures using Oracle and DB2.
• Collaborate with SMEs to understand and execute data conversion objectives that transform, mask, and load data into Salesforce objects.
• Create and maintain table schemas.
• Create new data validation methods to ensure data accuracy, completeness, and cleanliness.
• Ensure compliance with data governance and security policies.
• Develop and maintain data models, schemas, and databases to support data conversion needs.
• Monitor and troubleshoot data pipelines to ensure data quality, completeness, integrity, and availability.

Requirements

• Experience with Oracle and DB2 database systems.
• Strong understanding of ETL processes and data pipeline architecture.
• Ability to collaborate with cross-functional teams and stakeholders.
• Excellent problem-solving skills and ability to work independently as well as part of a team.
• Knowledge of data governance and security policies.