girl looking into her desktop
Back to search results

Data Engineer III

Charlotte, North Carolina

Job Description:

Job Description:

We are seeking a highly technical and experienced Application Teradata SQL/SAS ETL Senior Developer/Engineer to support the development of Enterprise Information / Data Science Products owned and operated by the Chief Data Scientist Organization (CDSO). This role will support the ‘Global Financial Crimes Compliance/ Anti-Money Laundering” regulatory & compliance efforts for the CDSO systems engineering / application development team with development on enterprise Teradata/SAS platforms. Qualified candidates must be well-versed in building end-to-end advanced Teradata SQL/SAS-based ETL/analytical products and services.

Responsibilities:

  • Typically 10-12 years of experience.
  • Develop, enhance, debug, support, maintain and test software applications that support business units or supporting functions, primary based on Teradata data-warehouse
  • Have knowledge of data systems engineering using Teradata and understand intricacies of database model design, and performance optimizations for in-database SQL processing and ETL
  • Support end-to-end data-warehouse application development including requirements gathering, design, coding, testing, implementation and maintenance/support of complex Teradata SQL / SAS -based applications
  • Working and managing specialized transaction repositories in the financial services domain, and application of this knowledge to research, design and operationalize the world of commerce into discrete, meaningful data categories
  • Clustering, principal component analysis, and heuristics based algorithms for behavioral segmentation and categorization
  • Designing and developing multi-level multi-node relationship based network models (Employer-Employee, Buyer-Supplier, Business-to-Business) that drive risk mitigation and revenue generation opportunities
  • Designing, modeling and architecting (logical, physical, data, information architecture) complex applications/systems for transaction and customer profile databases
  • Working with Statistical and Business Intelligence tools like SAS and Tableau for end state reporting and user support
  • Conduct proof of concepts to evaluate Big Data platforms and technologies (Hadoop, NoSQL) for advanced analytics and extend large database capabilities
  • Working with Python/PySpark programs connecting to various database and repositories to load/export/process data
  • Supports systems through maintenance, modification, problem resolution to support ongoing delivery of application ETL services and/or operations on the data-warehouse platform including on-call support
  • Serves as a fully seasoned/proficient technical resource - should be ready to get into the weeds of the code, analyze and research data and SQL optimization problems, discuss technical details with the development/support team.
  • Lead the resolution process for complex problems where analysis of situations or data requires an in-depth evaluation of various factors
  • Provides tech knowledge and capabilities as team member and individual contributor, but also responsible for instructing, directing, and checking the quality and timeliness of other systems professionals, including offshore resources.
  • May lead multiple projects with competing deadlines.
  • Works under minimal supervision, with general guidance from manager

Required Skills

  • Computer Science/Software Engineering (or related) degree
  • 10+ years’ experience with end-to-end application development on Teradata data-warehouse and analytical platforms
  • Extensive experience developing complex Teradata SQL-based ETL and analytic workflows using native utilities (bteq, tpt, fastexport)
  • Very good knowledge of Unix/Linux shell Scripting and scheduling (like Autosys)
  • Very good knowledge of the SAS analytical programming and experience working in a Teradata+SAS environment
  • Good knowledge of Business Intelligence and reporting tools like Tableau
  • Experience working with Big Data Technologies, programs and toolsets like Hadoop, Hive, Sqoop, Impala, Kafka, and Python/Spark/PySpark workloads
  • Working knowledge of CI / CD based development and deployment – JIRA, BitBucket
  • Excellent written, communication and diagramming skills
  • Strong analytical and problem solving abilities
  • Speaking / presentation skills in a professional setting
  • Excellent interpersonal skills and a team player to work all along with Global teams and business partners
  • Positive attitude and flexible
  • Willingness to learn new skills and adapt to changes

Desired Skills

  • Industry certifications like Teradata, Hadoop, SAS, Big Data

Job Band:

H5

Shift: 

1st shift (United States of America)

Hours Per Week:

40

Weekly Schedule:

Referral Bonus Amount:

0

Job Description:

Job Description:

