Software Engineer

Truist; Charlotte (NC); On-site; USD 110,000 - 140,000; Full time

Job summary

Truist is seeking an experienced data/ETL professional to support the Card Fraud Strategy Analytics initiative. The role focuses on enabling data-driven decisions by partnering with business and technology teams, aligning with data governance, and delivering scalable Talend-based ETL pipelines in Snowflake.

You will work closely with Fraud and Enterprise Architects, translate legacy ETL workflows, and optimize data flows for performance and cost, supporting enterprise data modernization efforts

Qualifications

• Bachelor’s degree in computer science, software engineering, or related field with 5 years of relevant experience or equivalent education and training.

Responsibilities

• Serve as a liaison between Technology Delivery and business lines to communicate needs and deliver technology solutions.
• Lead requirements elicitation, document business and technical requirements, and guide stakeholders throughx planning and validation.
• Analyze legacy ETL workloads (Informatica & Ab Initio) and translate them into scalable Talend-based solutions.
• Design and implement ETL/ELT pipelines to load and transform data into Snowflake following Medallion architecture (Bronze/Silver/Gold).
• Migrate from legacy tools to Talend and Snowflake, optimize data pipelines for performance and cost.

Skills

Talend ETL

Snowflake

Informatica

Ab Initio ETL

ETL/ELT

Education

Bachelor’s degree in Computer Science or related field

Tools

Talend Data Integration

Snowflake

Informatica

Job description

Need Help?

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)

Job Description

Support a team responsible for technology solutions that meets business needs and satisfy data requirements of the Enterprise Fraud Management group. This role, which is focused on enabling Card Fraud Strategy Analytics team, is also engaged with many business and technology partners. A primary driver of success will be the ability to partner with upstream and downstream groups (users, providers & vendors), applications, architecture teams, technology tool teams. Consult and partner with the business product owners to understand the end goal and offer solutions and recommendations during the design. Must be adept at data discovery, source identification, profiling, data governance concepts, privatization, enterprise technology standards, ETL design, big data, cloud engineering concepts, reporting and analytic design, analytic tool platforms. Existing awareness of banking products, transactions, card fraud concepts is highly desired. Ability to establish relationships with Card Fraud Strategy and Fraud Management Teams and anticipate needs and values is key.

Drive requirements elicitation process for work efforts of all size and complexity. Work in an indirect leadership capacity to influence collaboration, communication and outcomes of various initiatives. Lead work on all phases of systems analysis up to the enterprise level of the organization’s business processes and systems. Provide project and portfolio management for smaller projects and business enhancements. Serve as a key liaison between line of business (LOB) and the Technology Delivery teams. Hands-on experience with Talend ETL and Snowflake data platform is required. Ability to analyze, understand, and convert existing Informatica and Ab Initio ETL workflows into Talend jobs is critical. Must have working knowledge of Snowflake architecture including databases, schemas, virtual warehouses and performance optimization, along with understanding of Medallion architecture (Bronze, Silver, Gold layers).

Essential Duties And Responsibilities

