Search jobs > Boston, MA > Data warehouse specialist

Data Warehouse Specialist

Zenith Services Inc.
Boston, MA, United States
Full-time

Role Summary & Role Description

Candidate will play a crucial role in ensuring the quality and reliability of our software products, with a focus on developing Azure-based applications, data warehouse and ETL basic end systems.

Proficiency in Data Warehousing and Snowflake is essential for this role. Candidate must have minimum of 8 years of relevant experience in Data Warehousing and Database application development.

Candidate must have hands on experience in Snowflake and Azure. Analyze, Design and Code snowflake objects and views. Create Database Views / materialized views, Indexes, Partitions.

Experience in Shell scripting and Autosys / Convoy-M / Cron scheduling, Ability to communicate with Business users, understand and Analyze requirements and Use Cases.

Experience working in Agile Teams. Proven problem solving, communication, interpersonal and analytical skills. Ability to work both independently as well as within a team.

Core / Must have skills

Good knowledge in Data Warehouse concepts and different schema types like Star and Snowflake Strong experience in writing complex queries, performance tuning, query optimization and debugging.

Minimum 4 years working experience in Snowflake and good knowledge on Snowpipe, DBT Experience in working with Snowflake.

Hands-on experience in bulk loading and unloading data, Snowflake tables using COPY command Handling large and complex data sets like JSON, ORC, PARQUET CSV files from various sources like AWS S3.

TASK. Snowpipe creation for scheduling / Automate Snowflake jobs good exposure in Snowflake Cloud Architecture, Snow SQL and SNOWPIPE for continuous data loading.

Good communication skills, problem solving skills and ability to analyses quickly and come-up with an efficient industry standard solution for a given problem

Good to have skills

Good knowledge on Oracle database and Proficient in SQL Performance tuning. Good knowledge on Bigdata and Sped (Good knowledge on Databricks)

10 days ago
Related jobs
Promoted
Zenith Services Inc.
Boston, Massachusetts

Candidate will play a crucial role in ensuring the quality and reliability of our software products, with a focus on developing Azure-based applications, data warehouse and ETL basic end systems. Candidate must have minimum of 8 years of relevant experience in Data Warehousing and Database applicati...

Zenith services
Boston, Massachusetts

Job Description </p> <p>Role Summary & Role Description</p> <p> </p> <p>Candidate will play a crucial role in ensuring the quality and reliability of our software products, with a focus on developing Azure-based applications, data warehouse and ETL b...

Promoted
Dana-Farber Cancer Institute
Boston, Massachusetts

The Research Data Specialist will support the Cohort Studies under the auspices of the Principal Investigators, Senior Director, and Associate Director, in the areas of clinical data collection and collation of biospecimens in the Department of Breast Oncology. Entering the clinical data into the da...

Promoted
LifeCanvas Technologies Inc.
Cambridge, Massachusetts

As a Junior Data Analyst, you will be part of the data analytics team, focusing on the analysis of 3D fluorescence microscopy images of biological tissues. Run and troubleshoot analyses for Contract Research data to ensure timely and high-quality completion of projects. Proficiency in Python for dat...

Promoted
Healthy Baby Essentials
Walpole, Massachusetts

Unloading delivers to warehouse. ...

Promoted
Electric Supply Center Career Page
Woburn, Massachusetts

Material Handler 1 is responsible for picking, selecting, checking and ensuring the accurate transportation of materials, stock, merchandise, supplies, and other finished products to designated locations including preparation for shipment. In general Material Handlers are broken into two groups Chec...

Promoted
Houghton Chemical Corporation
Boston, Massachusetts

Tired of the same job? Ready to raise your game?.Houghton Chemical Corporation is a manufacturer of Automotive Antifreeze and Heat Transfer Fluids for HVAC Systems.Houghton Chemical is Regional Manufacturer of the Year in Massachusetts.Allston, MA Civic Association Community Lifetime Achievement win...

Promoted
firstPRO, Inc
Billerica, Massachusetts

PRO is now accepting resumes for a Data Entry Specialist in Billerica, MA. They need someone to work from a list of Nova products, find the product within inventory, weigh the product, and enter that data into an MS Excel spreadsheet, an SAP system, and/or a Master Control Database; this work will a...

Promoted
RCM Technologies
Westwood, Massachusetts

Our client is seeking a passionate and detail-oriented Oracle Fusion Cloud EDI Specialist to join our collaborative IT team. You'll play a pivotal role in ensuring efficient and secure electronic data interchange (EDI) with our trading partners, streamlining our Client's business processes. ...

Promoted
Blue Capital Reinsurance Holdings Ltd.
Boston, Massachusetts

The ideal candidate for this role will demonstrate a diverse skill set, encompassing proficiency in mining and manipulating extensive and diverse datasets, mastery of data software and visualization tools, and a knack for crafting compelling narratives from data insights. Ensuring adherence to ethic...