Junior Data Engineer

Junior Data Engineer

HYBRID - Clark Pampanga

Citco is a global leader in fund services corporate governance and related asset services with staff across 80 offices worldwide. With more than $1 trillion in assets under administration we deliver end-to-end solutions and exceptional service to meet our clients needs.

For more information about Citco please

About the Team & Business Line:

Proprietary software solutions and innovation are at the core of what differentiates Citco in the alternative investment space. Through our network of global development centers Citco invests heavily in technology development security and infrastructure to ensure our clients continue to receive award-winning products that underpin our commitment to service excellence.

As a core member of our Innovation Development team you will work with dedicated professionals to ensure our clients maintain access to their critical information assets while keeping Citco ahead of industry trends.

Your Role:

• Design develop and maintain ETL/ELT pipelines using Databricks Delta Lake and Apache Spark
• Implement data workflows using Databricks notebooks and jobs
• Create and optimize data models for both batch and streaming data processing
• Develop and maintain data quality frameworks and monitoring systems
• Collaborate with cross-functional teams to understand data requirements and implement solutions
• Write efficient SQL queries and optimize performance of existing queries
• Implement data security and governance practices
• Build and maintain documentation for data processes and architectures i.e medallion architecture
• Explore and apply new and upcoming features of the Databricks or other tools

About You:

Experience and Technical Skills

• 1 2 years of specialized hands-on experience in data engineering.
• In-depth knowledge of SQL Python PySpark and/or Scala preferrable within the Databricks environment.
• Experience in using AWS (AWS Glue S3 Lambda)
• Experience in using different ETL tools.
• Experience in using Databricks preferred but not required.
• Strong expertise integrating Databricks with AWS data storage and services like S3 Athena and Glue.
• Demonstrable experience and skills in real-time and batch data processing using Databricks with problem-solving Databricks challenges preferrable
• Experience with PL/SQL programming creating SQL scripts and writing stored procedures
• Ability to work in a fast paced complex IT environment
• Excellent oral and written communications skills required
• Strong project and time management skills with an ability to set and maintain priorities
• Strong analytic problem solving business judgment and organization skills required
• Knowledgeable in BI Tools such as Power BI and/or QLIK
• Hybrid set-up
• Mid shift schedule

Education

• Bachelors degree or equivalent experience
• Demonstrated commitment to continuous improvement and training

Desired skills and expertise

• Databricks Data Science/Engineer certifications
• PowerBI Predictive Analytics AI/ML Medallion architecture

Our Benefits

Your wellbeing is of paramount importance to us and central to our success. We provide a range of benefits training and education support and flexible working arrangements to help you achieve success in your career while balancing personal needs. Ask us about specific benefits in your location.

We recognize diversity as a source of organizational pride and strength. We have made it a priority to reflect our nations evolving diversity in the people we hire and the culture we create in our organization.

Citco welcomes and encourages applications from people with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the selection.