ETL developer consultant

ETL Developer Consultant for direct client in New York City

Work Schedule Hybrid - 50% remote (i.e 5 days out of 10)

OUT OF STATE CANDIDATES WILL NOT BE CONSIDERED 

Job Summary:

Experienced IT Developer to work on project requirements in Corporate IT.

This is a challenging position requiring strong, proven experience in analysis, design, delivery, and production support and domains. The role provides solutions to business requirements for multiple complex projects in parallel to successfully suggest and deliver solutions for Information Technology, specifically for Compliance, Regulatory Reporting, and Operational Controls.

Successful candidate must be experienced with identifying and analyzing technology and process problems, while developing solutions for tactical and/or strategic projects, in collaboration with Business and Technology stakeholders across the organization. Identify and document gaps in procedures, and create solutions for scalable and repeatable processes, in adherence with the various department s frameworks and IT best practices established.

Own the management information and data requirements gathering initiative to develop and/or streamline the operational reporting capabilities. Ensure that all the necessary processes are thoroughly implemented to take full advantage of the capabilities of the systems.

The candidate must be a people person, technically proficient, able to multi-task well, explain solutions clearly, is well organized, and is able to work independently with minimal oversight.

Previous exposure/knowledge in developing IT solutions for Equity Compliance regulations at a bank desired.

Major Responsibilities:

• Design & Development ETL tasks and Tidal jobs including scheduling and dependencies (Python scripts)
• Maintain Tidal jobs across all environments (DEV, UAT & PROD)
• Maintain all ETL code in subversion repositories (DEV & TRUNK)
• Follow build & version control process using Jenkins & AZURE Dev Ops
• Set up FTP connections for data transmission supporting automated processes
• Support BA team with data analysis, with identification and extraction of correct data required, and suggest data extract rules
• Verify all job changes & promotions to UAT and prod environments
• Create Service Now tickets for all Tidal & ETL jobs
• Manage and track all time and tasks in JIRA
• Help set up and streamline various data extract processes

Required Qualifications:

• Bachelor s Degree in Computer Science, Management of Information Systems, or related business discipline(s).
• 3-5 years work experience with IT or process engineering
• Process mapping/ process improvement experience
• Complex SQL query knowledge
• Python knowledge
• Ability to prioritize and effectively manage multiple tasks
• Excellent interpersonal, written and verbal communication skills
• Highly motivated, self-directed individual with the ability to work independently and in team environments
• Effective presentation skills, combined with extreme attention to detail
• Strong analytical, problem solving, and decision-making skills
• Collaborative team player and relationship builder.