Truist BI Engineer w/ Cybersecurity Org Heavy SQL 

United States, Georgia, Atlanta 

68078614

Regular or Temporary:

English (Required)

1st shift (United States of America)***Office Centric (4 days a week in office) Atlanta or Charlotte only and Open to Relocation******This role is not approved for H1B visa sponsorship***Assists for designing, building, optimizing, and maintaining the data pipelines to support organizational data driven solutions and reporting.Monitors daily production application performance including providing break-fix operation support and reporting issues and resolutions to leaders and management.Participates in the building and implementation of data pipeline capabilities, including data modeling, process design and architecture, dashboard/report development and all phases of the ETL (extract, transform, and load) processes.Assists in efforts related to automating repeatable data preparation and integration tasks.Develops technical solutions by providing problem analysis and resolution in a timely manner with the ability to explain and interpret moderately difficult or sensitive information.Takes a new perspective on existing solutions to solve problems of low to moderate complexity and exercise judgment based on the analysis (e.g. modeling, testing, etc.) of multiple sources of information with some guidance from more experienced data engineers.Prepares documentation and communicates data processes and production issues including observations, diagnoses, and action steps.Generates regular reports summarizing production performance, release notes, and troubleshooting steps.

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.

• Participates in the building, management, and implementation 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.

• Assists in 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.

• Participates in the analysis of 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 low to moderate complexity and exercise judgment based on the analysis (e.g. modeling, testing, etc.) of multiple sources of information with some guidance from more experienced data engineers.

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 two years of experience in systems engineering or administration or equivalent education and related training or experience.

• Basic 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:

• Bachelor’s degree or 4+ years of experience in systems engineering or administration or an equivalent combination of education and work experience.

• 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.

• Master’s degree or prior experience developing data solutions.

• Banking, Financial Services, and/or Cyber Security experience.