Any visa is fine

Sr. Snowflake Developer,

location : hybrid (Chicago, IL),

contract position

Top Skills' Details

• Snowflake Developer
• Oracle / PL SQL / Database
• Kafka
• MS Azure
  
  

Databricks is a nice to have.

MUST BE VERY GOOD WITH RELATIONAL DATABASE DEVELOPMENT (ORACLE - PL/SQL) as well

Secondary Skills - Nice To Haves

• ETL
• CDC
• Cloud
• BI Tools
  
  

Job Description

Key Responsibilities:

Data Integration

Implement and maintain data synchronization between on-premises Oracle databases and Snowflake using Kafka and CDC tools.

Support Data Modeling

Assist in developing and optimizing the data model for Snowflake, ensuring it supports our analytics and reporting requirements.

Data Pipeline Development

Design, build, and manage data pipelines for the ETL process, using Airflow for orchestration and Python for scripting, to transform raw data into a format suitable for our new Snowflake data model.

Reporting Support

Collaborate with data architect to ensure the data within Snowflake is structured in a way that supports efficient and insightful reporting.

Technical Documentation

Create and maintain comprehensive documentation of data pipelines, ETL processes, and data models to ensure best practices are followed and knowledge is shared within the team.

Additional Skills & Qualifications

Tools and Skillsets:

Data engineering: proven track record of developing and maintaining data pipelines and data integration projects

Databases: Strong experience with Oracle, Snowflake, and Databricks.

Data Integration Tools: Proficiency in using Kafka and CDC tools for data ingestion and synchronization.

Orchestration Tools: Expertise in Airflow for managing data pipeline workflows.

Programming: Advanced proficiency in Python and SQL for data processing tasks.

Data Modeling: Understanding of data modeling principles and experience with data warehousing solutions.

Cloud Platforms: Knowledge of cloud infrastructure and services, preferably Azure, as it relates to Snowflake and Databricks integration.

Collaboration Tools: Experience with version control systems (like Git) and collaboration platforms.

CI/CD Implementation: Utilize CI/CD tools to automate the deployment of data pipelines and infrastructure changes, ensuring high-quality data processing with minimal manual intervention.

Communication: Excellent communication and teamwork skills, with a detail-oriented mindset. Strong analytical skills, with the ability to work independently and solve complex problems.

Employee Value Proposition (EVP)

The work the Digital Metamorphosis team is doing isn't only improving the front office but also every process we have in place. By improving the underlying architecture of all our tasks and systems, we are making everything more streamlined and efficient, from how we onboard new clients and how we move money for them to how those same clients use our platforms to check their investments and balances. Long term, getting this right will allow us to service clients and internal partners in the way we want to.

Work Environment

Business Casual Banking Work Environment.

Business Drivers/Customer Impact

This project aims to modernize our data architecture by leveraging cloud technologies, specifically Snowflake and Databricks, to enhance our data storage, processing, and analytics capabilities. It involves migrating application data from an on-premises Oracle database to a more scalable, flexible and secure cloud-based environment, optimizing data flows and analytics to support real-time decision-making and insights.