Data Warehouse Architect
6 days ago
**Job Summary**
Zenith Services is seeking a highly skilled Data Warehouse Specialist to join our team. As a key member of our data analytics team, you 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 backend systems.
**Key Responsibilities**
- Analyze, design, and code Snowflake objects and views
- Create database views, materialized views, indexes, and partitions
- Experience in shell scripting and Autosys/ConvoyM/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 and 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, hand-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
- 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 analyze quickly and come up with an efficient industry-standard solution for a given problem
**Nice-to-Have Skills**
- Good knowledge on Oracle database and proficient in SQL performance tuning
- Good knowledge on Big Data and Sped (good knowledge on Databricks)
-
Data Warehouse Architect
2 days ago
Boston, Lincolnshire, United Kingdom Zenith services Full timeJob Title: Data Warehouse SpecialistJob Summary:We are seeking a highly skilled Data Warehouse Specialist to join our team at Zenith Services. As a key member of our data team, you 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 backend...
-
Data Warehouse Architect
2 days ago
Boston, Lincolnshire, United Kingdom Zenith services Full timeJob Title: Data Warehouse SpecialistJob Summary:We are seeking a highly skilled Data Warehouse Specialist to join our team at Zenith Services. As a key member of our data team, you 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 backend...
-
Data Warehouse Architect
2 days ago
Boston, Lincolnshire, United Kingdom Zenith services Full timeAbout the RoleZenith Services is seeking a highly skilled Data Warehouse Specialist to join our team. As a key member of our data analytics team, you will play a crucial role in ensuring the quality and reliability of our software products.Key ResponsibilitiesDesign and develop data warehouses and ETL pipelines using Azure-based applications and...
-
Data Warehouse Architect
3 days ago
Boston, Lincolnshire, United Kingdom Zenith services Full timeAbout the RoleZenith Services is seeking a highly skilled Data Warehouse Specialist to join our team. As a key member of our data analytics team, you will play a crucial role in ensuring the quality and reliability of our software products.Key ResponsibilitiesDesign and develop data warehouses and ETL pipelines using Azure-based applications and...
-
Cloud Data Architect
7 days ago
Boston, Lincolnshire, United Kingdom SmartIPlace Full timeJob DescriptionRole: Data Solution ArchitectLocation: Boston, MADuration: 12 Months ContractVisa: USC, GC, EAD, GC, H4Interviews: VideoNote:Please read all the requirements carefully. This role has been out for a bit, but we are looking for the right candidate. We are seeking a strong fit for this position.This is for BCBS of Mass (BCBSMA). We are looking...
-
Cloud Data Architect
5 days ago
Boston, Lincolnshire, United Kingdom SmartIPlace Full timeJob DescriptionRole: Data Solution ArchitectLocation: Boston, MADuration: 12 Months ContractVisa: USC, GC, EAD, GC, H4Interviews: VideoNote:Please read all the requirements carefully. This role has been out for a bit, but we are looking for the right candidate. We are seeking a strong fit for this position.This is for BCBS of Mass (BCBSMA). We are looking...
-
Data Solution Architect
5 days ago
Boston, Lincolnshire, United Kingdom SmartIPlace Full timeJob DescriptionRole: Data Solution ArchitectLocation: Boston, MADuration: 12 Months ContractVisa: USC, GC, EAD, GC, H4Interviews: VideoNote:Please read all the requirements carefully. This role has been out for a bit, but we are looking for the right candidate. We are seeking a strong fit for this position.This is for BCBS of Mass (BCBSMA). We are looking...
-
Data Solution Architect
7 days ago
Boston, Lincolnshire, United Kingdom SmartIPlace Full timeJob DescriptionRole: Data Solution ArchitectLocation: Boston, MADuration: 12 Months ContractVisa: USC, GC, EAD, GC, H4Interviews: VideoNote:Please read all the requirements carefully. This role has been out for a bit, but we are looking for the right candidate. We are seeking a strong fit for this position.This is for BCBS of Mass (BCBSMA). We are looking...
-
Data Architect with BFSI Experience
2 days ago
Boston, Lincolnshire, United Kingdom BN Associates Inc Full timeJob Title: Data Architect with BFSI ExperienceCompany: BN Associates IncJob Type: ContractLocation: RemoteDuration: 6 MonthsRate: $70/hourJob Description:Key Responsibilities:Configure IDMC/CDGC target environment.Define organizations and roles, including segregation by business teams and permissions setup according to best practices.Implement...
-
Data Architect with BFSI Experience
3 days ago
Boston, Lincolnshire, United Kingdom BN Associates Inc Full timeJob Title: Data Architect with BFSI ExperienceCompany: BN Associates IncJob Type: ContractLocation: RemoteDuration: 6 MonthsRate: $70/hourJob Description:Key Responsibilities:Configure IDMC/CDGC target environment.Define organizations and roles, including segregation by business teams and permissions setup according to best practices.Implement...
-
Data Architect
3 weeks ago
Boston, Lincolnshire, United Kingdom BN Associates Inc Full timeBN Associates Inc. is seeking a skilled Data Architect with proven experience in the Financial Services industry.Responsibilities:Configure and manage the IDMC/CDGC target environment, ensuring optimal performance and security.Define organizational structures and roles within the system, implementing robust access controls and permissions based on best...
-
Data Architect
6 days ago
Boston, Lincolnshire, United Kingdom BN Associates Inc Full timeBN Associates Inc. is seeking a skilled Data Architect with proven experience in the Financial Services industry.Responsibilities:Configure and manage the IDMC/CDGC target environment, ensuring optimal performance and security.Define organizational structures and roles within the system, implementing robust access controls and permissions based on best...
-
Data Architect with BFSI Experience
2 days ago
Boston, Lincolnshire, United Kingdom BN Associates Inc Full timeJob Title: Data Architect with BFSI ExperienceCompany: BN Associates IncJob Type: ContractLocation: RemoteDuration: 6 MonthsRate: $70/hrJob Description:Key Responsibilities:Configure IDMC/CDGC target environment for optimal performance.Define organizations and roles, including segregation by business teams and permissions setup according to best...
-
Data Architect with BFSI Experience
1 day ago
Boston, Lincolnshire, United Kingdom BN Associates Inc Full timeJob Title: Data Architect with BFSI ExperienceCompany: BN Associates IncJob Type: ContractLocation: RemoteDuration: 6 MonthsRate: $70/hrJob Description:Key Responsibilities:Configure IDMC/CDGC target environment for optimal performance.Define organizations and roles, including segregation by business teams and permissions setup according to best...
-
Lead Data Architect
21 hours ago
Boston, Lincolnshire, United Kingdom DcTek Inc Full timeAbout the RoleWe are seeking a highly skilled Lead Data Engineer to join our team at DcTek Inc. as a key member of our Data Engineering department.Key ResponsibilitiesDesign and implement large-scale data warehousing solutions using Snowflake cloud data warehouse and AWS S3.Develop and maintain complex SQL scripts using statistical aggregate functions and...
-
Lead Data Architect
22 hours ago
Boston, Lincolnshire, United Kingdom DcTek Inc Full timeAbout the RoleWe are seeking a highly skilled Lead Data Engineer to join our team at DcTek Inc. as a key member of our Data Engineering department.Key ResponsibilitiesDesign and implement large-scale data warehousing solutions using Snowflake cloud data warehouse and AWS S3.Develop and maintain complex SQL scripts using statistical aggregate functions and...
-
Data Solution Architect
1 day ago
Boston, Lincolnshire, United Kingdom SmartIPlace Full timeJob DescriptionRole: Data Solution ArchitectLocation: Boston, MA (Hybrid role, on-site and remote work options)Duration: 12-month contractVisa: USC, GC, EAD, GC, H4Interviews: Video interviewsNote:Please read all the requirements carefully. This role is ideal for a strong Data Solution Architect with experience in cloud data platforms, particularly AWS. The...
-
Data Solution Architect
2 days ago
Boston, Lincolnshire, United Kingdom SmartIPlace Full timeJob DescriptionRole: Data Solution ArchitectLocation: Boston, MA (Hybrid role, on-site and remote work options)Duration: 12-month contractVisa: USC, GC, EAD, GC, H4Interviews: Video interviewsNote:Please read all the requirements carefully. This role is ideal for a strong Data Solution Architect with experience in cloud data platforms, particularly AWS. The...
-
Data Solution Architect
2 days ago
Boston, Lincolnshire, United Kingdom SmartIPlace Full timeAbout the RoleWe are seeking a highly skilled Data Solution Architect to join our team at SmartIPlace. As a key member of our organization, you will be responsible for designing and implementing data solutions that drive business growth and innovation.Key ResponsibilitiesDevelop and maintain overall data and analytics solutions for applications and products...
-
Data Solution Architect
2 days ago
Boston, Lincolnshire, United Kingdom SmartIPlace Full timeAbout the RoleWe are seeking a highly skilled Data Solution Architect to join our team at SmartIPlace. As a key member of our organization, you will be responsible for designing and implementing data solutions that drive business growth and innovation.Key ResponsibilitiesDevelop and maintain overall data and analytics solutions for applications and products...