Snowflake Data Engineer

2 weeks ago


Boston, United States Compu-Vision Consulting Full time
Job tile: Snowflake Data Engineer
Duration: 6 Months (Tenative)
Location: Boston, MA (Hybrid)


Position Summary:
The Client is looking for an experienced Snowflake Data Engineer to lead the implementation of Division of Housing Stabilization data in our new Snowflake data warehouse. The Snowflake Data Engineer plays a critical role in designing, building, and supporting the components of the agency's data warehouse. This position involves working with various stakeholders to ensure accurate and efficient data management, reporting, and analytics. As a Snowflake Data Engineer, you will collaborate closely with the technology group, the agency data team, agency program staff and external organizations that assist in delivery of department programs. The Data Engineer will report to client Director of Information Technology Development

Responsibilities:
The Snowflake Data Engineer is responsible for:

o Design, develop, and maintain complex snowflake data warehouses, including data modeling, ETL processes, and data quality control.
o Ensure data integrity, quality, and security across all data warehousing activities.
o Develop and maintain data pipelines to integrate data from various internal and external sources.
o Develop and maintain data pipelines using tools for data transformation, testing, and deployment. Ensure data pipelines are scalable, reliable, and efficient.
o Write Python code to automate data processing, transformation, and loading tasks, including data ingestion, data quality control, and data visualization.
o Collaborate with data analysts and business stakeholders to understand data requirements and develop data solutions that meet business needs.
o Develop and maintain data visualizations and reports using Snowflake's built-in visualization tools or third-party tools like Tableau.
o Ensure data quality, integrity, and security by developing data validation rules, data cleansing processes, and data access controls.
o Optimize snowflake data warehouse performance, scalability, and reliability, including monitoring and troubleshooting data issues.
o Develop and maintain technical documentation, including data dictionary, data flow diagrams, and code comments.
o Participate in code reviews and provide feedback to ensure high-quality code and adherence to coding standards.
o Work closely with the agency's data team and the overall state technology team to ensure alignment on data strategy and technology standards.
o Communicate complex data findings to non-technical stakeholders in a clear and concise manner
o Provide technical guidance and mentorship to junior analysts and other team members

Qualifications:

o 8+ years of experience in Snowflake data warehouse development and management, data engineering field.
o Strong understanding of Snowflake architecture, data modeling, and data warehousing concepts.
o Proficiency with SQL, including snowflake's SQL dialect and complex query writing for performance optimization.
o Experience with Snowflake features, including cloning, time travel, data sharing, and micro-partitioning.
o Strong understanding of Snowflake's architecture, including virtual warehouses, storage, and compute separation.
o Expertise in Snowflake Role-Based Access Control (RBAC), data masking, and encryption.
o Proficiency with data integration tools and ETL/ELT processes.
o Experience in Python or similar scripting languages for automation and data processing.
o Knowledge of data security and compliance standards as they relate to Snowflake.
o Experience with cloud platforms like AWS, Azure.
o SnowPro Advanced certification is a plus.
o Knowledge of data governance frameworks and tools.
o Strong experience integrating Snowflake with Tableau, Salesforce, third party APIs etc.
o Strong analytical, problem-solving, and communication skills
o bility to work collaboratively in a cross-functional team environment
o Excellent verbal and written communication skills with project teams and business teams
o Team-oriented attitude and the proven ability to collaborate at all levels of an organization

