CDIS Data Engineer

This role is office centric, four days a week in the office (Atlanta is preferred). The CDIS (Cyber Data Integration Solutions) team delivers cybersecurity metrics by partnering with various security teams across the bank and for the benefit of various audiences (from operational, to GRC, audit, and organizational leadership). To support these efforts, CDIS Data Engineers are tasked with building, optimizing, and maintaining the data pipelines and aiding in building the data ecosystem for delivering enterprise data for wide consumption including developing data models, corresponding data architecture documents and APIs. They help transform and enrich raw data from a wide variety of source systems before developing, deploying, and maintaining metric logic, in partnership with business stakeholders and other CDIS teams and throughout each metric's lifecycle. Data Engineers are also tasked with supporting general maintenance of the application production environment with the goal of ensuring confidentiality, integrity and availability of the metrics at all times.

Essential Duties And Responsibilities

Following is a summary of the essential functions for this job. Other duties may be performed, both major and minor, which are not mentioned below. Specific activities may change from time to time.

• Builds, manages, and implements the data and/or Big Data pipeline capabilities including data modeling, process design and overall data pipeline architecture and all phases of the ETL (extract, transform, and load) processes.
• Drives efforts related to partially to completely automate repeatable data preparation and integration tasks. Partner with technology teams to understand data capture, testing needs, and to build and test end-to-end solutions.
• Analyzes information to determine business needs from requests and implement effective technical solutions by providing problem analysis and resolution in a timely manner and explain and interpret complex, difficult, or sensitive information.
• Takes a new perspective on existing solutions to solve problems of moderate to high complexity and exercise judgment based on the analysis (e.g. modeling, testing, etc.) of multiple sources of information.
• Lead small data engineering projects with manageable risks and resource requirements; plays significant roles in larger, more complex initiatives.

Required Qualifications

The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Bachelor's degree and five years of experience in systems engineering or administration or equivalent education and related training or experience
• In-depth knowledge of SQL, relational databases, ETL/ELT architecture and concepts, data integration concepts and big data concepts
• Previous experience in planning and managing IT projects

Preferred Qualifications

• Master's degree or prior experience developing data solutions
• Solid understanding and experience with CI/CD framework, agile methodology, and SSDLC
• Knowledge of SQL, relational databases, ETL/ELT architecture and concepts, data integration concepts, and dashboard/report tools
• Previous experience in supporting and developing IT projects.
• Knowledge of data technologies (ETL, Data warehouse, Databases, SAS and other Analytics tools)
• Analytical and critical thinking capabilities and ability to multi-task and work well under pressure
• Good verbal, written, and interpersonal communication skills.
• Banking, Financial Services, and/or Cyber Security experience.

Other Job Requirements / Working Conditions

Sitting Constantly (more than 50% of the time) Visual / Audio / Speaking Able to access and interpret client information received from the computer and able to hear and speak with individuals in person and on the phone. Manual Dexterity / Keyboarding Able to work standard office equipment, including PC keyboard and mouse, copy/fax machines, and printers. Availability Able to work all hours scheduled, including overtime as directed by manager/supervisor and required by business need. Travel Minimal and up to 10%