Senior Snowflake Developer Job at Core Software Technologies Inc., Trenton, NJ

RmJLWEN3U0RJbVlaem1Ed3lJNjVmSEJnQ0E9PQ==
  • Core Software Technologies Inc.
  • Trenton, NJ

Job Description

A Senior Snowflake Developer is a highly skilled professional responsible for designing, implementing, and optimizing data solutions using the Snowflake cloud data platform. 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.

 
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.

About Core Software Technologies Inc.:

Core Software Technologies has practical experience in giving best in class business innovation answers for associations. Since several years, we are empowering organizations with integrated technologies and to enable them to meet the advancing business requests.We cooperate with associations and create solid and long term relationships. Our evolution in thought-administration, very qualified and experienced business innovation specialists.

Job Tags

Contract work,

Similar Jobs

Stripes Logistics Company

Power Only Owner Operators - Regional Blocks Job at Stripes Logistics Company

 ...Tractor/Truck in order to qualify for this opportunity. We are an Owner Operator Fleet only. We do not own any trucks, nor do we hire direct...  ...Job: Stripes Logistics is seeking dedicated and reliable Power-Only Tractor Owner-Operators to handle container and dry van loads... 

SURGE Staffing

Forklift, Tow, Clamp & Reach Truck Oper. Stand/Sit Job at SURGE Staffing

 ...Position Summary We are seeking a dependable and safety-focused Forklift Operator / Material Handler to support daily warehouse...  ...Operate forklifts and material handling equipment (sit-down, stand-up, reach truck, pallet jack, as applicable) in a safe and efficient manner... 

BWXT

Nuclear Process Operator (PIPELINE -- May 2025) Job at BWXT

 ...exploration. With more than 7,800 employees, BWXT has 14 major operating sites in the U.S., Canada and the U.K. We are the sole...  ...LinkedIn , X , Facebook and Instagram . Nuclear Process Operator - Nuclear Fuel Services (BWXT) - Erwin, TN Minimum... 

TriCorps

Armed Security Officer Job at TriCorps

 ...Job Description Armed Security Officer (Security) Tulsa, OK, United States of America $ 22.00 - $ 22.00 Back Apply Now Back Apply Now Overview TriCorps is an integrated security and technology firm specializing in providing cost-effective, world-class... 

Assurity Transportation Solutions

CDL A Owner Operator Semi Local Job at Assurity Transportation Solutions

 ...Local Some self dispatch accounts No trailer fees, mostly power only Most loads pay next day, no pay hold back...  ...an Amazing year. The sky's the limit! Semi Local CDL A owner operator Position with great pay and equitable home time for work/life...