Responsibilities
About the Role:
Databricks and Python Developer with strong background in AWS. This position is responsible for Development and Technical Support with a high degree of customer service, technical expertise and timeliness. The primary purpose of the position is to develop and support Bank data solutions.
Experience in Machine Learning/AI projects is a plus.
Experience in the area of Banking or Finance is desirable.
The ideal candidate will have Databricks on AWS Development and/or Support background with the ability to quickly adapt those skills to new environments. This position will work with Business units and the Technology Group. Occasional travel will be required.
Duties include
1. Analysis, design, development, support and maintenance of DW, Data Lake and Lakehouse infrastructures
2. Technical expertise on data pipelines and ETL processes.
3. Solid understanding of SQL and Data Modelling
4. Hands on experience with Databricks on AWS cloud solutions
5. In-depth knowledge of Databricks ETL and Orchestration, notebook development and job scheduling
6. Collaborate with cross-functional teams of business analysts, business users and IT stakeholders gathering, documenting, analysing and implementing requirements
7. Collaborate with multiple teams to develop and maintain data pipelines, harvesting data from systems of records to create data products
8. Create and optimize relational databases schema, tables, indexes, views, and stored procedures
9. Perform data migration, transformation, and integration tasks between different database systems
10. Develop and maintain ETL processes to load and transform data from various sources
11. Work with other development groups to advise, guide and assist in their integrations
12. Familiarity with version control systems ( GIT) and Agile development methodologies
13. Interact with vendor for support and consultancy
14. Work directly with reporting manager to ensure clear and accuratemunication of current status, dependencies and estimated delivery timelines
15. Clearlymunicate issues, risks and proposed solutions to relevant stakeholders
16. Coordinate the release process with business groups, operations inpliance with ITIL Change Management discipline
17. Support QA testing
18. Provide direction & support to the Business Divisions for User Acceptance Testing
19. Utilizing Reporting tools to rapidly create, modify, refresh and update dashboards and reports
Qualifications
EDUCATION, EXPERIENCE & SKILLS:
DW / Business Intelligence / Cloud
20. 5-7 years' experience in DW/BI hands-on development and data-modelling experience
21. 3-5 years' experience in Databricks on Amazon Web Services cloudputing platforms
22. 3-5 years' experience in Reporting and Visualization tools with deep understanding of relevant architecture and framework
Development
23. Experience with business intelligence, data analysis, data modelling and visualization solutions on Cloud, on-premises and hybrid
24. Experience with Databricks platform
25. Experience with Python, SQL, relational database objects (Postgres, Oracle and/or SQL Server) and procedural languages (PL/pgSQL, PL/SQL and/or T-SQL)
26. Experience with Version Control systems
27. Web Services integration using REST/SOAP/JSON
28. Machine Learning/Artificial Intelligence is a plus
29. Exposure to SQL Server Integration Services
General
30. Must have excellentmunication skills and be able present diagnostic, troubleshooting steps and conclusions to a varied audience including both business and technical stakeholders excellent listening and analytic skills excellent oral/writtenmunication skills strong interpersonal andmunication skills and ability to deal effectively in a team environment
31. Bachelor's degree inputer Science, or similar discipline, or equivalent education and experience
32. Ability to work independently with or without direction and or supervision, portray professional demeanour
Additional Beneficial Attributes/Skills:
33. Agile and SCRUM methodologies
34. Exposure generating and manipulating XML and XBRL formats
35. Hedge Funds or Financial systems industry domain experience
This is a challenging role in a highly visible program of work that will expose the candidate to both business and technical teams across the Citco business lines. It is an opportunity to expand your data analysis, BI and data visualization skills while at the same time requiring strong technical ownership and the opportunity to deliver apanywide, self-service, state-of-the-art reporting solution for Citco that will be used by both our internal and external customers. Citco is a friendly and fast-paced environment and is proud to offer our employeespetitivepensation, vacation and health insurance benefits. Job ID 300001203866735