Data Engineer

The Data Engineer will work with other data engineers and business intelligence team to develop, enhance, and support enterprise-level data ingestion and data pipeline using ETL tools. The successful candidate will work as part of a team of highly skilled professionals. The candidate will be responsible for developing and supporting complex ETL workflows and healthcare/financial datasets as well as creating technical design documents that capture source to target mapping, data transformation, and data quality rules.

What will you do?

• Understand requirements, build, test, and support high-quality ETL or ELT data pipelines using Talend/python/Java/SQL and/or SAP DI.
• Understand the project scope, identify activities and task-level estimates, schedule dependencies, risk, and provide inputs to the project lead for review.
• Analyze functional/nonfunctional requirements and seek clarifications for better understanding of requirements.
• Combine/Integrate data from various sources, cleanse, standardize and load into OLTP, OLAP, and data warehouse targets (on-premise and cloud).
• Identify and remediate problems in production pipelines and integration jobs.
• Prepare the LLD/ detailed design documents based on HLD.
• Partner with reporting, analytics, and machine learning teams on requirements, testing, and troubleshooting.
• Mentor junior team members and perform code reviews plus quality control.

What education and experience do you need?

• BA/BS in Computer Science, Engineering, or another technical field required.
• 1-3 years of professional experience as ETL/ELT developer.
• Strong SQL skills and ability to write python code and shell scripting.
• Experience coordinating with Change Management and Incident Management teams for production issues.
• Ability to triage issues and take resolution steps immediately.
• Ability to create good written documentation of detailed technical processes.
• Experience with any of the following a plus: Talend, SAP DI, AWS S2 and Redshift, Oracle PL/SQL.