Sr. Snowflake Data Engineer

Snowflake Data Engineer

100% remote

Title: Snowflake Consultant

Location: (Boston) 100% remote, just need to be able to support EST hours

Start Date: ASAP - once onboarding clears

Duration: 12 months to start

Hours Shift On Call Time Zone: 9-4:30 pm EST

Key Responsibilities

• Data Source Integration: Support the expansion of universities data Lakehouse by adding two new data sources:
• Data Architecture Alignment: Ensure the new integrations follow the established data Lakehouse framework and conform to enterprise data modeling and governance standards.
• Initial Data Load Expertise: Responsible for all phases of data ingestion, including performing the initial bulk data load from both into the staging environment to establish the baseline historical dataset.
• Pipeline Development & Maintenance: Design and implement robust incremental data loading procedures for both sources to ensure accurate data and optimal change data capture.
• ETL/ELT Tooling: Required to have hands-on experience with SnapLogic (integrations middleware platform) to develop and manage data pipelines (Snaps/Pipelines) for extraction, transformation, and loading. This includes setting up and managing scheduled tasks within the SnapLogic environment.

Key Skills and Qualifications

• Strong hands-on experience with the Snowflake platform.
• Proficiency in SQL.
• Experience with programming languages like Python (including Snowpark) is a plus but not required.
• Knowledge of data modeling, data warehousing, and data pipeline concepts.
• Experience with Tableau is a plus, but not required.
• Familiarity with cloud-native services and other data platforms (e.g., AWS).
• Understanding of data governance, security, and compliance principles.