Data Engineer

BCforward is currently seeking a highly motivated Data Engineer in Durham NC 27709

Position Title: Data Engineer
Location: Durham NC 27709
Shift Timing: Mon Friday 40.00 Hours Per Week
Anticipated start date: 13 Weeks
Duration: 12 Months contract and the possibility to be extended the contract.
Pay Rate: $47.00 - $47.62 on W2

Job Description:
The persons in this position 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. They will collaborate with cross-functional teams to understand data requirements and translate them into technical solutions. The data engineers will need excellent problem-solving skills and the ability to work independently as well as part of a team. The work involves developing and maintaining data models schemas and databases to support data conversion needs. The work also involves monitoring and troubleshooting data pipelines to ensure data quality completeness integrity and availability. This position will be implementing best practices for data governance security and compliance to ensure regulatory requirements are met.

Responsibilities and Duties:
- Analyze Map Build Test and Maintain database pipeline architectures using Oracle and DB2
- Collaborate with SMEs to understand and execute data conversion objectives that transforms masks and loads 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

Skill
Experience with Oracle
Experience with PL/SQL
Experience with SQL
Experience with data migrations from legacy systems
Experience with data cleansing
Experience with DB2
Experience with ETL processes involving Salesforce
Experience with Talend
Experience with GIT
Experience with Jira
Experience with Java
Experience with Python
Experience with cloud platforms (e.g. AWS and Azure) and associated services for data processing and storage
Experience with Azure Synapse
Experience with Azure Databricks
Experience with Cloud Computing
Experience with Power BI

Interested candidates please send resume in Word format Please reference job code 222936 when responding to this ad.