Snowflake Engineer

Ceres FTS; Boston (MA); On-site; USD 90,000 - 120,000; Full time

Job summary

A technology solutions company in Boston is looking for a candidate to play a key role in delivering data-driven interactive experiences to clients. The candidate should have expertise in Snowflake data modeling and data integration technology solutions, with a solid understanding of enterprise data management concepts. The role involves translating client needs into effective technology solutions and ensuring the quality of deliverables throughout the project lifecycle. This position demands hands-on experience with SQL and understanding of key data governance practices.

Qualifications

• Experience in implementing, executing, and maintaining Data Integration technology solutions.
• Expertise in Snowflake concepts including resource monitors and performance tuning.
• Hands-on expertise with SQL and SQL analytics.

Responsibilities

• Deliver data-driven interactive experiences to clients.
• Translate clients' needs into technology solutions.
• Participate in integrated validation and analysis sessions.

Skills

Data Integration technology solutions

Data analysis

SQL and SQL analytics

Snowflake data modeling

Problem solving

Understanding of data governance

Education

Bachelor’s degree in Computer Science, Engineering or related field

Tools

Snowflake

AWS

Azure

Job description

Responsibilities

• Play a key role in delivering data-driven interactive experiences to our clients
• Work closely with our clients in understanding their needs and translating them to technology solutions
• Provide expertise as a technical resource to solve complex business issues that translate into data integration and database systems designs
• Problem solving to resolve issues and remove barriers throughout the lifecycle of client engagements
• Ensuring all deliverables are high quality by setting development standards, adhering to the standards and participating in code reviews
• Participate in integrated validation and analysis sessions of components and subsystems on production servers

Qualifications

Your Skills And Experience

• Experience in the implementation, execution, and maintenance of Data Integration technology solutions
• Experience advancing and supporting information management practices within business processes, applications and technology that underpin the data discipline (e.g. establishing data quality processes, performing data analysis, participating in technology implementation planning, implementing data integration processes, etc)
• Expertise in Snowflake data modeling, ELT using snowpipe, implementing stored procedures and standard DWH and ETL concepts
• Expertise in Snowflake concepts like setting up resource monitors, RBAC controls, virtual warehouse, query performance tuning, Zero copy clone, time travel and understand how to use these features
• Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
• Experience with enterprise cloud economics
• Understanding of enterprise data management concepts (Data Governance, Data Engineering, Data Science, Data Lake, Data Warehouse, Data Sharing, Data Applications)
• Hands‑on expertise with SQL and SQL analytics
• Industry benchmarking experience in major industries such as: Financial Services and Retail
• Bachelor’s degree in Computer Science, Engineering or related field.

Set Yourself Apart With

• Certifications for any of the cloud services like AWS, Snowflake, or Azure
• Experience working with code repositories and continuous integration
• Understanding of development and project methodologies