Description – Data Engineer
Since the 1940s Citco has provided specialist financial services to alternative investment funds, investors, multinationals and private clients worldwide. With over 6,500 employees in 45 countries, we pioneer innovative solutions that meet our clients’ evolving needs and deliver exceptional service.
Our continuous investment in learning means our people are among the best in the industry. And our corporate social responsibility programs provide meaningful and fulfilling work in the community.
A career at Citco isn’t just a job – it’s an opportunity to excel in an environment that genuinely supports your personal and professional development.
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
Analysis, design, development, support and maintenance of DW, Data Lake and Lakehouse infrastructures
Technical expertise on data pipelines and ETL processes.
Solid understanding of SQL and Data Modelling
Hands on experience with Databricks on AWS cloud solutions
In-depth knowledge of Databricks ETL and Orchestration, notebook development and job scheduling
Collaborate with cross-functional teams of business analysts, business users and IT stakeholders gathering, documenting, analysing and implementing requirements
Collaborate with multiple teams to develop and maintain data pipelines, harvesting data from systems of records to create data products
Create and optimize relational databases schema, tables, indexes, views, and stored procedures
Perform data migration, transformation, and integration tasks between different database systems
Develop and maintain ETL processes to load and transform data from various sources
Work with other development groups to advise, guide and assist in their integrations
Familiarity with version control systems (e.g. GIT) and Agile development methodologies
Interact with vendor for support and consultancy
Work directly with reporting manager to ensure clear and accurate communication of current status, dependencies and estimated delivery timelines
Clearly communicate issues, risks and proposed solutions to relevant stakeholders
Coordinate the release process with business groups, operations in compliance with ITIL Change Management discipline
Communicate detailed descriptions of functionality changes and provide follow up support as required
Support QA testing
Provide direction & support to the Business Divisions for User Acceptance Testing
Utilizing Reporting tools to rapidly create, modify, refresh and update dashboards and reports
EDUCATION, EXPERIENCE & SKILLS:
DW / Business Intelligence / Cloud
5-7 years’ experience in DW/BI hands-on development and data-modelling experience
3-5 years’ experience in Databricks on Amazon Web Services cloud computing platforms
3-5 years’ experience in Reporting and Visualization tools with deep understanding of relevant architecture and framework
Development
Experience with business intelligence, data analysis, data modelling and visualization solutions on Cloud, on-premises and hybrid
Experience with Databricks platform
Experience with Python, SQL, relational database objects (Oracle and/or SQL Server) and procedural languages (PL/SQL and/or T-SQL)
Experience with Version Control systems
Web Services integration using REST/SOAP/JSON
Machine Learning/Artificial Intelligence is a plus
Exposure to SQL Server Integration Services
General
Must have excellent communication 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/written communication skills
strong interpersonal and communication skills and ability to deal effectively in a team environment
Bachelor's degree in Computer Science, or similar discipline, or equivalent education and experience
Ability to work independently with or without direction and or supervision, portray professional demeanour
Additional Beneficial Attributes/Skills:
Agile and SCRUM methodologies
Exposure generating and manipulating XML and XBRL formats
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 a companywide, 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 employees competitive compensation, vacation and health insurance benefits.
Top Skills
What We Do
Our heritage, since founding a civil law notary practice in the 1940s to establishing the Curacao International Trust Company in the 1960s, is built on challenging paradigms and delivering exceptional service within the financial and professional services industry. Today, we continue to pioneer award-winning services and technology solutions that meet ever changing markets.
A commitment to investing in people, and proprietary technologies, has resulted in our reputation as the industry’s preeminent service provider, reassuring clients that their critical administration functions are in safe hands.
Our thought leadership and ability to quickly navigate complex change means our clients can depend on us as trusted advisors to make informed decisions in response to market conditions.
Our Divisions
Citco Fund Services & Investor Relations
CFS is the global leader in services for the alternative investment industry. With over 2,000 funds under administration and net assets exceeding $840 billion, we provide full service fund administration, fund accounting, net asset value calculations, investor relations, and more.
Governance Services
Leveraging our extensive global office network Citco Governance Services provides customised solutions, including corporate and global subsidiary governance, secretarial services, financial accounting and reporting, tax and audit liaison, and market entry services.
Banking, Depositary & Custody Services
Citco Banks operate in strategic financial centres and provide Institutional and Fund of Funds clients access to the funds universe through multiple communication and online real-time global funds platforms.
Citco Technology Management
Through our eight global development centres, Citco Technology Management provides secure infrastructures and develops award-winning technology products that underpin our commitment to service excellence.
.jpeg)
