Senior Snowflake Developer
Senior Snowflake Developer
Posted on :
11-02-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Job Title:
Senior Snowflake Developer (Hybrid Onsite)
Location:
Trenton NJ
Duration:
12 Months
Interview Process:
InPerson Interview
Other details
- Note: This is a Hybrid position 3 Days OnSite 2 Days Remote.
- If the candidate resides more than 1 hour from the client site will the candidate relocate for the position
- Please provide link to LinkedIn profile if available.
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
1. Data Architecture
- Collaborate with data architects to design and develop Snowflake data models and schemas.
- Create and maintain a wellstructured data warehouse and data lake architecture.
2. 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.
3. Performance Optimization
- Optimize query performance by creating and maintaining appropriate indexes materialized views and clustering keys.
- Identify and resolve performance bottlenecks in data processing.
4. SQL Development
- Write complex SQL queries stored procedures and userdefined functions (UDFs) to support data analytics and reporting needs.
- Ensure SQL code follows best practices for readability and performance.
5. Security and Access Control
- Implement and manage security measures including rolebased access control (RBAC) and data encryption to protect sensitive data.
- Audit and monitor data access and user activities.
6. 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.
7. Documentation
- Create and maintain technical documentation for data models ETL processes and data dictionaries.
- Document best practices standards and guidelines for Snowflake development.
8. 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.
9. 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.
10. Backup and Recovery
- Implement backup and recovery strategies to ensure data integrity and availability.
- Develop and test data recovery procedures.
11. Collaboration
- Collaborate with data engineers data scientists and business analysts to understand data requirements and provide data solutions.
- Work with crossfunctional teams to support datarelated projects and initiatives.
Qualifications
- Bachelors or masters 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 problemsolving and troubleshooting skills.
- Strong communication and collaboration abilities.
- Ability to work in an Agile or iterative development environment.
Top Skills & Years of Experience
- Snowflake Data Warehouse Design & Development Required 7 Years
- Cloud Computing Preferably AWS (Azure GCP) Required 7 Years
- Data Modeling (Star Schema Snowflake Schema) Required 7 Years
- Continuous Integration/Deployment (CI/CD) Tools Required 7 Years
- Performance Tuning & Optimization Required 7 Years
- SQL for Data Querying & Manipulation Required 7 Years
- Data Migration to Cloud Platforms Required 7 Years
- Data Security & Governance in Cloud Environments Required 7 Years
- Data Warehousing Best Practices Required 7 Years
- Automation using Python/SnowSQL Required 7 Years
- ETL/ELT Processes using Snowflake Required 5 Years
- Snowflake Stored Procedures UDFs and Views Required 5 Years
- Working with Snowflake Utilities (SnowPipe Streams Tasks) Required 5 Years
- Data Integration (Informatica Talend Matillion DBT Preferable) Highly desired 5 Years
- Bachelors Degree minimum Required
Recruiter Details:
Name : Sameer at gsksolutions dot com
Contact : Seven one nine Two three nine Five five five five
About US:
GSK Solutions Inc. is a premier information technology services company dedicated to delivering exceptional consulting solutions and staff augmentation to our valued clients. With an unwavering commitment to quality timeliness and budgetary considerations we consistently strive to exceed client expectations building a strong reputation through our reliable execution. Our expertise spans commercial and custom product development covering information security software development consulting and IT audits. We excel in managing critical timesensitive projects for Fortune 500 clients nationwide ensuring their success is always at the forefront of our mission.
Employment Type
Full Time
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
