"Alerted.org

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.

Need Help? (https://www.brainshark.com/bbandt/careers-site-faq)

_If you have a disability and need assistance with the application, you can request a reasonable accommodation. Send an email to Accessibility ([email protected]?subject=Accommodation%20request)_

_(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:

Define and document the technical architecture of the data warehouse such as Conceptual Data Model, Logical Data Model and Physical Data Model. Derives database system specifications from business requirements, design solutions that support core organizational functions, and ensure their high availability and other performance goals. Provides integrated data model technical expertise and guidance across the organization, from conceptualization and project planning to the post-implementation support level.

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. Provides database system expertise, requirements and assistance to Systems and Database Administrators, other System Architects and application development teams.

2. Partners with line of business (LOB) teams, external vendors, and internal Data Services team to develop system specifications in compliance with corporate standards for architecture adherence and performance guidelines.

3. Provides technical resources to assist in the design, testing and implementation of software code and data models to support Data Infrastructure and Governance activities.

4. Assesses current technical architecture and estimate system capacity to meet near- and long-term processing requirements. Evaluates, selects, tests, and optimizes hardware and software products.

5. Consults with end-users, clients and senior management to define requirements for complex systems and data model development.

6. Oversees development and implementation of end-to-end integration of data model solutions.

7. Serves as a liaison with Enterprise Architects to conduct research on emerging technologies, and recommend technologies that will increase operational efficiency, infrastructure flexibility and operational stability.

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 a technical or business-related field, ten years of experience in data warehousing architectural approaches or equivalent education and related training or experience

2. Ability to derive technical specifications from business requirements and express complex technical concepts in terms that are understandable to multi-disciplinary teams, in verbal as well as in written form

3. Deep knowledge of SQL, Spark, Python, Git, ETL/ELT tools, Data Modeling tools

Preferred Qualifications:

1. Familiarity with Snowflake

2. Ability to create Conceptual Data Model, Logical Data Model and Physical Data Model

3. Familiarity with data warehousing modeling techniques

4. 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 (https://benefits.truist.com/)

. 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 is an Equal Opportunity Employer that does not discriminate 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 (https://www.eeoc.gov/sites/default/files/2022-10/EEOC\_KnowYourRights\_screen\_reader\_10\_20.pdf)

Pay Transparency Nondiscrimination Provision (https://www.dol.gov/sites/dolgov/files/OFCCP/pdf/pay-transp\_%20English\_formattedESQA508c.pdf)

E-Verify (https://e-verify.uscis.gov/web/media/resourcesContents/E-Verify\_Participation\_Poster\_ES.pdf)