The position is described below. If you want to apply, click the Apply Now button at the top or bottom of this page. After you click Apply Now and complete your application, you'll be invited to create a profile, which will let you see your application status and any communications. If you already have a profile with us, you can log in to check status.

If you have a disability and need assistance with the application, you can request a reasonable accommodation. Send an email to Accessibility (accommodation requests only; other inquiries won't receive a response).

Regular or Temporary:

Regular

Language Fluency: English (Required)

Work Shift:

1st shift (United States of America)

Please review the following job description:

The ETL Analyst will serve a key role in designing, maintaining, and implementing data environment within Truist. This role will work closely with the technology delivery group and other cross-functional groups within Truist. The Analyst must be able to configure, connect and design data coming from different sources to be used for dashboards for the wider groups within Truist and at the enterprise level. Success in the position requires strong, clear communication skills, an understanding of the application's current design, and a clear understanding of Tableau and the visualization framework.

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. Gathers, reviews, analyzes, profiles, validates and maps system data into the data warehouse to meet reporting and analytical business needs.
2. Performs data analysis and troubleshooting on data-related issues reported by production support and other teams.
3. Develops solutions and recommendations for improving data integrity issues. Analyzes data issues and works with development teams for problem resolutions. Identifies problematic areas and conducts research to determine the best course of action to correct the data, identify, analyze and interpret trends and patterns in complex datasets.
4. Determines and analyzes line of business requirements, use system data, and provide input needed by various departments and senior management to produce business reports.
5. Works with extract, transform and load (ETL) developers to test and validate data attributes and with other business analysts to ensure data is integrated consistently, regardless of the source system.
6. Works with business analysts and project teams to provide accurate documentation of data related project and support deliverables. And with source system business analysts to understand system nuances and resolve data issues. Takes ownership of issues through resolution including close coordination between business analysts.
7. Creates data quality metrics and scorecards. Performs regular audits of data. Understands data governance principles and how they apply.
8. May instruct, direct, and mentor other members of the team.

QUALIFICATIONS
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.
1. Bachelor's degree in information technology, information systems, computer science or business-related field, eight years of experience in a role of data analysis, statistical analysis, data transformation, data reconciliation and/or sophisticated data presentation or equivalent education and related training or experience
2. Experience in ETL Development using standard tools
3. Understanding of Enterprise Data Warehouse concepts and prior experience applying that understanding to query data in a Very Large Database (VLDB) environment
4. Familiarity in using a query analysis tool

Preferred Qualifications:

complete understanding of entire ETL lifecycle.
Hands on experience using Alteryx Designer
Hands on experience in writing complex SQL queries for data retrieval and manipulation from organization datamart/datalake.
Hands on experience in connecting SQL database to visualization tool (Tableau) for dashboarding.
Hands on experience using Tableau for data visualization.
Hands on experience with SQL joins, Indexing and data relationships across data architecture.
Hands on experience with Python as scripting language to perform data analysis.
Performs data profiling and data analysis to assist in understanding the data.
Optimizes data models through normalization, table analysis and review of queries.
Collaborating with cross-functional teams to gather requirements and implement solutions.
Creating and maintaining database documentation
Implementing and maintaining database security measures

Required Skills:

Bachelor's Degree and at least three years of experience or equivalent

3-5 years of experience and a degree in a technical field or an equivalent combination of experience and education

Must have proven experience as ETL / Alteryx Developer or similar role
Must have proven experience as a SQL Developer or similar role.

Nice to have experience with Python scripting language
Familiarity with database tools for schema design, data modeling, and version control.
Strong analytical and problem-solving skills
Hands-on experience with ETL tools and managing large data sets.
Able to work in a manual data analytics environment.
Ability to communicate complex technical ideas, regardless of the technical capacity of the audience.
Strong interpersonal skills and ability to work as part of a team.
Strong analytical and critical thinking

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.

Truist supports a diverse workforce and is an Equal Opportunity Employer that does not discriminate against individuals on the basis of race, gender, color, religion, citizenship or national origin, age, sexual orientation, gender identity, disability, veteran status or other classification protected by law. Truist is a Drug Free Workplace.

EEO is the Law Pay Transparency Nondiscrimination Provision E-Verify