Snowflake Data Architect @ NJ or VA - onsite/hybrid

What Working at Hexaware Offers:

Hexaware is a dynamic and innovative IT organization committed to delivering cutting-edge solutions to our clients worldwide. We pride ourselves on fostering a collaborative and inclusive work environment where every team member is valued and empowered to succeed.

Hexaware provides access to a vast array of tools that enhance, revolutionize, and advance professional profiles. We complete the circle with excellent growth opportunities, chances to collaborate with high-profile customers, opportunities to work alongside brilliant minds, and the perfect work-life balance.

Role: Snowflake Sr. Data Architect Job Description

Location: New Jersey or Arlington, VA

Duration: FTE

This role is a hands-on technical role and primary responsibilities includes but not limited to Architecting, Designing and Implementing snowflake DW in AWS or Azure.

Key Responsibilities are:

• Strategic planning and hands-on engineering of Snowflake/Big Data and cloud environments that supports our clients advanced analytics and data science initiatives.
• Provide support in defining the scope and sizing of work
• Working closely with various enterprise architects Information security teams, Data management team, to ensure the architected solution meets all the needs of a customer, from a functionality perspective and IT solution engineering perspective.
• Lead designing all aspects of our data solution including artifact creation such as diagrams, playbooks and other technical documents.
• Translate business requirements into technology solutions
• Mentor and guide Jr. team members to deliver the solutions on time.
• Create various architecture blueprints and work with the development team to deliver the vision.

Skills:

• Overall 10+ years of experience with Data Management, Big Data, Data Warehousing and Analytics.
• At least 3 to 4 years of experience in Architecting and Implementing Data Solutions using Snowflake in AWS environment.

• In depth understanding of Snowflake Architecture including Snow SQL, Performance tuning, Compute and Storage

• Expertise in Snowflake - data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts
• Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, Adaptive computing, query performance tuning, Zero copy clone, time travel, Cortex AI and understanding how to use these features
• Expertise in deploying Snowflake features such as data sharing.
• Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python
• Hands on working experience with DBT is must have skill.
• In-depth understanding of various storage services offered by AWS.

• Experience with implementation of data security, encryption, PII/PSI legislation, identity and access management across sources and environments.

• Experience with data process Orchestration, end-to-end design and build process of Near-Real Time and Batch Data Pipelines
• More than one year of multi-cloud experience in at least two of the three public Cloud Platforms (AWS, Azure and Google Cloud Platform)
• Certification in Snowflake is preferred
• Strong client-facing communication and facilitation skills.
• Two to three years of prior experience in Healthcare and Payer Domain is must.

Equal Opportunities Employer:

Hexaware Technologies is an equal opportunity employer. We are dedicated to providing a work environment free from discrimination and harassment. All employment decisions at Hexaware are based on business needs, job requirements, and individual qualifications. We do not discriminate based on race including colour, nationality, ethnic or national origin, religion or belief, sex, age, disability, marital status, sexual orientation, parental status, gender reassignment, or any other status protected by law. We encourage candidates of all backgrounds to apply.