Snowflake Data Architect

at Teksystems in Chicago, Illinois, United States

Job Description

Snowflake Data Architect Hybrid contract opening in Chicago.

Key Responsibilities:

Data Integration and Synchronization:

Design efficient data synchronization processes between on-premises Oracle databases and Snowflake using Kafka and CDC extraction tools.

Platform Migration:

Lead the strategic planning and execution of migrating existing in-house data platforms to cloud, ensuring minimal disruption and data integrity.

Data Modeling for Snowflake and Databricks

Develop efficient data models for cloud database to facilitate scalable data storage, processing, and analytics.

Data Pipeline Development:

Architect and implement data pipelines using Airflow and Python.

Analytics and Reporting:

Utilize Snowflake and Databricks for advanced reporting and analytics, providing actionable business insights.

Collaboration and Innovation:

Work with cross-functional teams to understand data needs and deliver technical solutions, mentoring on best practices.

Skills:

Snowflake, Oracle, Data Architecture, Python, SQL,

Additional Skills & Qualifications:

Data Architecture: Demonstrated experience in migrating on-premises data to cloud and setting up stable, scalable frameworks

Databases: Proficiency in Oracle, Snowflake, and Databricks.

Data Integration: Experience with Kafka and CDC tools for real-time data synchronization.

ETL Tools: Expertise in Airflow for data pipeline orchestration.

Programming: Advanced proficiency in Python for data processing and automation.

Data Modeling: Strong understanding of data modeling techniques and experience in designing scalable data models for cloud data warehouses.

Reporting Tools: Familiarity with BI tools and technologies for creating reports and dashboards.

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

Project Management: Experience in leading large-scale data migration and platform integration projects.

Communication: Excellent verbal and written communication skills for effective collaboration across teams. Strong analytical, problem-solving, and team management skills.

Experience Level:

Intermediate Level

We’re partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That’s the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.