Python SQL ETL Specialist

Job TitlePython SQL ETL Specialist

LocationHenrico, VA

Primary SkillsMySQL

Job Description

Position Summary:

The Regulatory Retention E-Communications Archive team are growing to meet the demands of our business partners.

The team are responsible for engineering and development in support of the Bank Enterprise Regulatory E-Communications Archive for e-discovery and supervision services.

The team process, archive, and own record management for 50+ data feeds. They carry out all automation, metrics, and reporting for these services.

For reference, information about the services/vendors in this space are detailed by Gartner's - Enterprise Information Archive (EIA).

Typical work items may include: onboarding new feeds, occasionally, this will be in partnership with Line of Business teams, in other instances, the requirement will be managed end tend. Design and develop automation to improve onboarding workflows. Validation of controls.

All efforts are completed in line with the banks rigorous change control procedures and in line with the banks standardised tools.

Lead design, development and implementation of technical integrations to timely delivery

Develop code that will translate from files of varying types (e.g., XML, JSON, CSV, Tab Delimited, etc.) into a specific XML format

Capture and log any exceptions and abnormalities with automated responses

Documentation critic to ensure all custom integrations are rigorously documented for supportability and transparency

Work independently and co-operatively within a team to achieve the following:

Document and validate requirements

Plan work sprints and provide delivery timelines

Perform backend development (business logic).

Provide day to day support for data and application.

Ability to configure vendor products and build integrations.

Develop automations and workflow software

Architecture, Design, Product Lifecycle - General Engineer Skills

Required Qualifications

Technical Experience [required / desired]:

Python on Windows

MS SQL Queries & Stored Procedures

RedHat Python Development and VIM

Web APIs/SOAP

REST Services

Linux

Desired Qualifications

Strong knowledge of:

Messaging

Archival

eDiscovery

M365 / Teams / SharePoint etc.