Financial or Banking experience

Must have

- In-depth proven experience with complex SQL data manipulation

- Proven Java experience

- Working knowledge of data warehouse

- XML, XLSX, JSON, CSV and other data source experience

Nice to have

- - Powershell experience

- - Sailpoint experience with bean shell knowledge

Responsibilities:

- Develop automated data pipelines and data stores from multiple systems including designing, implementing, testing, debugging, and deploying.

- Develop complex SQL queries, stored procedures, and scripts for data manipulation and retrieval.

- Build metadata-driven solutions that are reusable and highly configurable.

- Optimize data warehouse performance through effective data modeling, partitioning, and indexing strategies.

- Spearhead the design and implementation of ETL processes.

- Collaborate with various system owner to understand data requirements and deliver precise reporting and analytical solutions.

- Ensure data integrity and security within the data environment, complying with industry regulations and standards.

- Work on an agile team to quickly iterate and release solutions.

- Research and put forward new recommendations to create, automate and improve processes

- Provide technical expertise and support for warehouse to internal teams, including troubleshooting and resolving issues.

- Stay up to date with data features and updates, continuously improving and expanding our data warehouse capabilities.

- Develop and maintain documentation for processes, systems, and procedures.

- Design, develop, and support a data lake environment, ensuring efficient data storage, retrieval, and processing.

- Implement data governance and data quality frameworks to ensure the accuracy and reliability of data within the environment.

- Integrate warehouse with other data sources and platforms, including both cloud-based and on-premises systems.

Robertson & Company Ltd.

New Jobs