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
UMass President's Office
Boston, Massachusetts

The Senior Data Engineer is a key contributor in the EDA team, providing expertise in modeling data structures and designing, building, and optimizing data mappings. Data services such as the Enterprise Data Warehouse, Data Lake, and related data integrations. They are experienced in multiple data m...

Promoted
Capital One
Cambridge, Massachusetts

Senior Data Engineer, Finance Tech Team. As a Capital One Senior Data Engineer, youll have the opportunity to be on the forefront of driving a major transformation within Capital One. Utilize programming languages like Java, Scala, Python and Open Source RDBMS and NoSQL databases and Cloud based dat...

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
CGI
Burlington, Massachusetts

We are seeking a highly motivated and dynamic Senior QA Engineer-K2View Test Data Management to join our growing team. Creating consistent and repeatable processes to support multiple functions, such as identifying and masking test data for different applications and refreshing/updating test data as...

Promoted
MilliporeSigma
Burlington, Massachusetts

Join our Life Science Analytics Center of Excellence (ACE) as a Front-end Software Engineer - Data & Analytics Application Development, where you'll work with a global team of analytics experts on scalable use cases and data products. As a front-end software engineer, you will utilize your exper...

State Street
Burlington, Massachusetts

Data Engineering specializing in modern data management, you will be at the forefront of our efforts to transition our data ecosystem to a more efficient and modern platform. If you're an experienced Data Engineering with a track record of successful large scale Data projects and want to play a key ...

Motion Recruitment
Newton, Massachusetts

We are working with a software company based in Newton, MA looking to add a Senior Data Engineer to their team. Solid understanding of data modeling, data warehousing, and data governance. You will work closely with data science and analytics teams to ensure the smooth flow of data, contributing to ...

Circle
Boston, Massachusetts

Experience with: Building Docker images and deploying containers in Kubernetes clusters; Any modern CI/CD platform with seeminglyplex gates and workflows; Blue-Green, Canary, and A/B Testing deployment strategies; Distributed blockchain systems, running and maintaining blockchain full nodes; Databas...

Motion Recruitment
Boston, Massachusetts

You will play a critical role on the Data Team, working closely with Data Scientists, Analysts, and Software Engineers to develop new platforms to store and process the massive amounts of customer data they receive to give actionable insights to improve the customer experience. Collaborate with data...