Python SQL ETL Specialist

Overview

On Site
Contract - W2
Contract - Independent
Contract - Long Term

Skills

linux
Python SQL ETL
Web APIs/SOAP
Messaging

Job Details

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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.