• Serve as a key liaison between the Technology Delivery team and LOBs. Perfect candidate will have hybrid, techno-functional mindset and background.
• Collaborate with peer groups in Technology and LOBs to identify, document and communicate business needs and provide technology solutions.
• Work closely with business stakeholders to understand business processes and strategies.
• Establish project and work requests requirements using document, business process and workflow analysis. Ensure all stakeholders are involved in requirements gathering activities.
• Facilitate requirements elicitation sessions and walkthroughs with appropriate stakeholders to plan, elicit, capture and validate business, functional and technical requirements
• Work closely with Fraud and Enterprise Architects to perform current state analysis of existing business systems, applications and functions.
• Understand the long-term business objectives and suggest strategies to meet those objectives and introduce technical innovations, as needed.
• Develop and maintain effective working relationships with business process owners and other stakeholders to support documenting the acceptance criteria and a plan to facilitate user acceptance testing of a solution that meets the business requirements.
• Prioritizing and requesting data capture in enterprise repositories (Data Lake, Snowflake) for analytic support, card fraud team needs.
• Support Card Fraud Data Delivery Team with new initiatives, work on design and solutions (interim and long-term) to enable business partners to perform better analytics to fight fraud
• Work with various vendors that supply data for Card Fraud needs, and support delivery of new initiatives and projects
• Researching data – availability, sourcing, quality, relationships, lineage
• Work with other Data Delivery teams to source data within the Enterprise.
• Partners with engineers, data scientists, and the data office leadership to define and refine data architecture and technology choices.
• Analyze existing Informatica and Ab Initio ETL codebases, document transformation logic, and convert them into scalable Talend ETL jobs.
• Support migration and modernization efforts from legacy ETL tools (Informatica/Ab Initio) to Talend and Snowflake DB.
• Design and implement ETL/ELT pipelines to load and transform data into Snowflake, aligning with Medallion architecture layers (Bronze, Silver, Gold).
• Optimize data pipelines for performance, scalability, and cost-efficiency within Snowflake.
• Collaborate with data engineering teams to ensure data quality, governance, lineage, and reconciliation during ETL migration and transformation processes.

Qualifications

Required Qualifications

• Bachelor’s degree in computer science, Software Engineering, or related field with 5 years of relevant experience or equivalent education and training.
• In-depth knowledge of information systems and ability to identify, apply, and implement IT best practices.

Preferred Qualifications

• Bachelor degree or equivalent experience to include six years of information technology experience with significant experience in software development
• Management Experience planning, facilitating, eliciting, documenting and managing business, functional and technical requirements
• Experience with Agile/Lean methodologies
• Ability to interact with management, business staff, ADS and DTS personnel in order to gather, compile and exchange information on work requests/project requirements and negotiate disputes effectively
• Strong presentation, verbal and written skills
• Ability to manage multiple concurrent projects, activities and tasks under time constraints
• Ability to effectively interface with staff at all levels and resolve conflicts
• Exceptional communication, teamwork and influencing skills that foster a collaborative and continuous-improvement environment
• Excellent facilitation and organizational skills
• Strong critical and analytical thinking and problem-solving skills
• Demonstrated proficiency in basic computer applications, such as Microsoft Office software products
• Understand core systems, applications and technical platforms
• Experience with Talend Data Integration and working experience with Snowflake cloud data platform is required.
• Must have the ability to understand and interpret legacy ETL workflows (Informatica and Ab Initio) and translate them into modern Talend-based solutions. Strong understanding of ETL/ELT migration strategies is essential.

Preferred Qualifications

• An understanding of current trends in technology
• Ability to read, analyze and interpret technical data
• Demonstrated proficiency in basic computer applications, such as Microsoft Office software products
• Excellent facilitation and organizational skills
• Strong critical and analytical thinking and problem-solving skills
• Experience with Data analysis and prior experience working with large datasets
• Ability to manage multiple concurrent projects, activities and tasks under time constraints
• Experience working with transactional data, working knowledge of SQL, relational databases, understanding of ETL architecture and concepts, data integration concepts and big data concepts
• Have working experience with Agile methodologies
• Experience implementing Medallion architecture (Bronze/Silver/Gold layers) in Snowflake or similar cloud platforms.
• Knowledge of Snowflake optimization techniques such as clustering, partitioning, query tuning, and cost optimization.
• Experience with Talend orchestration, scheduling, and end-to-end pipeline development.
• Familiarity with data lake migrations, cloud data platforms, and enterprise data modernization initiatives is preferred.
• Experience working with transactional data, working knowledge of SQL, relational databases, working experience and understanding of ETL/ELT architecture and concepts, data integration concepts and big data concepts
• Direct the engineering and deployment of delivery projects in accordance with specified technical requirements and schedules, including Agile methodologies.
• Oversee the planning, design, engineering, testing and deployment of application projects in conjunction with a variety of resources, which may include Waterfall or Agile approaches.
• Adapt plans to meet service and/or operational challenges. Identifies and resolves technical and business evolving needs from Card Fraud team based on new fraud attacks.
• Fraud – understanding of financial fraud and the data required to identify and prevent different types of attacks.

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