Data Engineer

Location

Remote from US

Type

Contract

Duration

3 months, contract-to-hire

Start Date

Nov 2024

Skills

Oracle, PL/SQL, ETL, EDW, Microsoft ADF, understanding of ERP business processes - Oracle EBS preferred

Reference #

Job-11612

Job Description

*Start Date: November 2024
*Duration: 3 months+ contract with option to hire
*Location: Remote from United States
• Anticipated Compensation starting at $60/hr W2 plus benefits. The offered compensation to a successful candidate will be dependent on several factors that may include (but are not limited to) the type and length of experience within the industry, education, etc.

We are seeking a Senior Data Engineer to join a forward-thinking team. You will play a crucial part in designing, developing, and providing operational support for cutting-edge data integration and ETL projects. You will showcase your expertise by guiding and mentoring other data engineers, while also working closely with functional analysts, end-users, and other BI team members to deliver effective and efficient ETL solutions and data integration pipelines.

Key Responsibilities:
*Lead the technical design, development, testing, and documentation of Data Warehouse and ETL projects
*Perform data profiling, logical/physical data modeling to build new ETL designs and solutions
*Develop, implement, and deploy ETL solutions to update data warehouses and data marts
*Maintain quality control, document technical specifications, and conduct unit testing to ensure data accuracy and quality
*Implement, stabilize, and establish DevOps processes for version control and deployment across environments
*Troubleshoot, debug, and diagnose ETL issues, providing production support and off-hours operational support as needed
*Perform performance tuning and enhancement of SQL and ETL processes, preparing related technical documentation
*Collaborate with offshore teams to coordinate development work and operational support
*Stay up-to-date with the latest ETL technologies and plan effective utilization
*Play a key role in planning the migration of our EDW system to a modern global data warehouse architecture
*Assess and implement new EDW/Cloud technologies to evolve the EDW architecture for efficiency and performance
*Communicate clearly and professionally with users, peers, and all levels of management, both in written and verbal forms
*Lead ETL tasks and activities related to BI projects, assigning, coordinating, and following up on activities to meet project timelines
*Contribute to AI/ML projects as assigned
*Perform code reviews on ETL and report changes where appropriate
*Coordinate with the DBA team on migration, configuration, and tuning of ETL codes
*Act as a mentor for other data engineers in the BI Team
*Adhere to established processes and work policies defined by management

Qualifications and Experience:
*Bachelor’s degree in Computer Science, MIS, Data Science, or a related field with 8+ years of relevant experience; or a Master’s degree with 6 years of experience
*Understanding of ERP business processes (Order to Cash, Procure to Pay, Record to Report, etc.), data warehouse and BI concepts, and the ability to apply educational and practical experience to improve business intelligence applications and provide simplified and standardized solutions to achieve business objectives
*Expert knowledge of data warehouse architecture, including modern data warehouse concepts, EDW, and Data Lake/Cloud architecture
*Expertise in dimensional modeling, star schema designs, including best practices for indexing, partitioning, and data loading
*Advanced experience in SQL, writing stored procedures, and SQL tuning, using Oracle PL/SQL
*Strong experience with Data Integration tools using Azure Data Factory (ADF)
*Well-versed in database administration tasks and working with DBAs to monitor and resolve SQL/ETL issues and performance tuning
*Experience with DevOps processes in ADF, preferably using GitHub (experience with other version control tools is helpful)
*Experience in troubleshooting data warehouse refresh issues and BI reports data validation with source systems

Soft skills:
*Excellent communication skills
*Ability to organize and handle multiple tasks simultaneously
*Ability to mentor and coordinate activities for other data engineers as needed

Preferred Qualifications
*Experience working with Oracle EBS or other major ERP systems like SAP
*Experience with AI/ML – proficiency in R, Python, PySpark is a plus
*Experience with Cloud EDW technologies like Databricks, Snowflake, Synapse
*Experience with Microsoft Fabric, Data Lakehouse concepts, and related reporting capabilities

Join our team and be part of an innovative environment where your expertise and contributions will be valued and appreciated. #LI-JT1 #LI-DNI #LI-Remote

For more information, please email: Job-11612@thecarreraagency.com