Desired Skills/Experience:
• SnowPro Advanced Architect or SnowPro Data Engineering certification is preferred.
• Experience in building complex data pipelines in an multi cloud environment.
• Experience implementing data masking, and aggregation to reduce privacy risks
• Experience integrating data from Salesforce solutions
• Knowledge of CI/CD practices and tools.
• Familiarity JIRA or other project management tools
• Experience using GitHub
• Experience working on projects in the affordable housing sector or other public benefit programs
• Familiarity with a variety of software development methodologies such as agile, waterfall, and a strong understanding of the suitability of these methodologies for certain development environments and types of pplications
• Experience with advanced Microsoft Office, pivot tables, charts, Visio, data analytics and JIRA or other project management tools
• Experience with SQL a plus

  • Boston, United States The Computer Merchant, LTD. Full time

    JOB TITLE: Snowflake Data Engineer JOB LOCATION: Boston MA WAGE RANGE*: $80-$85 JOB NUMBER: Client-25-1076-OCDDE-OCD01-110646 REQUIRED EXPERIENCE:8+ years of experience in Snowflake data warehouse development and management, data engineering field. Strong understanding of Snowflake architecture, data modeling, and data warehousing concepts. Proficiency with...


  • Boston, United States Mindlance Full time

    Position Details: Title: Senior Snowflake Data Engineer/ Developer Duration: Till End of Fiscal year June 30th, 2025 (Possible Extension)Working hours: 37.5 hrs/ weekInterview Mode: Onsite/ Face to Face Interview Position Summary:The Snowflake Data Engineer plays a critical role in designing, building, and supporting the components of the agency’s data...


  • Boston, United States JobRialto Full time

    Position Summary The client is looking for an experienced Snowflake Data Engineer to lead the implementation of Division of Housing Stabilization data in our new Snowflake data warehouse. The Snowflake Data Engineer plays a critical role in designing, building, and supporting the components of the agency's data warehouse. This position involves working with...


  • Boston, United States Experis Full time

    Snowflake Data Engineer Hybrid - once a week onsite in Boston, MA (must be local to area, no relocation) Contract through June 30, 2025 with possibility to extend yearlyResponsible for: Design, develop, and maintain complex snowflake data warehouses, including data modeling, ETL processes, and data quality control. Ensure data integrity, quality, and...

  • Data Engineer

    4 weeks ago


    Boston, United States Compunnel Full time

    Job Summary: We are seeking a skilled Data Engineer specializing in Snowflake to join our team. This role focuses on ensuring data integration and quality within our enterprise data ecosystem, working with technologies like DBT, Snowflake, and GIT. Ideal candidates will have strong expertise in ETL/ELT processes, data modeling, and data profiling, with a...


  • Boston, United States Imetris Corporation Full time

    Snowflake Data EngineerLocation: Boston, MA (Hybrid)Contract: W2 Only (No C2C)Note: The candidate must work onsite 1 day a weekResponsibilities:Design, develop, and maintain complex snowflake data warehouses, including data modeling, ETL processes, and data quality control. Ensure data integrity, quality, and security across all data warehousing activities....


  • Boston, United States Experis Full time

    Snowflake Data Engineer Hybrid – once a week onsite in Boston, MA (must be local to area, no relocation) Contract through June 30, 2025 with possibility to extend yearly Responsible for: Design, develop, and maintain complex snowflake data warehouses, including data modeling, ETL processes, and data quality control. Ensure data integrity, quality, and...


  • Boston, MA, United States iFlow Inc Full time

    Role: Snowflake Data Engineer Duration: Longterm Location: Boston, MA Desired Certifications: SnowPro Advanced certification is a plus. SnowPro Advanced Architect or SnowPro Data Engineering certification is preferred. Required Skills: 8+ years of experience in Snowflake data warehouse development and management, data engineering field. ...


  • boston, United States Rose International Full time

    Date Posted: 12/13/2024 Hiring Organization: Rose International Position Number: 475620 Job Title: Snowflake Data engineer Job Location: Boston, MA, USA, 02114 Work Model: Hybrid Shift: 1 day per week in office preferably Tuesday Employment Type: Temporary Estimated Duration (In months): 13 Min Hourly Rate ($): 75.00 Max Hourly Rate ($):...


  • boston, United States TalentBurst Full time

    Position: Snowflake Data Engineer Location: Boston, MA (Hybrid) Duration: Multi Year Renewable Contract Hours: 37.5 Hours per week Description of Duties The role is responsible for: Design, develop, and maintain complex Snowflake data warehouses, including data modeling, ETL processes, and data quality control. Ensure data integrity, quality, and security...


  • Boston, United States Talent Groups Full time

    NOTE: NEED CANDIDATES WHO ARE LOCAL TO MASSACHUSTEETS OR SOMEONE FROM NEW ENGLAND AREA ONLY.Qualifications:8+ years in data engineering with expertise in Snowflake.Proficient in SQL, Snowflake architecture, and advanced features (RBAC, data masking, etc.).Experience with Python, ETL tools, and cloud platforms like AWS/Azure.Strong understanding of data...


  • Boston, Massachusetts, 02118, Suffolk County, MA, United States Experis Full time

    Snowflake Data Engineer Hybrid – once a week onsite in Boston, MA (must be local to area, no relocation) Contract through June 30, 2025 with possibility to extend yearly Responsible for: Design, develop, and maintain complex snowflake data warehouses, including data modeling, ETL processes, and data quality control. Ensure data integrity, quality, and...


  • Boston, United States DraftKings Full time

    About DraftKings We're defining what it means to build and deliver the most extraordinary sports and entertainment experiences. Our global team is trailblazing new markets, developing cutting-edge products, and shaping the future of responsible gaming. Here, "impossible" isn't part of our vocabulary. You'll face some of the toughest but most rewarding...


  • boston, United States Rose International Full time

    Date Posted: 12/13/2024 Hiring Organization: Rose International Position Number: 475620 Job Title: Snowflake Data engineer Job Location: Boston, MA, USA, 02114 Work Model: Hybrid Shift: 1 day per week in office preferably Tuesday Employment Type: Temporary Estimated Duration (In months): 13 Min Hourly Rate ($): 75.00 Max Hourly Rate ($):...


  • boston, United States Rose International Full time

    Date Posted: 12/13/2024 Hiring Organization: Rose International Position Number: 475620 Job Title: Snowflake Data engineer Job Location: Boston, MA, USA, 02114 Work Model: Hybrid Shift: 1 day per week in office preferably Tuesday Employment Type: Temporary Estimated Duration (In months): 13 Min Hourly Rate ($): 75.00 Max Hourly Rate ($):...


  • boston, United States TalentBurst Full time

    Position: Snowflake Data Engineer Location: Boston, MA (Hybrid) Duration: Multi Year Renewable Contract Hours: 37.5 Hours per week Description of Duties The role is responsible for: Design, develop, and maintain complex Snowflake data warehouses, including data modeling, ETL processes, and data quality control. Ensure data integrity, quality, and security...


  • Boston, United States TalentBurst Full time

    Position: Snowflake Data Engineer Location: Boston, MA (Hybrid) Duration: Multi Year Renewable Contract Hours: 37.5 Hours per week Description of Duties The role is responsible for: Design, develop, and maintain complex Snowflake data warehouses, including data modeling, ETL processes, and data quality control. Ensure data integrity, quality, and security...


  • South Boston, United States Zelis Healthcare Full time

    We are looking for a Senior Snowflake Data Engineer for our Zelis Data Cloud in Snowflake as part of our Zelis Data & AI Fabric to help in the below. Summary: Build High level technical design both for Streaming and batch processing systems Design and implement data model changes that align with warehouse dimensional modeling standards. Proficient in Data...


  • Boston, United States HexaQuEST Global, Inc. Full time

    Job Description : POSITION OVERVIEW: The MassHealth Systems Teams unit seeks a highly motivated individual as a Data Warehouse Snowflake Migration Tester to join its Systems Quality Assurance (SQA) team. As a Data Warehouse Snowflake Migration Tester, you will be responsible for ensuring the successful migration of data warehouse systems to the Snowflake...


  • Boston, United States Diverse Lynx Full time

    Job Description: Role: Snowflake Engineer/Developer Location: Boston, MA/Quincy, MA - Onsite from day 1 Duration: Contract 1. Candidate should have good experience in Scala & Python programming language for data bricks development 2. Candidate should have very good experience in Snowflake 3. Candidate should have very good experience in the data lake and...