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 option
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.
30+ days ago