Data Engineer (HYBRID)

Serigor - Durham, NC

Full-time - Mid Level

Durham, NC

Professional, Scientific, and Technical Services

About the position

The Data Engineer position is a contract role focused on analyzing, mapping, building, testing, and maintaining database pipeline architectures for Child Welfare Data Conversion efforts. The role involves collaborating with stakeholders to translate business requirements into scalable technical solutions, particularly as the legacy system migrates to Salesforce. Data Engineers will design, implement, and optimize data pipelines and ETL processes to support data extraction, transformation, and loading from various sources into Salesforce, ensuring data quality and compliance with governance and security policies.

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.

Requirements

• 5 years of experience with Oracle.
• 5 years of experience with PL/SQL.
• 7 years of experience with SQL.
• 5 years of experience with data migrations from legacy systems.
• 1 year of experience with data cleansing.

Nice-to-haves

• 1 year of experience with DB2.
• 1 year of experience with ETL processes involving Salesforce.
• 1 year of experience with Talend.
• 1 year of experience with GIT.
• 1 year of experience with Jira.
• 5 years of experience with Java.
• 3 years of experience with Python.
• 1 year of experience with cloud platforms (e.g. AWS and Azure) and associated services for data processing and storage.
• 2 years of experience with Azure Synapse.
• 1 year of experience with Azure Databricks.
• 1 year of experience with Cloud Computing.
• 1 year of experience with Power BI.