Search jobs > Boston, MA > Data specialist

Data Warehouse Specialist

Zenith
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)

5 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...

Promoted
Zenith
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 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
Boston Consulting Group
Stoneham, Massachusetts

We are responsible for setting the standards and guardrails for BCG’s internal data architecture, data pipeline, governance, integration, and security framework. The BCG Data Team is an integral part of BCG’s global operations. The team is responsible for developing and maintaining the BCG internal ...

Promoted
Boston Metal
Woburn, Massachusetts

Warehouse Worker Job Description. You will also be responsible for the area organization and maintenance of the warehouse as well as enforcing all necessary safety processes and procedures required for a safe warehouse operation. Maintain a clean facility, including floor cleaning, dock door mainten...

Promoted
Ideaboxpro
Boston, Massachusetts

As a Warehouse Worker at Ideaboxpro, you will play a crucial role in the daily operations of our warehouse. If you're ready to contribute to a dynamic team and play a key role in our warehouse operations, apply now to join Ideaboxpro as a Warehouse Worker! Help us maintain efficiency and excelle...

Promoted
Morgan Staffing Services
Woburn, Massachusetts

Organize warehouse space (keep warehouse clean). Looking for a Inventory Specialist to be a part of our team in Woburn who is responsible for fulfilling the logistics behind receiving processing and storing inventory according to purchase orders and warehouse policy. High knowledge of 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...