Senior Data Engineer

HexaQuEST Global
Boston, MA
Full-time

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
Related jobs
Promoted
Draper Labs
Cambridge, Massachusetts

Applicable experience in data engineering principles and tools such as databases, data modeling, SQL, Extract Transform Load (ETL), data pipelines, data warehouses/lakes, etc. The Data Retrieval, Engineering, Architecture, and Management group is seeking a Data Engineer for an opportunity to develop...

Promoted
Capital One
Cambridge, Massachusetts

Senior Software Engineer - Finance Tech Card Data Transformation. As a Capital One Senior Software Engineer in Card Data Transformation, youll have the opportunity to be on the forefront of driving a major transformation within Capital One. Share your passion for staying on top of tech trends, exper...

Promoted
Money Fit by DRS
Boston, Massachusetts

As a Senior Software Engineer - Data at Vendelux, you will work on improving the quality, quantity, resilience, and processing speed of our most precious asset - our data. You will build new and improve existing data pipelines, incorporate new machine learning models, and help integrate new data sou...

Promoted
Hexagon AB
Burlington, Massachusetts

Collaborate on the data-related software processes and functions such as ETL processes, data management, ML algorithms, AI data models, etc. You are a passionate, expert data engineer and have a proven track record in delivering data analytics solutions using AI models and pipelines and ML algorithm...

Promoted
DaVita Inc.
Boston, Massachusetts
Remote

May create and maintain optimal data pipeline architecture from various databases that include SQL, Oracle DB, Teradata, Bigdata, etc. The Senior Software Engineer is responsible for the development and maintenance of data processes and applications designed to integrate various business systems, th...

Promoted
Broad Institute of MIT and Harvard
Cambridge, Massachusetts

Deep data architecture experience developing reference architectures, data flows and data integration, and data quality solutions designs appropriate for near real-time data needs in both operational and analytic data environments. Experience in working with product managers, subject matter experts ...

US012 Marsh & McLennan Agency LLC
Boston, Massachusetts

As a Senior Data Engineer on the MMA National IT Data and Analytics Team, we will count on you to develop and maintain scalable data pipelines, enhance data models, and provide subject matter expertise in data acquisition and consumption pipelines on Azure, Databricks and Confluent. In-depth underst...

Syrinx
Needham, Massachusetts

Experience with relational databases like MySQL, MariaDB and Postgres. ...

ezCater
Boston, Massachusetts
Remote

We are hiring a Senior Data Engineer to join our expanding team in solving complex data and platform challenges to accelerate our growing business. Are you passionate about data? How about leveraging data to drive meaningful impact across a fast growing two-sided marketplace? Have opinions on how to...

CloudZero
Boston, Massachusetts
Remote

We're looking for a senior software engineer to join our dynamic team that specializes in gathering billing data from a variety of cloud service providers. At CloudZero, we believe every engineering decision is a buying decision, yet the cost conversation often bypasses the engineers who drive those...