What are the responsibilities and job description for the Data Architect position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Data Capital Inc, is seeking the following. Apply via Dice today!
About The Role
We are seeking a highly experienced and technically proficient Data Architect to lead a comprehensive data warehouse modernization initiative. This role is pivotal in transitioning legacy systems on IBM Sailfish and IBM iSeries DB2 to a modern, scalable cloud-based architecture leveraging Snowflake on Google Cloud Platform (Google Cloud Platform). The ideal candidate will be a strategic thinker with deep data engineering expertise and strong communication skills to partner with both technical teams and business stakeholders.
Required Skills And Experience
About The Role
We are seeking a highly experienced and technically proficient Data Architect to lead a comprehensive data warehouse modernization initiative. This role is pivotal in transitioning legacy systems on IBM Sailfish and IBM iSeries DB2 to a modern, scalable cloud-based architecture leveraging Snowflake on Google Cloud Platform (Google Cloud Platform). The ideal candidate will be a strategic thinker with deep data engineering expertise and strong communication skills to partner with both technical teams and business stakeholders.
Required Skills And Experience
- 12 years of experience in data engineering with significant hands-on involvement in data warehouse modernization initiatives.
- Expertise in IBM iSeries DB2 and IBM Sailfish, including migrating workloads from legacy systems.
- Deep experience with Snowflake architecture, data modeling (star/snowflake schemas), and performance tuning.
- Strong proficiency in SQL and experience optimizing queries and performance for large datasets.
- Extensive experience building data transformation workflows using DBT.
- Hands-on experience with Prefect (or similar orchestrators like Airflow) for workflow automation.
- Experience with Google Cloud Platform (Google Cloud Platform) and Google BigQuery.
- Solid understanding of ETL/ELT processes, data warehouse design, and distributed data systems.
- Experience using Google Analytics and translating web data into business insights.
- Practical experience implementing Change Data Capture (CDC).
- Strong analytical, problem-solving, and architectural skills.