Snowflake Data Architect - Data-warehouse Modernization

Snowflake Data Architect - Data-warehouse Modernization

Posted 1 week ago by 1753342830

Apply
Negotiable
Outside
Remote
USA
Apply
BigQuery Change Data Capture (CDC) Cloud Computing Cloud Technologies Cloud Technology Data Capture (SQL) Data Engineering Data Governance Datamodel Data Modeling Data Quality Data Security Data Transformation Data Warehousing Design Elements And Principles Google Analytics Google Cloud Google Cloud Platform (GCP) IBM DB2 IBM Software Management Performance Tuning Snowflake (Data Warehouse) Snowflake Schema SQL (Programming Language) Stakeholder Management Star Schema Workflows

Summary: The Snowflake Data Architect role focuses on leading data warehouse modernization projects, leveraging extensive experience in data engineering and cloud technologies. The position requires strong expertise in IBM iSeries DB2, Snowflake, and data modeling principles. The ideal candidate will also possess proficiency in data transformation tools and workflow orchestration, along with a solid understanding of data governance and security. This role is remote and classified as outside IR35.

Key Responsibilities:

  • Lead data warehouse migration projects with hands-on experience.
  • Utilize IBM iSeries DB2, IBM Sailfish, and Snowflake for data engineering tasks.
  • Design data models using star schema and snowflake schema principles.
  • Transform data using DBT and orchestrate workflows with Prefect.
  • Implement solutions on Google Cloud Platform and Google BigQuery.
  • Design data warehouses and manage ETL/ELT processes.
  • Optimize SQL queries and tune performance for large-scale databases.
  • Analyze data requirements and provide solutions for complex data challenges.

Key Skills:

  • 12+ years of experience in data engineering.
  • Strong expertise with IBM iSeries DB2, IBM Sailfish, and Snowflake.
  • Proven experience in data modeling with Snowflake.
  • Proficiency in DBT and Prefect.
  • Experience with Google Cloud Platform and Google BigQuery.
  • Solid knowledge of data warehouse design and ETL/ELT processes.
  • Proficient in SQL with performance tuning experience.
  • Experience in Google Analytics and Change Data Capture.
  • Strong analytical and problem-solving skills.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Required Skills and Experience:

  • 12+ years of experience in data engineering, with hands-on experience in data warehouse migration projects.
  • Strong expertise with IBM iSeries DB2, IBM Sailfish, and Snowflake.
  • Proven experience in data modeling with Snowflake, including star schema and snowflake schema design principles.
  • Proficiency in using DBT for data transformation and Prefect for workflow orchestration.
  • Experience with Google Cloud Platform (Google Cloud Platform) and Google BigQuery.
  • Solid knowledge of data warehouse design, data modeling, and ETL/ELT processes.
  • Proficient in SQL and experienced with performance tuning for large-scale databases
  • Experience in Google Analytics
  • Experience in Change Data Capture
  • Strong analytical and problem-solving skills, with the ability to understand complex data requirements.

Preferred Qualifications:

  • Hands-on experience with cloud migration projects.
  • Experience in data governance, data security, and data quality management.
  • Ability to work independently, manage multiple tasks, and drive projects to completion
  • Excellent communication skills, with the ability to explain technical concepts to non-technical stakeholders.
Apply
Similar Jobs
Loading data...