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 and 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 by evaluating ETL packages, source data, and destination systems.
Develops, updates, and maintains ETL specifications and documentation used to develop data migration mappings and transformations.
Develops close working relationships with project management and end users to understand issues and deliver accurate and efficient solutions.
Serves as a mentor to less experienced database developers and provides advice and guidance on programming issues.
Brainstorms solutions with the team and performs other duties as assigned.
Requirements
Undergraduate degree in a related field or an equivalent combination of training and experience.
5 years of T-SQL and SQL Server Integration Services (SSIS) development experience.
Ability to write and understand complex SQL queries.
Experience creating new ETL packages and maintaining SSIS packages.
Working knowledge of Anti Money Laundering platforms and technologies such as Actimize (preferred).
Banking or financial services experience (preferred).
Excellent verbal, written, and interpersonal communication skills.
Excellent analytical ability, judgement, and problem analysis techniques.
Ability to take ownership of projects and be self-directed.
Ability to work effectively in a team fostered, multi-tasking environment.
Must pass background check including credit, criminal, education, employment, OFAC, and social media background history.
Benefits
Work Arrangement: ***After the initial training period, this is a hybrid role, working onsite in our Sioux Falls, SD office.***
Working at The Bancorp Bank, N.A. and Benefits Information: click here
Senior Backend Developer specializing in designing and building event - driven systems. Part of a digital advertising team working with major platforms globally.
Senior .NET Backend Developer designing and maintaining cloud - based applications with Azure, focusing on backend services. Collaborating with teams and mentoring junior engineers.
Back - end Developer at Onfly focusing on creating technology solutions for travel management. Join a high - performance team in a recognized workplace in Brazil.
Control Desk role in Goiânia specializing in operational metrics and service level oversight. Engaging in data collection and trend analysis for service efficiency.
Senior Full Stack Developer in banking solutions focused on guarantees and credit management. Engage in high criticality systems deploying .NET and MongoDB expertise in a hybrid model.
Senior Lead Developer and Architect for healthcare applications, leveraging Java and web technologies. Leading a team and ensuring high - quality software development in a hybrid work environment.
Java/Node.js Developer designing, developing, and maintaining scalable applications at Brillio. Collaborating with teams, managing APIs, and optimizing performance following modern software architecture.
Senior Backend Engineer developing scalable infrastructure services and tools for Spotify’s Data Platform team. Collaborating in a cross - functional team to solve critical data engineering problems.
Backend Engineer focusing on Storage Infrastructure and developing scalable solutions for Spotify. Engaging in high - profile projects and enhancing foundational systems for audio streaming service.