Senior Data Architect

8 hours 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.

Job Description

This is a pivotal role in architecting data warehouses, data lakes, and ETL processes to enable efficient data storage, processing, and analytics for our organization. Key responsibilities include designing and implementing data solutions using Snowflake, collaborating with data architects, developing ETL processes, optimizing query performance, writing complex SQL queries, and implementing security measures.

Responsibilities
  • Data Architecture: Collaborate with data architects to design and develop Snowflake data models and schemas, create and maintain a well-structured data warehouse and data lake architecture.
  • Data Integration: Develop ETL (Extract, Transform, Load) processes to ingest data from various sources into Snowflake, ensure data integration processes are efficient, reliable, and scalable, design and implement data pipelines using Snowflake features like tasks and streams.
  • Performance Optimization: Optimize query performance by creating and maintaining appropriate indexes, materialized views, and clustering keys, 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, ensure 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, audit and monitor data access and user activities.
  • Data Quality Assurance: Define and implement data quality checks and validation processes to maintain data accuracy, establish data quality rules and alerts to proactively identify issues.
  • Documentation: Create and maintain technical documentation for data models, ETL processes, and data dictionaries, 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, 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, troubleshoot and resolve incidents related to data processing and performance.
  • Backup and Recovery: Implement backup and recovery strategies to ensure data integrity and availability, develop and test data recovery procedures.
  • Collaboration: Collaborate with data engineers, data scientists, and business analysts to understand data requirements and provide data solutions, 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.
Compensation Package

