Data Architect - Snowflake
Diverse Lynx - Dallas, Texas, United States, 75215
Work at Diverse Lynx
Overview
- View job
Overview
Chief Architect
Role Description:
Role - Data Architect - Snowflake , responsibilitiesArchitecture DesignDesign and maintain scalable, high-performance Snowflake data warehouse architectures to support both batch and real-time data ingestion.Define and enforce data modeling standards (e.g., dimensional, normalized, or hybrid) tailored to Snowflakes architecture.Architect data integration frameworks that support complex transformations, multi-source ingestion, and cross-domain data harmonization.DTCC Internal (Green)Data Ingestion IntegrationIntegrate data from diverse sources (e.g., APIs, on-prem databases, cloud storage, third-party feeds) into Snowflake.Ensure data pipelines are resilient, fault-tolerant, and optimized for performance and cost.Data Governance QualityDefine and implement data quality frameworks, validation rules, and monitoring processes.Collaborate with data governance teams to ensure compliance with data privacy, security, and regulatory requirements.Support metadata management, lineage tracking, and data catalog integration.Performance OptimizationMonitor and tune Snowflake workloads, including query performance, warehouse sizing, and storage optimization.Collaboration LeadershipProvide architectural guidance and mentorship to engineering teams on best practices for Snowflake and data integration.Lead design reviews and contribute to strategic planning for enterprise data initiatives.QualificationsEducation ExperienceBachelors or Masters degree in Computer Science, Data Engineering, Information Systems, or a related field.7 years of experience in data architecture, data engineering, or enterprise data warehousing.Proven experience designing and implementing large-scale Snowflake data platforms in production environments.Snowflake ExpertiseDeep understanding of Snowflake architecture, including virtual warehouses, Snowpipe, Streams, Tasks, and Time Travel.Experience with Snowflake performance tuning, cost optimization, and security best practices.Familiarity with Snowflake data sharing, data marketplace, and multi-cluster warehouse configurations.Data Integration Pipeline SkillsStrong experience with both batch and streaming data ingestion frameworks (e.g., Apache Spark, Kafka, Python, dbt, Airflow).Ability to design and manage complex ETLELT pipelines integrating data from diverse sources (e.g., APIs, cloud storage, on-prem systems).Proficiency in SQL and scripting languages (e.g., Python, Shell) for data transformation and orchestration.Data Modeling GovernanceExpertise in data modeling techniques (dimensional, normalized, data vault) and metadata management.Understanding of data governance, data quality frameworks, and regulatory compliance (e.g., GDPR, SOX).Experience with data cataloging tools and lineage tracking (e.g., Alation, Collibra, Microsoft Purview).Leadership CommunicationStrong collaboration skills to work with cross-functional teams including data engineers, analysts, and business stakeholders.Ability to translate business requirements into scalable and maintainable data architecture.Excellent communication and documentation skills to articulate architectural decisions and data strategies.
Competencies:
Digital : Snowflake, Data Architecture and Modeling
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.