HexaQuEST Global, Inc.
Senior Data Engineer
HexaQuEST Global, Inc., Boston, Massachusetts, us, 02298
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 AvailabilityResponsible for developing and implementing solutions related to Snowflake and preparing data for Business IntelligenceFully document all solution work, including designs and configurationsPlay 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 Solutions5 years of experience in:
Snowflake Data Solutions, hands-on Data warehousing methodologies and modelling techniquesData migration methods of on-prem to cloud data solutions, including ELT/ETL Tools and conceptsWorking 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.
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 AvailabilityResponsible for developing and implementing solutions related to Snowflake and preparing data for Business IntelligenceFully document all solution work, including designs and configurationsPlay 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 Solutions5 years of experience in:
Snowflake Data Solutions, hands-on Data warehousing methodologies and modelling techniquesData migration methods of on-prem to cloud data solutions, including ELT/ETL Tools and conceptsWorking 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.