Senior Data Engineer

About

The Senior Data Engineer will be essential in analyzing, mapping, building, testing, and maintaining data extraction, conversion, and migration from databases such as Oracle and DB2 to target databases including Data Warehouse and Data Lake on various cloud or on-premise database platforms. One of the primary focuses of this position is to lead data analysis, mapping, transformation, and extraction of data from Oracle and DB2 databases to migrate to the Salesforce platform for the Child Welfare program.

This role involves collaborating with various internal and vendor stakeholders to understand business requirements and translating them into efficient and scalable technical solutions for the Child Welfare program. The individual 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.

Company Culture and Environment

The work environment encourages collaboration and communication with internal teams and external stakeholders, fostering a culture of teamwork and innovation. The role requires both independent work and cooperative engagement, reflecting a balanced approach to problem-solving.

Career Growth and Development Opportunities

This position offers the potential for professional development through hands-on experience in data engineering and collaboration with a variety of stakeholders, enhancing skills in ETL processes and cloud technologies.

Detailed Benefits and Perks

The role promises a competitive W-2 rate of up to $85/hour, and while specific benefits are not detailed, the collaborative and innovative nature of the company implies a supportive workplace environment.

Compensation and Benefits

• W-2 rate up to $85/hour

Why you should apply for this position today

This is a unique opportunity to contribute to the Child Welfare program, making a meaningful impact on community welfare through data-driven solutions. The chance to work with diverse teams on critical data processes is an exciting prospect for any data engineer.

Skills

• 7+ years of experience as a Data Engineer
• Proficiency in ETL processes
• Strong problem-solving skills
• Knowledge of database systems like Oracle and DB2
• Experience with Salesforce platform migrations
• Ability to design and troubleshoot data pipelines

Responsibilities

• Analyze, map, and build data extraction processes
• Lead transformation and extraction of data from Oracle and DB2 to Salesforce
• Collaborate with stakeholders to understand and address business requirements
• Design and optimize data pipelines and ETL processes
• Support data archival, subsetting, and de-identification processes
• Monitor and troubleshoot data pipelines to ensure data quality and integrity

Qualifications

• Proven experience in data engineering roles
• Expertise in ETL development
• Strong understanding of data relationships and object-oriented design

Education Requirements

• Bachelor’s degree in Computer Science, Information Technology, or a related field

Experience Requirements

• A minimum of 7 years of experience as a Data Engineer using ETL processes

Why work in Raleigh, NC

Raleigh offers a vibrant community with a growing tech scene, rich educational institutions, and a high quality of life. The area boasts a blend of cultural experiences, outdoor activities, and friendly neighborhoods, making it an attractive place for professionals seeking both career opportunities and a balanced lifestyle.