Overview
On Site
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 6 Month(s)
Skills
Snowflake data warehouse architectures
support both batch and real-time data ingestion
Architect data integration frameworks that support complex transformations
multi-source ingestion
Integration
Ensure data pipelines are resilient
fault-tolerant
and optimized for performance and cost.
Define and implement data quality frameworks
validation rules
monitoring processes.
data governance teams to ensure compliance with data privacy
security
regulatory requirements.
Support metadata management
lineage tracking
data catalog integration.
Monitor and tune Snowflake workloads
including query performance
warehouse sizing
and storage optimization.
Snowflake and data integration.
Lead design reviews and contribute to strategic planning for enterprise data initiatives.
data architecture
data engineering
or enterprise data warehousing.
.Snowflake Expertise
Snowflake architecture
virtual warehouses
Snowpipe
Streams
Snowflake performance tuning
cost optimization
security best practices.
data marketplace
multi-cluster warehouse configuration
Data Integration Pipeline Skills
both batch and streaming data ingestion frameworks
Apache Spark
Kafka
Python
Airflow
design and manage complex ETLELT pipelines integrating data from diverse sources
APIs
cloud storage
on-prem systems
SQL and scripting languages ( Python Shell)
data transformation and orchestration.Data Modeling Governance
data modeling techniques
data governance
data quality frameworks
data cataloging tools and lineage tracking ( Alation Collibra Microsoft Purview).
Job Details
Hi,
Greetings from DIA SOFTWARE SOLUTIONS LLC!
We reaching out about an exciting Direct client opportunity with one of our clients. Please review the requirements and let me know if you are interested in this position?
Direct client Req:: Need Sr Data Architect Snowflake , Onsite
PLEASE SEND THE RESUMES TO SKUMAR AT DIASOFTWARESOLUTIONS DOT COM !
Job Description:
Key responsibilities
Architecture Design:
- Design 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. Internal (Green)Data Ingestion
- Integration:
- Integrate 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 / Quality:
- Define 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 / Optimization:
- Monitor and tune Snowflake workloads, including query performance, warehouse sizing, and storage optimization.
Collaboration / Leadership:
- Provide 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.
Qualifications/Education/Experience:
- Bachelors 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 Expertise
- Deep 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 Skills
- Strong 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 Governance
- Expertise 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 Communication
- Strong 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.
DIA SOFTWARE SOLUTIONS LLC.
Austin, TX 78727| Direct:
DIA SOFTWARE SOLUTIONS is an Affirmative Action/Equal Opportunity Employer that supports workplace diversity. All employment decisions are made without regard to race, color, religion, sex, national origin, age, disability, veteran status, marital or family status, sexual orientation, gender identity, or genetic information. All Diasoft staff must be able to demonstrate the legal right to work in the United States. DIA SOFTWARE SOLUTIONS is an E-Verify employer
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.