Data Engineer

Job Description

Role Summary/

Purpose:

The candidate for the Data Engineer role will join an Agile scrum team and perform functional & system development for Synchrony’s Enterprise Data Lake. As a Big Data Engineer, the ability to integrate data across internal and external sources, provide analytical insights, and integrate with our critical systems are key skills. The engineer will participate in data analysis efforts to ensure the delivery of high‑quality data ingestion, standardization and curation and maintain compliance with the applicable Data Sourcing, Data Quality, and Data Governance standards.

The engineer will drive quality through the entire software development lifecycle with focus on functional requirements, efficiency, and methodology. The engineer will work cross‑functionally with operations, other data engineers and product owner to assure capabilities are delivered that meet business needs.

• Develop big data applications for Synchrony in Hadoop ecosystem
• Participate in the agile development process including backlog grooming, coding, code reviews, testing and deployment
• Work with team members to achieve business results in a fast paced and quickly changing environment
• Pair with experienced data engineers to develop analytic applications leveraging technologies such as:
  Hadoop, No
  
  SQL, In‑memory Data Grids, Kafka, Spark, Ab Initio
• Provide data analysis for Synchrony’s data ingestion, standardization and curation efforts ensuring all data is understood from a business context
• Identify enablers and level of effort required to properly ingest and transform data for the data lake
• Profile data to assist with defining the data elements, propose business term mappings, and define data quality rules
• Work with the Data Office to ensure that data dictionaries for all ingested and created data sets are properly documented in data dictionary repository
• Ensure the lineage of all data assets are properly documented in the appropriate enterprise metadata repositories
• Assist with the creation and implementation of data quality rules
• Ensure the proper identification of sensitive data elements and critical data elements
• Create source‑to‑target data mapping documents
• Test current processes and identify deficiencies
• Investigate program quality to make improvements to achieve better data accuracy
• Understand functional and non‑functional requirement and prepare test data accordingly
• Plan, create and manage the test case and test script
• Identify process bottlenecks and suggest actions for improvement
• Execute test script and collect test results
• Present test cases, test results, reports and metrics as required by the Office of Agile
• Perform other duties as needed to ensure the success of the team and application and ensure the team’s compliance with the applicable Data Sourcing, Data Quality, and Data Governance standards

• Bachelor’s degree in a quantitative field (such as Engineering, Computer Science, Statistics, Econometrics); in lieu of degree, High School Diploma/GED and minimum 2 years of Information Technology experience.
• Hands‑on experience writing shell scripts, complex SQL queries, Hive, Kafka, HBase, MySQL, Hadoop commands and Git.
• Ability to write abstracted, reusable code components.
• Programming experience in at least one of the following languages:
  Scala, Java or Python.
• Analytical mindset.
• Scheduling tools like Stone branch, Auto Sys, control‑M etc.
• Familiarity with code repository like bitbucket, Git Hub and devops pipelines.
• Willingness and aptitude to learn new technologies quickly.
• Superior oral and written communication skills.
• Ability to collaborate across teams of internal and external technical staff, business analysts, software support and operations staff.

• Performance tuning experience
• Exposure to the following Ab Initio tools: GDE — Graphical Development Environment;
  Co>
  
  Operating System;
  Control Center;
  Metadata Hub;
  Enterprise Meta>
  
  Environment;
  Enterprise Meta>
  
  Environment Portal;
  Acquire>
  
  It;
  Express>
  
  It;
  Conduct>
  
  It;
  Data Quality Environment;
  Query>
  
  It.
• Familiar with Ab Intio, Hortonworks/Cloudera, Zookeeper, Oozie and Kafka
• Familiar…