Data Engineer

Agama Solutions • Chicago, IL

2d

About The Position

The Data Engineer will be responsible for a variety of activities including strong SQL and data warehouse concepts, providing data requirements, validating data accuracy, supporting defect triage, and guiding the production support team. This role requires hands-on experience in a data warehouse environment, the ability to write complex SQL queries for analysis and pattern identification, and the skill to recommend solutions based on data analysis. The candidate will collaborate with Subject Matter Experts and Business Partners to gather data requirements, demonstrate a strong understanding of existing data models and ETL processes, and provide data flow diagrams, table structures, and ETL specifications. Additionally, the role involves identifying ETL dependencies, orchestrating data loads, and communicating effectively with developers and architects to solve data needs. The Data Engineer will also be involved in validating data accuracy, integrity, and quality, participating in defect triage for SIT and UAT, assessing defect impacts, and setting priorities. Finally, the position requires guiding the production support team on unforeseen issues and ETL abends.

Requirements

• Strong in SQL and Data warehouse concepts
• Hands on experience working in a datawarehouse environment
• Demonstrate strong analytical and problem solving skills
• Ability to quickly identify design related concerns
• Experience providing data flow diagram, table structure and ETL specifications including transformation rules required for source to target mapping
• Good communication and presentation skills with the ability to articulate data requirements, design concerns, etc.
• Strong negotiation skills while working with developers, architects to solution the data needs.

Responsibilities

• Write complex SQLs to analyze/profile datasets and identify patterns
• Recommend solutions based on data analysis
• Collaborate with Subject Matter experts and Business partners in gathering data requirements
• Work independently and demonstrate strong understanding of existing Datamodel and ETL processes
• Provide data flow diagram, table structure and ETL specifications including transformation rules required for source to target mapping
• Identify ETL dependencies and help orchestrate a sequence of data loads in the ETL pipeline
• Validate the accuracy, integrity and quality of Data developed
• Participate in the SIT, UAT defects triage and help set up a defect resolution path
• Assess defects on their impacts and help set up priorities
• Guide the production support team on unforeseen issues, ETL abends

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed