Senior Data Engineer

The Senior Data Engineer (SDE) will spearhead the agency's implementation of the new Snowflake & Informatica. The individual in this position will work in collaboration with business users and other engineers to develop a new data warehouse solution employing Snowflake. The SDE will assist with the overall Data Strategy, encompassing infrastructure, software, utilities/tools, Public Cloud Solutions, and Business Intelligence Solutions for the organization. Requirements DETAILED LIST OF JOB DUTIES AND RESPONSIBILITIES: - Provide an understanding of Snowflake Data Warehouse, Data Movement, Data Curation, Data Staging, and Transformation best practices. - Build processes to support data transformation, data structures, metadata, dependency, and workload management. - Contribute to and create the automation of essential processes related to infrastructure solution deployment, crafting repeatable and robust deployments. - Perform advanced data transformation activities utilizing Informatica, PL/SQL, Oracle Database tuning, SQL tuning, and Informatica Server administration. - Provide hands-on solutions, including platform ownership and supporting vital platform capabilities. - Responsible for Performance and performance tuning, Data Quality, Protection, and Availability. - Responsible for developing and implementing solutions related to Snowflake and preparing data for Business Intelligence. - Fully document all solution work, including designs and configurations. - Play a vital role in resolving data system problems and providing viable solution options. QUALIFICATIONS: - Minimum eight years of experience in IT with a focus on Enterprise Data Solutions - 5 years of experience in Snowflake Data Solutions, hands-on Data warehousing methodologies and modelling techniques - Experience in data migration methods from on-prem to cloud data solutions, including ELT/ETL Tools and concepts - Experience working with Batch and Stream data SQL, preferably Snowflake SQL Massively Parallel Processing (MPP) Analytical Datastores Education Requirements - Bachelor’s degree in computer science, engineering, or Management Information Systems, or a related IT field.