Apply on Employer Site

TekJobs · 3 months ago

Snowflake developer

Boston, Massachusetts, United States

Full-time

Onsite

Senior Level

5+ years exp

TekJobs is seeking a highly skilled and experienced Snowflake Architect/Developer to join their team. The ideal candidate will have deep experience with Snowflake, data modeling, ETL/ELT processes, and cloud data architecture, working closely with the Snowflake architecture team to deliver scalable, high-performance solutions that meet business analytics and reporting requirements.

Responsibilities

Performance Tuning: Monitor and optimize performance, including query performance, resource utilization, and storage management

User and Access Management: Manage user access, roles, and permissions to ensure data security and compliance with organizational policies

Data Integration: Support and manage data integration processes, including data loading, transformation, and extraction

Troubleshooting and Support: Provide technical support and troubleshooting for Snowflake-related issues, including resolving performance bottlenecks and query optimization

Documentation and Reporting: Maintain detailed documentation of system configurations, procedures, and changes. Generate and deliver regular reports on system performance and usage

Collaboration: Work closely with data engineers, analysts, and other IT professionals to ensure seamless integration and optimal performance of the Snowflake environment

Best Practices: Stay up to date with Snowflake best practices and industry trends. Recommend and implement improvements and upgrades to enhance system functionality and performance

Qualification

SnowflakeData modelingETL toolsSQLAWSData warehousingPythonAnalytical skillsContinuous improvementProblem-solvingCommunication skills

Required

At a minimum, a bachelor's degree in computer science, Information Technology, or a related field

5+ years of experience in data architecture, data engineering, or database development

2+ years of hands-on experience with Snowflake, including data modeling, performance tuning, and security

Experience or exposure to AI tools

Deep understanding of data warehousing concepts, dimensional modeling, and analytics

Excellent problem-solving and communication skills

Strong proficiency in Snowflake architecture, features, and capabilities

Knowledge of SQL and Snowflake-specific query optimization

Experience with ETL tools and data integration processes

Strong proficiency in SQL and Python

Strong Database design and data modelling experience. Experience with data modeling tools

Ability to identify and drive continuous improvements

Strong problem solving and analytical skills

Demonstrated process-oriented and strategic thinking skills

Strong motivation and a desire to continuously learn and grow

Knowledge of Snowflake security features including access control, authentication, authorization, encryption, masking, secure view, etc

Experience working in AWS cloud environments

Experience working with Power BI and other BI, data visualization, and reporting tools

Business requirement gathering and aligning to solutions delivery

Experience with data integration solutions and tools, data pipelines, and modern ways of automating data using cloud based and on-premises technologies