Senior 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 option

QUALIFICATIONS :

Snowflake Data Solutions, hands-on Data warehousing methodologies and modelling techniques