Sr. Data Engineer

Job Description -

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.

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:

Bachelor’s degree in computer science, engineering, or Management Information Systems, or related IT field.

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.