Job Description
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. 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.
Responsibilities
About the Role:
Databricks and Python Developer with a 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 banking or finance sector is desirable.
The ideal candidate will have Databricks on AWS development and/or support experience with the ability to adapt these skills to new environments. This position will collaborate with business units and the technology group. Occasional travel may be required.
Duties include
* Analysis, design, development, support, and maintenance of data warehouses, data lakes, and lakehouse infrastructures.
* Technical expertise on data pipelines and ETL processes.
* Solid understanding of SQL and data modeling.
* Hands-on experience with Databricks on AWS cloud solutions.
* In-depth knowledge of Databricks ETL, orchestration, notebook development, and job scheduling.
* Collaborate with cross-functional teams to gather, document, analyze, and implement requirements.
* Develop and maintain data pipelines harvesting data from systems of record to create data products.
* Create and optimize relational database schemas, tables, indexes, views, and stored procedures.
* Perform data migration, transformation, and integration tasks between different database systems.
* Develop and maintain ETL processes for data loading and transformation from various sources.
* Guide and assist other development groups in their integrations.
* Familiarity with version control systems (e.g., GIT) and Agile methodologies.
* Interact with vendors for support and consultancy.
* Communicate with reporting managers regarding project status, dependencies, and timelines.
* Clearly communicate issues, risks, and solutions to stakeholders.
* Coordinate release processes in compliance with ITIL Change Management.
* Support QA testing and user acceptance testing.
* Utilize reporting tools to create, modify, and update dashboards and reports.
Qualifications
Education, Experience & Skills:
Data Warehousing / Business Intelligence / Cloud
* 5-7 years’ experience in data warehouse and BI development and data modeling.
* 3-5 years’ experience with Databricks on AWS cloud.
* 3-5 years’ experience with reporting and visualization tools, with understanding of relevant architecture.
Development
* Experience with BI, data analysis, data modeling, and visualization solutions on Cloud, on-premises, and hybrid environments.
* Experience with Databricks platform.
* Proficiency in Python, SQL, relational databases (Postgres, Oracle, SQL Server), and procedural languages (PL/pgSQL, PL/SQL, T-SQL).
* Experience with version control systems.
* Web services integration using REST/SOAP/JSON.
* Machine Learning/AI experience is a plus.
* Exposure to SQL Server Integration Services is desirable.
General
* Excellent communication skills, capable of presenting diagnostics and troubleshooting steps to varied audiences.
* Strong listening, analytical, and interpersonal skills.
* Bachelor's degree in Computer Science or similar discipline, or equivalent experience.
* Ability to work independently and professionally.
Additional Beneficial Attributes/Skills
* Agile and SCRUM methodologies.
* Experience with XML and XBRL formats.
* Experience in the financial industry, particularly hedge funds or financial systems.
This challenging role offers exposure to both business and technical teams across Citco, providing an opportunity to enhance data analysis, BI, and visualization skills while delivering a state-of-the-art reporting solution used internally and externally. Citco offers a friendly, fast-paced environment with competitive compensation, vacation, and health benefits.
#J-18808-Ljbffr