Data Warehouse Architect

2 days ago

Boston, Lincolnshire, United Kingdom Zenith services Full time

Job Title: Data Warehouse Specialist

Job 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 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, 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-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)

About Us:

Zenith Services is a leading provider of data solutions, and we are committed to delivering high-quality software products to our clients. As a Data Warehouse Specialist, you will be part of a dynamic team that is passionate about data and technology.

  • Data Warehouse Architect

    6 days ago

    Boston, Lincolnshire, United Kingdom Zenith services Full time

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

  • Data Warehouse Architect

    7 days ago

    Boston, Lincolnshire, United Kingdom Zenith services Full time

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

  • Data Warehouse Architect

    3 days ago

    Boston, Lincolnshire, United Kingdom Zenith services Full time

    About 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 time

    About 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 Solution Architect

    6 days ago

    Boston, Lincolnshire, United Kingdom SmartIPlace Full time

    Job 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

    7 days ago

    Boston, Lincolnshire, United Kingdom SmartIPlace Full time

    Job 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 time

    Job 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

    6 days ago

    Boston, Lincolnshire, United Kingdom SmartIPlace Full time

    Job 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 Expertise

    15 minutes ago

    Boston, Lincolnshire, United Kingdom BN Associates Inc Full time

    Role: Senior Data Architect for BFSI ProjectsLocation: Remote or On-SiteContract Duration: 6 MonthsCompany: BN Associates IncCompensation: $70/hour C2CJob DescriptionKey Responsibilities:Configure IDMC/CDGC target environment for optimal performance.Define organizations and roles with segregation by business teams and permissions setup according to best...

  • Data Architect with BFSI Experience

    3 days ago

    Boston, Lincolnshire, United Kingdom BN Associates Inc Full time

    Job 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 time

    Job 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

    6 days ago

    Boston, Lincolnshire, United Kingdom BN Associates Inc Full time

    BN 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

    3 weeks ago

    Boston, Lincolnshire, United Kingdom BN Associates Inc Full time

    BN 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 time

    Job 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

    2 days ago

    Boston, Lincolnshire, United Kingdom BN Associates Inc Full time

    Job 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

    1 day ago

    Boston, Lincolnshire, United Kingdom DcTek Inc Full time

    About 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

    1 day ago

    Boston, Lincolnshire, United Kingdom DcTek Inc Full time

    About 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

    2 days ago

    Boston, Lincolnshire, United Kingdom SmartIPlace Full time

    Job 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 time

    Job 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 time

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