AVP Database Developer II (Hybrid)

Key Responsibilities

• Creates new Extraction, Transformation, and Loading (ETL) packages to achieve data integration between various source and destination systems including the Anti Money Laundering system Actimize.
• Tests and debugs code using departmental standards and protocols prior to elevation.
• Acts as a subject matter expert in the existing ETL packages used to load Actimize.
• Makes recommendations and implement improvements to the packages.
• Reviews database design and code written by other database and application developers, identifies issues, and discusses efficiencies to improve data integration code and/or controls.
• Troubleshoots ETL issues as they arise by evaluating the ETL packages, source data, and destination systems.
• Develops, updates, and maintains ETL specifications and documentation used to develop data migration mappings and transformations.

Qualifications

• Undergraduate degree in a related field or an equivalent combination of training and experience.
• A minimum of 3 years T-SQL and SQL Server Integration Services (SSIS) development experience.
• Excellent analytical ability, judgement, and problem analysis techniques.
• Ability to write and understand complex SQL queries.
• Ability to take ownership of projects and be self-directed.
• Ability to work effectively in a team fostered, multi-tasking environment.
• Experience with or exposure to data tools such as data catalogs (e.g., Atlan), data warehouses (e.g., Snowflake), transformation tools (e.g., dbt), or reporting platforms.
• Familiarity with or interest in data automation, AI/ML concepts, and AI-assisted analytics tools, with the ability to apply them in a governed environment.
• Effective communication and collaboration skills, with experience working across technical and business teams in a regulated environment.
• Banking or financial services experience.