Virtusa

Data Architect - Snowflake

Job Description

We are seeking an experienced Data Architect with over 10+ years of expertise to join our team. The ideal candidate will possess strong skills in Snowflake, SQL, and data modeling. This role involves designing, developing, and optimizing data architectures and pipelines, ensuring data quality and accessibility for business intelligence and analytics.Design and implement scalable data architectures that meet business requirements.
Develop and maintain comprehensive data models, including conceptual, logical, and physical models.
Perform source-to-target mapping and ensure data integrity across systems.Write and optimize complex SQL queries against Snowflake and other SQL databases.
Develop scripts using Unix, Python, and other relevant languages to automate data extraction, loading, and transformation (ELT) processes.Utilize Snowflake utilities such as SnowSQL, SnowPipe, Tasks, Streams, Time Travel, and Optimizer.
Manage and optimize Snowflake environments for performance and cost-efficiency.
Implement data sharing and stored procedures in Snowflake.Use ETL tools like DBT to design and manage data pipelines.
Ensure data quality and consistency through rigorous testing and validation.
Integrate data from various sources into Snowflake for analysis and reportingAddress complex data issues and continuously improve data processes.
Stay current with industry trends and best practices in data architecture and analytics.Work effectively within a global team environment, collaborating with cross-functional teams.
Communicate findings, designs, and recommendations effectively to both technical and non-technical stakeholders.
Maintain comprehensive documentation for data models, processes, and system configurations.
Participate in Agile delivery processes, contributing to sprint planning, reviews, and retrospectives.Over ten years of experience in data architecture, data engineering, or a related field.Extensive experience with Snowflake and SQL databases.Strong proficiency in Snowflake, including SnowSQL, SnowPipe, and other utilities.
Excellent SQL coding skills and experience with advanced SQL optimization techniques.Proficiency in scripting languages such as Python and Unix.Experience with data modeling tools and methodologies.
Familiarity with ETL tools, specifically DBTStrong analytical skills and attention to detail.
Proven ability to solve complex data problems and implement effective solutions.Excellent communication skills, both verbal and written.
Ability to create clear and comprehensive documentation for data processes and systems.Experience working in a collaborative, team-oriented environment.
Ability to manage multiple priorities and meet deadlines.Experience with metadata management and data governance.
Familiarity with other BI tools such as Power BI or Tableau.
Knowledge of cloud platforms such as AWS or Azure.
Certification in data architecture or data engineering.


Jobs at Chennai

Virtusa

Servicenow Developer

Full Time

Chennai, Tamil Nadu

View Details

Last Date: June 30, 2028

Amazon

Senior Software Development Enginee…

Freshers/Experienced

Chennai, Tamil Nadu

View Details

Last Date: Jan. 7, 2025

Virtusa

Mainframe Senior Lead

Full Time

Chennai, Tamil Nadu

View Details

Last Date: Dec. 31, 2024

Virtusa

Data Analyst - Pharma

Full Time

Chennai, Tamil Nadu

View Details

Last Date: Dec. 31, 2024

Amazon

Application Engineer IV

Freshers/Experienced

Chennai, Tamil Nadu

View Details

Last Date: Jan. 7, 2025

IBM

Application Developer: Sterling Ord…

Professional

Chennai, Tamil Nadu

View Details

Last Date: Jan. 3, 2025

Virtusa

.NET Full Stack Developer

Full Time

Chennai, Tamil Nadu

View Details

Last Date: Dec. 31, 2024

Amazon

RDSE Software Support Engineer, Ring

Freshers/Experienced

Chennai, Tamil Nadu

View Details

Last Date: Dec. 24, 2024

Paypal

Lead Machine Learning Scientist

Freshers/Experienced

Chennai, Tamil Nadu

View Details

Last Date: Dec. 29, 2024

Virtusa

MS Teams (Support Engineer / SME)

Full Time

Chennai, Tamil Nadu

View Details

Last Date: Dec. 31, 2024

Virtusa

Data Analyst

Full Time

Chennai, Tamil Nadu

View Details

Last Date: June 30, 2025

Amazon

System Development Engineer

Freshers/Experienced

Chennai, Tamil Nadu

View Details

Last Date: Jan. 7, 2025




More Jobs at Virtusa

Virtusa

.Net Angular

Full Time

Bangalore, Karnataka

View Details

Last Date: Dec. 31, 2024

Virtusa

Java Developer

Full Time

Pune, Maharashtra

View Details

Last Date: Dec. 31, 2024

Virtusa

ETL Production Engineer

Full Time

Hyderabad, Telangana

View Details

Last Date: Feb. 15, 2025

Virtusa

API Rest Assured

Full Time

Hyderabad, Telangana

View Details

Last Date: Dec. 31, 2024

Virtusa

Salesforce CPQ Architect

Full Time

Chennai, Tamil Nadu

View Details

Last Date: Dec. 31, 2024

Virtusa

Powershell Developer

Full Time

Hyderabad, Telangana

View Details

Last Date: Dec. 31, 2024

Virtusa

Abinitio Consultant

Full Time

Pune, Maharashtra

View Details

Last Date: Dec. 31, 2024

Virtusa

PLSQL Architect

Full Time

Chennai, Tamil Nadu

View Details

Last Date: Dec. 31, 2024

Virtusa

Consultant

Full Time

Hyderabad, Telangana

View Details

Last Date: Dec. 31, 2025

Virtusa

Java FSD

Full Time

Hyderabad, Telangana

View Details

Last Date: Dec. 31, 2024

Virtusa

Mainframe Testing

Full Time

Hyderabad, Telangana

View Details

Last Date: Dec. 31, 2024

Virtusa

Senior Business Product Consultant

Full Time

Hyderabad, Telangana

View Details

Last Date: Dec. 31, 2024