Data Architect (Snowflake)

Dorchester, MA 02125

Posted: 05/18/2023 Employment Type: Contract Industry: IT,Softworld Corporate,Financial Services,ERT/MSP Job Number: 240593

Job Description

Job Description

This role will be part of a team focused on cloud transformation, modernizing analytics platforms and improving agility. The role requires hands-on experience in building and managing analytics solutions in SnowFlake, Provide direction on adoption of Cloud technologies (Snowflake) and industry best practices in the field of data warehouse architecture and modelling.

Primary duties and responsibilities:
• Establish data architecture strategy, best practices, standards, and roadmap
• Experience with data warehousing and data modeling techniques (Kimball, Lakehouse)
• Engage with business stakeholders to understand strategic, tactical, and operational needs; translate business requirements to technical requirements
• Build Data Flows mapping Source systems and Process flows.
• Mentor team members on best practices, efficient implementations and delivering high quality data products
• Assemble large, complex data sets that meet non-functional and functional business requirements
• Build Data Warehouse Architecture including Data Ingestion, Transformation, Security, and Aggregate layers
• Initiate and facilitate continuous process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes
• Perform code reviews and assist developers in optimization and troubleshooting.
• Review the architectural/ technological solutions for ongoing projects and ensure right choice of solution
• Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features
• Knowledge in AWS and management technologies such as S3.
• Strong written communication skills
• Is effective and persuasive in both written and oral communication

- Possibility of extensions and/or FTE conversion

- Hybrid position
- 2 days a week on-site at the 1601 Elm Street location in Dallas, TX

Must Haves:
- 7-10+ years of experience
- Data Architect/Data Modeling experience
- Experience with relational and dimensional modeling

- Experience in SnowFlake migrations
- Understanding of SnowFlake architecture
Apply Online

Send an email reminder to:

Share This Job:

Related Jobs: