Overview
On Site
Depends on Experience
Full Time
Skills
Snowflake
DBT
ELT
SQL
AWS
Azure
Data Analysis
Data Science
Data Warehousing
Job Details
Job Details:
Job Title: Data Architect / Snowflake Architect
Location: Various Locations in United States (on Site)
Total 10+ experience required
Job Summary:
We are seeking a highly experienced Sr. Data Architect / Sr. Snowflake Architect with strong hands-on expertise in Snowflake, DBT, and SQL. The ideal candidate will play a key role in designing and optimizing scalable data architectures, building robust data pipelines, and enabling data analytics and reporting across the organization.
Key Responsibilities:
- Design, develop, and maintain scalable data models and pipelines using Snowflakeand DBT.
- Build and optimize ELT processes to support data ingestion and transformation workflows.
- Create efficient, reusable SQL code to transform and analyze large datasets.
- Implement data quality checks, monitoring, and documentation practices.
- Collaborate with Data Analysts, Data Scientists, and Business Stakeholders to understand data requirements.
- Ensure data security, governance, and performance tuning within the Snowflake environment.
- Define and enforce data modelling and engineering standards and best practices.
- Integrate Snowflake with cloud platforms (AWS, Azure, Google Cloud Platform) and ETL tools (Informatica, DBT, Talend).
- Lead deployment of Snowflake solutions including data ingestion, transformation, and visualization.
- Architect end-to-end data warehousing and analytics solutions using Snowflake.
- Design scalable and efficient data architectures aligned with business needs and best practices.
- Develop and manage data pipelines and workflows.
- Optimize performance of data integration processes.
- Integrate Snowflake with cloud platforms (AWS, Azure, Google Cloud Platform) and ETL tools (Informatica, DBT, Talend).
- Lead deployment of Snowflake solutions including data ingestion, transformation, and visualization.
- Design and implement data governance and security policies.
- Ensure data accuracy, consistency, and compliance.
- Conduct discovery sessions and technical demos.
- Provide expert guidance during pre-sales and solution design stages.
- Document architectural solutions and best practices.
- Train internal teams and clients on Snowflake usage
Required Qualifications:
- Bachelor's degree in computer science, IT, Data Science, or related field.
- 5 years of experience in data architecture or solution architecture.
- 3 years of hands-on experience with Snowflake.
Experience:
- Proficiency in data sharing and zero-ETL integration Strong understanding of data warehousing, data modeling, and ETLELT processes.
- Proficiency in SQL, Python, and cloud platforms (AWS, Azure, Google Cloud Platform).
- Experience with BI tools (e.g., Power BI, Tableau).
- Excellent problem-solving, communication, and collaboration skills.
Preferred Skills:
- Domain Knowledge on SAP CRM Salesforce CRM is an added advantage Experience with forecasting, anomaly detection, and classification using Snowflake.
- Familiarity with data integration tools like MuleSoft, Streamsets.
- Ability to lead technical presentations and proof-of-concepts.
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.