Sr. Snowflake Data warehouse Administrator

Overview

Hybrid
Depends on Experience
Full Time
25% Travel

Skills

snoflake
data warehouse
administrator
configuration
security

Job Details

Key Responsibilities:

MUST HAVE SKILLS:
1.SNOWFLAKE
2.FIVETRAN( THE Team is MIGRATING FROM  ETL INFORMATICA)
3.DBT( DATA BUILD TOOL)
4 AWS- AWS glue is a must (AWS ATHENA, AWS KINESIS IS good to have)

5. ON DATA SCIENCE SIDE- AWS SAGEMAKER IS NICE TO HAVE  BUT NOT MUST

LOCAION- BOSTON, 4 days a week

Design, implement, and maintain Snowflake data warehouse solutions to fulfill business requirements effectively.

Deploy and optimize DBT models and transformations to streamline data processing and facilitate analytics.

Manage Fivetran data pipelines to enable seamless data integration and synchronization.

Utilize AWS Glue for data cataloging, executing ETL jobs, and performing data transformation operations.

Apply Python and SageMaker for advanced analytics, machine learning initiatives, and data science projects.

Employ DB2, SQLServer, and Informatica as necessary for data migration, integration, and administration tasks.

Collaborate with data engineers, analysts, and stakeholders to comprehend data needs and deliver actionable insights.

Develop and enforce data governance and security protocols to uphold data quality and regulatory compliance.

Monitor system performance, troubleshoot issues, and implement performance optimization strategies.

Stay abreast of industry best practices and emerging technologies in data warehousing and