Senior Data Engineer - Snowflake SME

Language Fluency: English (Required)

Work Shift:

1st shift (United States of America)

Job Grade:

112

Please review the following job description:

- Responsible for 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 API’s.
• Responsible for 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 API’s.
• Build, manage, and implement 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.
• Lead 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.
• Partner with engineers, data scientists, and the data office leadership to define and refine data architecture and technology choices.
• Take a new perspective on existing solutions to solve problems of the highest complexity and exercise judgment based on the analysis (e.g. modeling, testing, etc.) of multiple sources of information and make recommendations.
• Lead larger, more complex data engineering projects and initiatives with significant risks and resource requirements.

***This is a hybrid position requiring 4 days/wk in office. Winston-Salem strongly preferred.***

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. 

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

2. Leads 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.

3. Partners with engineers, data scientists, and the data office leadership to define and refine data architecture and technology choices.

4. Takes a new perspective on existing solutions to solve problems of the highest complexity and exercise judgment based on the analysis (e.g. modeling, testing, etc.) of multiple sources of information and make recommendations.

5. Leads larger, more complex data engineering projects and initiatives with significant risks and resource requirements.

QUALIFICATIONS

Required Qualifications:

• Must have a Bachelor’s degree in Computer Science, Software Engineering, or related technical field.
• Must have 8 years of progressive experience in software development/engineering positions utilizing programming/scripting languages, including SQL, Spark, Scala, Python, Hive, Hadoop, Bash, and UNIX.
•  Must have at least 4 years of experience with:
  • Specialized knowledge of SQL, relational databases, ETL/ELT architecture, data integration concepts and big data concepts.
  • Planning and Managing Enterprise Data Lake projects
  • Using data quality tools for data profiling, cleansing and standardization.
  • Data acquisition, transformation, and storage design using design principles, patterns, and best practices.
  • Working within a team environment and interacting with data professionals and business data SME’s throughout the organization. 

Preferred Qualifications:

1. Master’s degree and eight years of experience or an equivalent combination of education and work experience

2.Banking or financial services 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%

General Description of Available Benefits for Eligible Employees of Truist Financial Corporation: All regular teammates (not temporary or contingent workers) working 20 hours or more per week are eligible for benefits, though eligibility for specific benefits may be determined by the division of Truist offering the position. Truist offers medical, dental, vision, life insurance, disability, accidental death and dismemberment, tax-preferred savings accounts, and a 401k plan to teammates. Teammates also receive no less than 10 days of vacation (prorated based on date of hire and by full-time or part-time status) during their first year of employment, along with 10 sick days (also prorated), and paid holidays. For more details on Truist’s generous benefit plans, please visit our Benefits site. Depending on the position and division, this job may also be eligible for Truist’s defined benefit pension plan, restricted stock units, and/or a deferred compensation plan. As you advance through the hiring process, you will also learn more about the specific benefits available for any non-temporary position for which you apply, based on full-time or part-time status, position, and division of work.