Senior Data Engineer

The Senior Data Engineer (SDE) will lead the new Snowflake & Informatica implementation of the agency. The individual in this role will collaborate with business users and other engineers to build a new data warehouse solution using Snowflake. The SDE will help with the overall Data Strategy, including 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 supporting data transformation, data structures, metadata, dependency, and workload management.
• Create and contribute to the automation of essential processes related to infrastructure solution deployment, creating repeatable and robust deployments.
• Perform advanced data transformation activities using Informatica, PL/SQL, Oracle Database tuning, SQL tuning, and Informatica Server administration.
• Provide hands-on solutions, including platform ownership and supporting essential 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 an essential role in troubleshooting 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
• Data migration methods of on-prem to cloud data solutions, including ELT/ETL Tools and concepts
• Working with Batch and Stream data SQL, preferable Snowflake SQL Massively Parallel Processing (MPP) Analytical Datastores Education Requirements
• Bachelor’s degree in computer science, engineering, or Management Information Systems, or related IT field.