We are seeking a highly technical and experienced Application Teradata SQL/SAS ETL Senior Developer/Engineer to support the development of Enterprise Information / Data Science Products owned and operated by the Chief Data Scientist Organization (CDSO). This role will support the ‘Global Financial Crimes Compliance/ Anti-Money Laundering” regulatory & compliance efforts for the CDSO systems engineering / application development team with development on enterprise Teradata/SAS platforms. Qualified candidates must be well-versed in building end-to-end advanced Teradata SQL/SAS-based ETL/analytical products and services.

Responsibilities:

  • Typically 10-12 years of experience.
  • Develop, enhance, debug, support, maintain and test software applications that support business units or supporting functions, primary based on Teradata data-warehouse
  • Have knowledge of data systems engineering using Teradata and understand intricacies of database model design, and performance optimizations for in-database SQL processing and ETL
  • Support end-to-end data-warehouse application development including requirements gathering, design, coding, testing, implementation and maintenance/support of complex Teradata SQL / SAS -based applications
  • Working and managing specialized transaction repositories in the financial services domain, and application of this knowledge to research, design and operationalize the world of commerce into discrete, meaningful data categories
  • Clustering, principal component analysis, and heuristics based algorithms for behavioral segmentation and categorization
  • Designing and developing multi-level multi-node relationship based network models (Employer-Employee, Buyer-Supplier, Business-to-Business) that drive risk mitigation and revenue generation opportunities
  • Designing, modeling and architecting (logical, physical, data, information architecture) complex applications/systems for transaction and customer profile databases
  • Working with Statistical and Business Intelligence tools like SAS and Tableau for end state reporting and user support
  • Conduct proof of concepts to evaluate Big Data platforms and technologies (Hadoop, NoSQL) for advanced analytics and extend large database capabilities
  • Working with Python/PySpark programs connecting to various database and repositories to load/export/process data
  • Supports systems through maintenance, modification, problem resolution to support ongoing delivery of application ETL services and/or operations on the data-warehouse platform including on-call support
  • Serves as a fully seasoned/proficient technical resource - should be ready to get into the weeds of the code, analyze and research data and SQL optimization problems, discuss technical details with the development/support team.
  • Lead the resolution process for complex problems where analysis of situations or data requires an in-depth evaluation of various factors
  • Provides tech knowledge and capabilities as team member and individual contributor, but also responsible for instructing, directing, and checking the quality and timeliness of other systems professionals, including offshore resources.
  • May lead multiple projects with competing deadlines.
  • Works under minimal supervision, with general guidance from manager

Required Skills

  • Computer Science/Software Engineering (or related) degree
  • 10+ years’ experience with end-to-end application development on Teradata data-warehouse and analytical platforms
  • Extensive experience developing complex Teradata SQL-based ETL and analytic workflows using native utilities (bteq, tpt, fastexport)
  • Very good knowledge of Unix/Linux shell Scripting and scheduling (like Autosys)
  • Very good knowledge of the SAS analytical programming and experience working in a Teradata+SAS environment
  • Good knowledge of Business Intelligence and reporting tools like Tableau
  • Experience working with Big Data Technologies, programs and toolsets like Hadoop, Hive, Sqoop, Impala, Kafka, and Python/Spark/PySpark workloads
  • Working knowledge of CI / CD based development and deployment – JIRA, BitBucket
  • Excellent written, communication and diagramming skills
  • Strong analytical and problem solving abilities
  • Speaking / presentation skills in a professional setting
  • Excellent interpersonal skills and a team player to work all along with Global teams and business partners
  • Positive attitude and flexible
  • Willingness to learn new skills and adapt to changes

Desired Skills

  • Industry certifications like Teradata, Hadoop, SAS, Big Data

Shift:

1st shift (United States of America)

Hours Per Week: 

40

Learn more about this role

Full time

JR-21063213

Band: H5

Manages People: No

Travel: Yes, 5% of the time

Manager:

Talent Acquisition Contact:

Pamela Salvato

Referral Bonus:

0

Street Address

Primary Location:
800 W TRADE ST, NC, Charlotte, 28255