This IT role is with the AML "Anti Money Laundering" IT team, which provides ETL and GUI development services and AML development to Compliance, Control, and Legal functions.
We are looking for a talented individual looking to join a dynamic environment where they can raise the bar for the Capital Market industry. The person will be responsible for the success of IT projects by developing new, maintaining existing, and supporting a number of in-house/vendor applications from the data warehouse, database, and business intelligence (mainly for the AML space). The work will require analyzing business requirements, writing technical specifications, and working with the team to design, develop, test, and implement/support the solution.
Responsibilities:
The scope of the engagement will include, but not be limited to:
- Understand business requirements and functional specifications, and create
- technical framework and design document, Test plan, and Test Cases.
- Leverage Python and Database expertise in coding, scripting, and problem-solving
- Develop, debug, test, and maintain software applications by fixing any bugs or issues that arise.
- Write and understand Python, including data structures, algorithms, and libraries.
- Analyze complex problems, identify solutions, and implement them using Python
- Apply strong knowledge in Python and Shell Scripting required for file processing and database connections. Improve the performance of existing Python Code.
- Code, maintain, test, and provide code reviews for developed processes and procedures (e.g. queries, scripts, stored procedures, database objects, indices, triggers, etc.)
- Apply strong performance tuning knowledge in SQL to interpret plans, identify bottlenecks in queries, and remediate them
- Review, understand, and transform clearly defined technical specifications into data warehouse, database, and/or business intelligence solutions
- Perform detailed data analysis (i.e., determine the structure, content, and quality of the data through examination of source systems and data samples)
- Contribute to defining specifications for AML Monitoring models in the Actimize application (SAM/ ERCM)
- Use Data Modeling, Database Query Optimization, and Data Access techniques and concepts
- Use Database knowledge in areas of import and export, users, roles, privileges,
- schema and object management, session monitoring, etc.
- Apply strong knowledge in core Java for UI development, Power BI / Tableau for various reporting requirements.
- Work proactively to solve issues and problems
- Create use cases and assist in UAT testing efforts for the developed solutions
- Document, effectively track, and resolve issues in a timely manner during the development and testing phases (work with the team and end users as appropriate)
- Provide weekly progress reports of work performed
- Work with the project team to assist in other aspects of the project
- Follow and adhere to development standards, the software development lifecycle, vendor application/project standards, and guidelines
- Embrace the opportunity to take on special projects outside of specific roles and responsibilities
- Closely interact with onshore stakeholders and onshore/offshore teams on a regular basis.
- Support APS (Application Production Support) teams as required for various activities, such as DR tests and production releases.
- Contribute to knowledge-sharing initiatives across the team and innovation and creativity initiatives across the organization.
Qualifications
- Strong Knowledge of Python, Database Development, and Maintenance of applications.
- Excellent verbal and written communication skills
- Computer Science Degree or equivalent Degree