Python SQL ETL Specialist

Regulatory Retention E-Communications Archive Team PositionThe Regulatory Retention E-Communications Archive team is growing to meet the demands of our business partners. The team is responsible for engineering and development in support of the Bank Enterprise Regulatory E-Communications Archive for e-discovery and supervision services. The team processes, archives, and owns record management for 50+ data feeds. They carry out all automation, metrics, and reporting for these services.Typical work items may include: onboarding new feeds, occasionally in partnership with Line of Business teams, in other instances, the requirement will be managed end to end. Design and develop automation to improve onboarding workflows. Validation of controls. All efforts are completed in line with the bank's rigorous change control procedures and in line with the bank's standardized 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 critical to ensure all custom integrations are rigorously documented for supportability and transparency.Work independently and cooperatively within a team to 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 QualificationsTechnical Experience [required / desired]:Python on WindowsMS SQL Queries & Stored ProceduresRedHat Python Development and VIMWeb APIs/SOAPREST ServicesLinuxDesired QualificationsStrong knowledge of:MessagingArchivaleDiscoveryM365 / Teams / SharePoint etc.