Data Engineer

About

The Data Engineer is responsible for designing, maintaining, and enhancing data pipelines and reporting solutions that enable accurate, timely, and trusted analytics across the organization. This role focuses on supporting operational and risk reporting needs while performing modifications to small and medium-sized databases. The position is structured to grow over time into larger-scale data engineering initiatives, including enterprise data integrations and complex data platforms.

Responsibilities

• Design, develop, and maintain reporting datasets, views, and data marts to support operational, risk, and compliance reporting.
• Hands-on experience with relational database technologies, including Microsoft SQL Server (MS SQL), to support data analysis, reporting, transformations, performance tuning, data quality improvement, and database maintenance.
• Working knowledge of Python for data processing, scripting, automation, and validation tasks in support of reporting and data engineering objectives.
• Experience working in Linux and Windows operating system environments, including supporting applications, scripts, and data workflows hosted on these platforms.
• Experience designing, developing, or supporting reporting and data visualization solutions, including the use of Tableau for operational, risk, audit, or compliance reporting.
• Partner with business and technical stakeholders to understand data requirements and translate them into effective data solutions.
• Ingest data from disparate technical platforms through direct data access, file-based transfers, APIs, or database connections.
• Execute data completeness and accuracy exercises to validate data integrity, identify gaps, and remediate data quality issues.
• Develop repeatable processes and automation to support data validation, reconciliation, and reporting consistency.
• Document data definitions, transformations, and lineage to ensure transparency and reuse across reporting solutions.
• Support audit, risk, and governance initiatives by providing traceable and well-controlled data outputs.
• Participate in incident response and root-cause analysis related to reporting or data quality issues.
• Progressively take on larger and more complex data engineering initiatives as skills and experience mature.

Desired Experience and Skills

• Familiarity with Identity and Access Management (IAM) data elements such as identities, entitlements, roles, authentication events, and access reviews.
• Experience performing data completeness, accuracy, and reconciliation exercises across multiple systems.
• Hands-on experience reaching out to technical teams to understand source system capabilities and ingest their data.
• Working knowledge of relational databases and SQL for analysis, reporting, and data transformations.
• Exposure to reporting and visualization tools and the ability to support both recurring and ad-hoc reporting needs.
• Strong problem-solving skills with the ability to analyze data issues across systems and domains.
• Clear written and verbal communication skills for technical and non-technical audiences.

Growth and Development Expectations

This role is intentionally designed to evolve. The successful candidate will begin by supporting reporting and smaller-scale data initiatives and will grow into larger data engineering responsibilities. Over time, this includes contributing to enterprise data platforms, complex data pipelines, advanced data modeling, and cross-domain integrations.

Qualifications

Required Qualifications:

• Bachelor's degree and five years of experience in systems engineering or administration or an equivalent combination of education and work experience
• In-depth knowledge in applied enterprise information security technologies including but not limited to firewalls, intrusion detection/prevention systems, network operating systems, identity management, database activity monitoring, encryption, content filtering, and Mainframe security
• Previous experience in planning and managing IT projects

Preferred Qualifications:

• Bachelor's degree and ten years of experience or an equivalent combination of education and work experience.
• Banking or financial services experience.
• Other security certifications (e.g.CCNA Security, GSEC, GCED, GPPA, etc.)
• Other technical Certifications (e.g.CCNA, RHCE, MCSE, etc.)
• Certification in Information Security Management (e.g.Certified Information Systems Security Professional (CISSP), Certified in Risk and Information Systems Control (CRISC) or Certified Information Security Manager (CISM)), or related security certification(s)
• Understanding of regulatory frameworks for financial institutions

Other Job Requirements / Working Conditions

• Sitting constantly (More than 50% of the time)
• 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.
• Able to work standard office equipment, including PC keyboard and mouse, copy/fax machines, and printers.
• Able to work all hours scheduled, including overtime as directed by manager/supervisor and required by business need.
• Minimal travel up to 10%

Benefits

• Medical insurance
• Dental insurance
• Vision insurance
• Life insurance
• Disability insurance
• Accidental death and dismemberment insurance
• Tax-preferred savings accounts
• 401k plan
• Vacation time
• Sick days
• Paid holidays

Equal Opportunity

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 E-Verify IER Right to Work