Senior Snowflake Data Architect

4 weeks ago

Trenton, New Jersey, United States Core Software Technologies Inc. Full time
About the Role

We are seeking a highly skilled Senior Snowflake Developer to join our team at Core Software Technologies Inc. As a key member of our data engineering team, you will be responsible for designing, implementing, and optimizing data solutions using the Snowflake cloud data platform.

Key Responsibilities
  • Data Architecture: Collaborate with data architects to design and develop Snowflake data models and schemas, ensuring efficient data storage and processing.
  • Data Integration: Develop ETL processes to ingest data from various sources into Snowflake, ensuring data integration processes are efficient, reliable, and scalable.
  • Performance Optimization: Optimize query performance by creating and maintaining appropriate indexes, materialized views, and clustering keys, and identify and resolve performance bottlenecks in data processing.
  • SQL Development: Write complex SQL queries, stored procedures, and user-defined functions (UDFs) to support data analytics and reporting needs, ensuring SQL code follows best practices for readability and performance.
  • Security and Access Control: Implement and manage security measures, including role-based access control (RBAC) and data encryption, to protect sensitive data, and audit and monitor data access and user activities.
  • Data Quality Assurance: Define and implement data quality checks and validation processes to maintain data accuracy, and establish data quality rules and alerts to proactively identify issues.
  • Documentation: Create and maintain technical documentation for data models, ETL processes, and data dictionaries, and document best practices, standards, and guidelines for Snowflake development.
  • Version Control and Deployment: Use version control systems (e.g., Git) for managing Snowflake SQL scripts and objects, and coordinate the deployment of changes to Snowflake environments.
  • Monitoring and Alerts: Set up monitoring and alerting for Snowflake environments to proactively detect and respond to issues, and troubleshoot and resolve incidents related to data processing and performance.
  • Backup and Recovery: Implement backup and recovery strategies to ensure data integrity and availability, and develop and test data recovery procedures.
  • Collaboration: Collaborate with data engineers, data scientists, and business analysts to understand data requirements and provide data solutions, and work with cross-functional teams to support data-related projects and initiatives.
