Data Engineer IV

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.