What are the responsibilities and job description for the Snowflake Architect position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, STAFFWORXS LLC, is seeking the following. Apply via Dice today!
Job Title: Azure & Snowflake Data Platform Architect
Location: McKinney, TX
Experience: 14 years
Role Overview:
We are seeking a highly experienced Azure & Snowflake Data Platform Architect to design, implement, and oversee scalable, enterprise-grade data platforms. This role will involve translating complex business requirements into robust technical architectures, supporting large-scale data ingestion, transformation, and analytics, and enabling real-time insights across the organization, including post-merger and acquisition scenarios.
Key Responsibilities:
Data Platform Architecture & Engineering
Job Title: Azure & Snowflake Data Platform Architect
Location: McKinney, TX
Experience: 14 years
Role Overview:
We are seeking a highly experienced Azure & Snowflake Data Platform Architect to design, implement, and oversee scalable, enterprise-grade data platforms. This role will involve translating complex business requirements into robust technical architectures, supporting large-scale data ingestion, transformation, and analytics, and enabling real-time insights across the organization, including post-merger and acquisition scenarios.
Key Responsibilities:
Data Platform Architecture & Engineering
- Design Azure-based Snowflake data platform architectures that support both current and future data needs, including requirements arising from mergers and acquisitions (M&A).
- Build and implement high-performance data pipelines for data ingestion, transformation, and delivery across data lakes, data warehouses, real-time streaming, and event-driven architectures.
- Develop reusable patterns for data ingestion, modeling, and delivery leveraging Snowflake, Azure Cloud, dbt, and Matillion.
- Ensure data architecture aligns with master data strategy, enterprise business objects, and real-time integration initiatives.
- Architect Power BI enterprise reporting models with semantic layers and governed datasets.
- Define and enforce BI best practices, including version control, workspace management, row-level security, and usage optimization.
- Support Fabric and Power BI Service evolution toward real-time analytics and cross-ERP insights.
- Drive integration architecture across multiple ERP systems, aligning to an enterprise object model.
- Lead technical assessment, mapping, and onboarding of newly acquired companies from a data and BI integration perspective.
- Evaluate current data warehouses, data lakes, and ETL pipelines to identify redundancies and opportunities for consolidation.
- Strong experience with Snowflake, Microsoft Azure, dbt, Matillion, and Power BI.
- Proven expertise in data platform design, ETL/ELT pipeline development, and data modeling.
- Solid understanding of enterprise data architecture, master data management, and integration strategies, especially in M&A contexts.
- Hands-on experience with real-time streaming, event-driven architectures, and cross-ERP analytics.
- Excellent communication, stakeholder management, and solutioning skills.