Databricks Team Lead – Snowflake & Data Warehousing

Macpower Digital Assets Edge LLC

Columbus, OH

JOB DETAILS
JOB TYPE
Full-time
SKILLS
Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Architectural Services, Automation, Business Intelligence Software, Cloud Computing, Communication Skills, Data Management, Data Migration, Data Modeling, Data Recovery, Data Storage, Data Warehousing, Database Extract Transform and Load (ETL), GCP (Good Clinical Practices), Informatica, Leadership, Microsoft Windows Azure, OLAP (OnLine Analytical Processing), Process Improvement, Python Programming/Scripting Language, Query Optimization, Relational Databases (RDBMS), SQL (Structured Query Language), Scripting (Scripting Languages), Snowflake Schema, Stored Procedures, Team Lead/Manager
LOCATION
Columbus, OH
POSTED
30+ days ago
Job Summary: We are seeking an experienced Databricks Team Lead with strong expertise in Snowflake, Data Warehousing, ETL processes, and SQL programming. The ideal candidate will lead the development and implementation of data pipelines, OLAP queries, and cloud-based data migration projects while driving architectural improvements. Key Responsibilities: Data Warehouse Implementation Design and implement data warehousing solutions with Snowflake and RDBMS migration. OLAP Query Optimization Develop and optimize complex OLAP queries for high-performance data retrieval. Cloud Data Migration Lead migration projects from RDBMS to Snowflake Cloud Data Warehouse. ETL Process Design Architect ETL workflows using Informatica, Azure Data Factory (ADF), and Snow Pipe. SQL Programming Utilize strong SQL skills for complex stored procedures and SnowSQL scripting. Cloud Platform Management Work with AWS, Azure, GCP for data storage solutions such as S3 and ADLS. Data Modeling & Classification Develop data models and ensure proper classification for efficient processing. Python Development Implement Python-based automation and data handling solutions. Stakeholder Collaboration Communicate effectively with technical teams and business stakeholders. Required Qualifications: 7+ years of experience in Data Warehousing systems 2-3 years of hands-on experience with Snowflake Expertise in ETL concepts and Snowflake Architecture Strong SQL programming, including stored procedures and SnowSQL Experience with Cloud Platforms Azure, AWS, GCP Proficiency in Data Migration & Data Modeling Hands-on experience with Python Preferred Skills: Experience with Snow Pipe, Informatica, and ADF Familiarity with BI Tools Strong communication and leadership skills Cloud certification (preferred)

About the Company

M

Macpower Digital Assets Edge LLC