The estimated salary range for this position is $140,000 - $180,000 per annum, depending on experience and qualifications.

  • Senior Data Architect

    1 week ago

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

    About the RoleWe are seeking a highly skilled Senior Snowflake Developer to join our team at Core Software Technologies Inc. This role plays a pivotal part in architecting data warehouses, data lakes, and ETL processes to enable efficient data storage, processing, and analytics for the organization.

  • Senior Integration and Solution Architect

    2 weeks ago

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

    Job Title: Senior Integration and Solution ArchitectAbout the Role:We are seeking a highly skilled Senior Integration and Solution Architect to join our team at Core Software Technologies Inc. As a key member of our organization, you will be responsible for designing and implementing integrated technology solutions that meet the evolving business needs of...

  • Cloud Data Solutions Architect

    1 week ago

    Trenton, New Jersey, United States ZMAP Strategies Full time

    Job Title: Cloud Data Solutions ArchitectWe are seeking an experienced Cloud Data Solutions Architect to lead the development and optimization of cloud-based business intelligence and advanced analytics solutions. This role will focus on enhancing data analytics capabilities, driving innovative solutions, and managing complex data integrations.The ideal...

  • Senior Pega System Architect

    2 weeks ago

    Trenton, New Jersey, United States Sunrise Systems Inc Full time

    Job Title: Senior Pega System ArchitectOverview: We are seeking a highly skilled Senior Pega System Architect to join our team at Sunrise Systems Inc. This is an exciting opportunity for a seasoned professional to utilize their expertise in designing and implementing innovative solutions using Pega technology.About the Role: As a Senior Pega System...

  • Senior Business Systems Architect

    2 weeks ago

    Trenton, New Jersey, United States HSK Technologies Inc Full time

    About the RoleWe are seeking a highly experienced Senior Business Systems Architect to lead our Enterprise Solution Team in implementing business solutions using Pega technology.As a Senior Business Systems Architect, you will be responsible for leading cross-functional teams in designing and developing software applications that meet user needs. Your...

  • Database Architect

    1 week ago

    Trenton, New Jersey, United States Nanosoft Consulting Full time

    About the JobAs a Database Administrator at Nanosoft Consulting, you will provide technical leadership for the architecture, design, and maintenance of internal databases and related systems. This hybrid role requires an in-person interview and is critical for project success.Key ResponsibilitiesDesign, develop, and maintain database solutions and data...

  • Pega Business Architect Leader

    2 weeks ago

    Trenton, New Jersey, United States HSK Technologies Inc Full time

    About the RoleHiring for a Senior Business Architect to work on Pega Solutions.Key Responsibilities:Lead multiple teams of developers, subject experts, and stakeholders to convert business requirements into functional applications.Collaborate with business users, stakeholders, and technologists to chart business and technical strategies.Evaluate user needs...

  • Technical Lead Solutions Architect

    2 weeks ago

    Trenton, New Jersey, United States Lean-IT Solutions LLP Full time

    Job OverviewWe are seeking an experienced Technical Lead Solutions Architect to join our team at Lean-IT Solutions LLP. The successful candidate will be responsible for leading the design and implementation of complex technology solutions, working closely with cross-functional teams to ensure alignment with business objectives and compliance with industry...

  • Senior Data Engineering Project Lead

    2 weeks ago

    Trenton, New Jersey, United States Tandym Group Full time

    Tandym Group, a leading broadcasting corporation, is seeking a highly skilled Senior Data Engineering Project Lead to join their data engineering team in NJ. This role offers an excellent opportunity for experienced professionals to grow their career in a dynamic and technically challenging environment.Job Summary:The Senior Data Engineering Project Lead...

  • Business Intelligence Solutions Architect

    2 weeks ago

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

    About the RoleWe are seeking an experienced Business Intelligence Solutions Architect to join our team at Core Software Technologies Inc. As a key member of our business intelligence group, you will be responsible for designing and implementing advanced data visualization solutions using Tableau.

  • Senior Pega Business Architect Lead

    2 weeks ago

    Trenton, New Jersey, United States HSK Technologies Inc Full time

    Job Description:Pega Lead Business Architect at HSK Technologies Inc.About the Role:We are seeking a highly experienced and skilled Pega Lead Business Architect to join our team. As a key member of our organization, you will be responsible for leading multiple teams in designing and implementing business solutions using Pega technology.The Ideal...

  • Enterprise Data Integration Specialist

    2 weeks ago

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

    We are seeking an experienced Enterprise Data Integration Specialist to join our team at Core Software Technologies Inc. Based in the US, this full-time position comes with a competitive salary of $150,000 - $200,000 per year, depending on experience.Job DescriptionThe successful candidate will be responsible for designing and implementing robust data...

  • Cloud Architect with Expert Oracle ERP/EPM Experience

    2 weeks ago

    Trenton, New Jersey, United States Eliassen Group Full time

    OverviewEliassen Group is a leading strategic consulting company for human-powered solutions. We have helped thousands of companies reach further and achieve more with their technology solutions, financial, risk & compliance, and advisory solutions, and clinical solutions.About the JobWe are seeking an experienced Cloud Architect with expertise in Oracle...

  • Senior Commercial Construction Director

    1 week ago

    Trenton, New Jersey, United States Michael Page Full time

    Job SummaryWe are seeking a highly skilled Senior Commercial Construction Director to oversee and manage commercial projects from initial planning to completion. The ideal candidate will have a deep understanding of New Jersey's building codes, zoning regulations, and local permitting processes.About the RoleProvide leadership for the entire project...

  • Technical Architecture Lead

    2 weeks ago

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

    We are seeking a highly skilled Senior Lead Technical Architect to join our team at Core Software Technologies Inc.Job DescriptionThe ideal candidate will have 10+ years of experience in leading the technical design and implementation of critical projects. They should possess significant expertise in tools such as Salesforce, AWS, and Snowflake (Data...

  • Data Platform Strategist

    1 week ago

    Trenton, New Jersey, United States Teradata Full time

    Company Overview">Teradata is a leading cloud analytics and data platform provider, empowering customers to make informed decisions with better information.About the Role">This Senior Product Manager position plays a critical role in driving business success by developing innovative features, collaborating cross-functionally, and enhancing customer adoption...

  • Technical Visionary for Strategic Solutions

    1 week ago

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

    Core Software Technologies Inc. is seeking a seasoned Senior Lead Technical Architect to spearhead the development of cutting-edge technology solutions that drive business growth and innovation. With over 10 years of experience in leading technical design and implementation, this role requires expertise in utilizing tools such as Salesforce, AWS, and...

  • Senior Clinical Research Director

    2 weeks ago

    Trenton, New Jersey, United States Daiichi Sankyo Full time

    At Daiichi Sankyo, we're dedicated to creating innovative pharmaceutical therapies that improve healthcare standards worldwide. With over 100 years of scientific expertise and a presence in more than 20 countries, our team is committed to addressing unmet medical needs globally.Detailed Job DescriptionAbout the RoleWe're seeking an experienced Senior...

  • Business Intelligence Architect

    1 week ago

    Trenton, New Jersey, United States ZMAP Strategies Full time

    ZMAP Strategies is a forward-thinking organization seeking an experienced Data Analytics Engineer to lead the development and optimization of cloud-based business intelligence solutions.The ideal candidate will have a strong background in data engineering, experience with cloud platforms, and a passion for collaborating with cross-functional teams to deliver...

  • Senior Network Architect

    23 hours ago

    Trenton, New Jersey, United States TEKsystems Full time

    Job OverviewAs a key member of our team at TEKsystems, you will play a critical role in designing and implementing network solutions that drive business success.About the RoleThis is an exciting opportunity to join our team as a Network Engineer where you will be responsible for designing new products and making improvements to existing ones. You will work...