AVP Systems Engineer- Business Intelligence (L 10)

Role Summary/Purpose: Technical leader for development of multiple build projects to improve, enhance or add new functionality to one of Synchrony Data warehouse application. as well as all run support activities. Provide technical oversight, process architecture, design expertise and guidance, interdepartmental coordination and vendor direction for Synchrony Data warehouse application transformation efforts. This individual will work with development teams utilizing modern software development methodologies and tools to provide best solution for Synchrony.

Essential Responsibilities:

• Responsible for all components related to ETL (Extract/Transform/Load) build project deliverables.
• Oversee Vendor work on build projects; review designs to ensure project requirements are met 
• Review and certify IT estimates, requirements, design, coding and testing deliverables.
• Oversee project validation (QA) and production promotion.
• Provide senior level expertise in technical disciplines used.
• Ensure compliance with Data Governance, architecture, technology and security standards set by SYF.
• Govern design strategy, production promotion processes, software change control specifically related to Ab Initio as well as DW technology.
• Drive effort to find ways to increase efficiency minimize operating expense and improve performance of all data warehouses gather, store and deliver functions.
• Interface regularly with the SYF Data Warehouse application.
• Proactive communication with regard to deliverable status, issues, barriers, or challenges.
• Ensure preparation and maintenance of appropriate technical documentation including but not limited to program design document, process flows and test plan.
• Participate in addressing IR's/RCA's with Service Delivery team and provide direction in problem resolution. 

Qualifications/Requirements:

• Bachelor’s degree in IT, Computer Science or MCA with 8 years of experience in Information Technology with atleast 4 years of experience in  data management.
• Minimum of 4 years’ experience with ETL tools such as Abinitio, Py Spark or Informatica.
• Expertise and/or proficiency in the following: Unix Scripting, SQL, Ab Initio, Py Spark.
• Experience in Data Architecture and Data Modelling.
• Experience in Data Management within the financial services industry
• For Internal Applicants: Understand the criteria or mandatory skills required for the role, before applying.
• Inform your Manager or HRM before applying for any role on Workday.
• Ensure that your Professional Profile is updated (fields such as Education, Prior experience, Other skills) and it is mandatory to upload your updated resume (Word or PDF format)
• Must not be any corrective action plan (First Formal/Final Formal, PIP)
• Employees who have completed 18 months in the organization and 12 months in current role and level are only eligible.
• Last annual performance rating should at least be Strong Contributor/Critical Talent
• Existing Level 9 and 10 only are eligible to apply

Desired Characteristics:

• Competent with data transmission protocols.
• Competent with data encryption methodologies.
• Competent with Agile methodologies.
• Excellent interpersonal skills with ability to influence clients, team members, management and external groups.
• Superior oral and written communication, analytic and problem-solving skills.
• Ability to work independently and within a team setting.
• Ability to work in a dynamic environment and manage multiple assignments simultaneously.
• Strong working knowledge of Bank Card, PLCC and Consumer Lending Program Applications 
• Expertise with Informix and/or Oracle databases. 

Grade/Level: 10

Job Family Group: