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 work in the community.
A career at Citco isn't just a job - it's an opportunity to excel in an environment that supports your personal and professional development.
Responsibilities
About the Role:
We are seeking a Databricks and Python Developer with a strong background in AWS. This role involves development and technical support, emphasizing customer service, technical expertise, and timeliness. The primary goal is to develop and support Bank data solutions.
Experience in Machine Learning/AI projects and the Banking or Finance sector is a plus.
The ideal candidate will have experience with Databricks on AWS, with the ability to adapt skills to new environments. The role involves collaboration with Business units and the Technology Group, with occasional travel required.
Duties include:
* Analysis, design, development, support, and maintenance of Data Warehousing (DW), Data Lake, 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.
* 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.
* Advise 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 the reporting manager about project status, dependencies, and delivery timelines.
* Communicate issues, risks, and solutions to stakeholders.
* Coordinate release processes in compliance with ITIL Change Management.
* Support QA testing and provide guidance for User Acceptance Testing.
* Utilize reporting tools to create, modify, and update dashboards and reports.
Qualifications
Education, Experience & Skills:
* 5-7 years' experience in DW/BI development and data modeling.
* 3-5 years' experience with Databricks on AWS cloud.
* 3-5 years' experience with reporting and visualization tools.
Development skills include:
* Experience with BI, data analysis, data modeling, and visualization solutions on Cloud, on-premises, and hybrid environments.
* Proficiency with Databricks platform, Python, SQL, relational databases (Postgres, Oracle, SQL Server), and procedural languages (PL/pgSQL, PL/SQL, T-SQL).
* Experience with version control systems and web services (REST/SOAP/JSON).
* Knowledge of Machine Learning/AI is a plus.
* Exposure to SQL Server Integration Services.
General skills include:
* Excellent communication and presentation skills for technical and business audiences.
* Strong analytical and listening skills.
* Ability to work independently and professionally.
Additional beneficial skills:
* Experience with Agile/SCRUM.
* Experience manipulating XML and XBRL formats.
* Financial systems or hedge fund industry experience.
This role offers exposure to both business and technical teams, providing opportunities to enhance data analysis, BI, and visualization skills, while delivering cutting-edge reporting solutions. Citco offers competitive compensation, vacation, and health benefits.
#J-18808-Ljbffr