Qualifications
  • Bachelor's or master's degree in computer science, data engineering, or a related field.
  • 7+ years of experience as a Snowflake developer or data engineer with a focus on data warehousing and ETL.
  • Snowflake certification(s) is a plus.
  • Strong SQL skills and proficiency in data modeling and database design.
  • Knowledge of cloud data warehousing concepts and best practices.
  • Familiarity with data integration tools and technologies.
  • Solid understanding of data governance, data security, and compliance requirements.
  • Experience with version control systems and deployment processes.
  • Excellent problem-solving and troubleshooting skills.
  • Strong communication and collaboration abilities.
  • Ability to work in an Agile or iterative development environment.

  • Senior Integration and Solution Architect

    4 weeks ago

    Trenton, New Jersey, United States Core Software Technologies Inc. Full time

    Job Title: Senior Integration and Solution ArchitectAt Core Software Technologies Inc., we are seeking a highly skilled Senior Integration and Solution Architect to join our team. As a key member of our organization, you will play a crucial role in designing and implementing integrated technology solutions that meet the evolving business needs of our...

  • Senior PEGA Systems Architect

    4 weeks ago

    Trenton, New Jersey, United States Hudson Data Full time

    Job Title:PEGA Senior System ArchitectJob Summary:The Hudson Data team is seeking a highly skilled PEGA Senior System Architect to join our team. As a key member of our IT department, you will be responsible for evaluating existing systems and user needs to analyze, design, recommend, and implement information system changes.Key Responsibilities:Evaluate...

  • PEGA Senior System Architect Position

    3 weeks ago

    Trenton, New Jersey, United States Hudson Data Full time

    Job Title:PEGA Senior System Architect PositionJob Summary:Hudson Data is seeking a highly skilled PEGA Senior System Architect to join our team. The ideal candidate will have a strong background in PEGA and experience in designing, implementing, and supporting large-scale business-centric applications.Key Responsibilities: Collaborate with the business...

  • Senior Integration and Solution Architect

    4 weeks ago

    Trenton, New Jersey, United States Core Software Technologies Inc. Full time

    Job DescriptionAs a Senior Integration and Solution Architect at Core Software Technologies Inc., you will play a crucial role in designing and implementing a cohesive technology ecosystem for our organization. Your expertise in integrating platforms such as Salesforce, Snowflake, AWS services, ETL (Extract, Transform, Load) processes, and Business Rules...

  • Senior PEGA Systems Architect

    4 weeks ago

    Trenton, New Jersey, United States Hudson Data Full time

    Job Title:PEGA Senior System ArchitectLocation:Trenton, NJ (Hybrid)Duration:Long TermDescription:The PEGA Senior Systems Architect evaluates existing systems and/or user needs to analyze, design, recommend, and implement information system changes. Local Candidates Only - Please submit those who currently live within a commutable distance to Trenton only.The...

  • Senior Lead Technical Architect

    4 weeks ago

    Trenton, New Jersey, United States Core Software Technologies Inc. Full time

    Job DescriptionWe are seeking a highly skilled and experienced Senior Lead Technical Architect to join our team at Core Software Technologies Inc. The ideal candidate will have significant expertise in leading the technical design and implementation of critical projects, with a strong focus on scalability, reliability, and security.Key Responsibilities:Lead...

  • Senior Database Architect

    4 weeks ago

    Trenton, New Jersey, United States DEW Softech, Inc Full time

    Job Title: Senior Database ArchitectWe are seeking a Senior Database Architect to lead our database team and design and develop secure data lake systems. The ideal candidate will have strong experience with ETL and migrations, predominantly with MS SQL Server, with some Oracle background.Key Responsibilities:Maintain and enhance database designs and...

  • Enterprise Data Architect

    3 weeks ago

    Trenton, New Jersey, United States Rose International Full time

    Job Title: Enterprise Data ArchitectJob Description:We are seeking a highly skilled Enterprise Data Architect to join our team at Rose International. As an Enterprise Data Architect, you will be responsible for designing and implementing data architecture frameworks, standards, and data modeling activities. You will work closely with our IT management and...

  • Enterprise Data Architect

    3 weeks ago

    Trenton, New Jersey, United States Rose International Full time

    Job Title: Enterprise Data ArchitectJob Summary:Rose International is seeking an experienced Enterprise Data Architect to design and implement data architecture frameworks, standards, and data modeling activities. The ideal candidate will have a deep understanding of AWS services and cloud infrastructure.Key Responsibilities:Design and implement data...

  • Enterprise Data Architect

    4 weeks ago

    Trenton, New Jersey, United States Comprehensive Resources INC Full time

    Job Title: Sr Enterprise Data ArchitectComprehensive Resources INC is seeking a highly skilled Sr Enterprise Data Architect to join our team. As a key member of our data architecture team, you will be responsible for designing and implementing data architecture frameworks, data pipelines, and data modeling activities.Key Responsibilities:Design and implement...

  • Enterprise Data Architect

    3 weeks ago

    Trenton, New Jersey, United States Crescens Full time

    Job Title: Enterprise Data ArchitectAt Crescens, we are seeking a highly skilled Enterprise Data Architect to join our team. The ideal candidate will have a deep understanding of data architecture and be able to design and implement data management frameworks that meet departmental needs and industry requirements.Key Responsibilities:Design and implement...

  • Enterprise Data Architect

    4 weeks ago

    Trenton, New Jersey, United States Rose International Full time

    Job Title: Enterprise Data ArchitectJob Summary: We are seeking an experienced Enterprise Data Architect to join our team at Rose International. The successful candidate will be responsible for designing and implementing data architecture frameworks, standards, and data modeling activities.Key Responsibilities:Develop and maintain conceptual, logical, and...

  • Enterprise Data Architect

    4 weeks ago

    Trenton, New Jersey, United States InnovitUSA Full time

    Job DescriptionEnterprise Data ArchitectJob SummaryInnovitUSA is seeking a highly skilled Enterprise Data Architect to design and implement a comprehensive data management framework. The ideal candidate will have 15+ years of experience in data architecture, data modeling, and data analysis, with a strong focus on AWS cloud architecture.Key...

  • Enterprise Data Architect

    3 weeks ago

    Trenton, New Jersey, United States Software Technology Inc. Full time

    Job Title: Enterprise Data ArchitectJob Summary: We are seeking an experienced Enterprise Data Architect to join our team at Software Technology Inc. The successful candidate will be responsible for designing and implementing data architecture frameworks, standards, and data modeling activities.Key Responsibilities:Design and implement data architecture...

  • Data Enterprise Architect

    3 weeks ago

    Trenton, New Jersey, United States CAI Full time

    Job SummaryThe Sr. Enterprise Data Architect will be responsible for designing and implementing data architecture frameworks, standards, and data modeling activities. This includes defining conceptual, logical, physical, analytical, and canonical models, as well as leveraging AWS experience.Key Responsibilities Design the blueprint for client data management...

  • Enterprise Data Architect

    4 weeks ago

    Trenton, New Jersey, United States Software Technology Inc Full time

    Job DescriptionWe are seeking a highly skilled Enterprise Data Architect to join our team at Software Technology Inc. The ideal candidate will have a deep understanding of data architecture frameworks, standards, and data modeling activities.Key Responsibilities:Design and implement data architecture frameworks and standardsDevelop conceptual, logical, and...

  • Enterprise Data Architect

    4 weeks ago

    Trenton, New Jersey, United States Randstad Full time

    Job Summary:Randstad Digital is seeking a highly experienced Enterprise Data Architect to lead the development of data architecture frameworks, standards, and data modeling activities. The ideal candidate will have 15 years of hands-on experience with AWS Architecture and a strong background in data analysis, ETL, and cloud formation.Key Responsibilities:...

  • Senior Manager, Solutions Architects

    4 weeks ago

    Trenton, New Jersey, United States Infoblox Full time

    Exciting Opportunity at InfobloxWe are seeking a highly skilled and experienced Senior Manager, Solutions Architects to lead our Mid-Atlantic Solutions Architect team. Reporting to the Director, Solutions Architect - East, this role will be responsible for managing a high-performance team of technical pre-sales solutions architects.The ideal candidate will...

  • Senior Network Architect

    3 weeks ago

    Trenton, New Jersey, United States NJM Insurance Group Full time

    The Senior Network Architect is responsible for the ongoing design, maintenance, and support of NJM's Network Infrastructure.The successful candidate will lead efforts with other members of the IT infrastructure and operations teams to deliver reliable network services.Key Responsibilities:Network Operations and SupportInstall, configure, and maintain...

  • Senior Network Architect

    4 weeks ago

    Trenton, New Jersey, United States TEKsystems Full time

    Job OverviewAs a Senior Network Architect, you will be responsible for designing and implementing network infrastructure solutions that meet the needs of our clients. This includes evaluating products, parts, and processes for cost efficiency and reliability, and working with other members of the engineering staff to ensure that production is completed in a...