Snowflake Developer x2

Job Title: Snowflake Developer x2

Location: Boston MA (Onsite)- Need local

Duration: 6- 12 Months (Contract)

Interview: Video (2 Rounds)

Visa- USC & GC Only

Job Description:

Interview: Initial contact by phone interview may be conducted in-person or by video conference

Hours Per Week: 37.5

Job Summary:

MassDOT Technology division is seeking a highly skilled experienced and motivated Snowflake Architect/Developer to join our team. The ideal candidate will have deep experience with Snowflake data modeling ETL/ELT processes and cloud data architecture. You will work closely with Snowflake architecture team to deliver scalable high-performance solutions that meet business analytics and reporting requirements. This role requires a deep understanding of Snowflakes features and best practices as well as strong problem-solving skills and the ability to work collaboratively with cross-functional teams.

Key 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.
• Qualifications and Experience:
  • 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.
  • At a minimum bachelors degree in computer science Information Technology or related field.
  • Experience with source control tools (GitHub preferred) ETL/ELT tools and cloud platforms (AWS preferred).
  • Experience or exposure to AI tools.
  • Deep understanding of data warehousing concepts dimensional modeling and analytics.
  • Excellent problem-solving and communication skills.
  • Experience integrating Snowflake with BI and reporting tools is a plus

• Required 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.
  • Experience integrating Snowflake with an identity and access management program such as Azure IDP is a plus.
  • Experience with other relational database management systems cloud data warehouses and big data platforms is a plus.

• Analytical Skills: Excellent problem-solving and analytical skills with strong attention to detail.
• Communication: Effective communication skills both written and verbal with the ability to convey complex technical information to non-technical stakeholders.
• Teamwork: Ability to work independently and collaboratively in a fast-paced environment.

Preferred Skills:

• Snowflake certification (e.g. SnowPro Core or Advanced Certification).
• Experience with data visualization tools (e.g. Power BI).
• Knowledge of technical areas such as T-SQL DevOps and scripting.