Data Architect (Snowflake)

Dorchester, MA 02125

Posted: 05/18/2023 Employment Type: Contract Industry: IT Job Number: 240593-1

Job Description


Job Description

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

Duration:
- Possibility of extensions and/or FTE conversion

Location:
- 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

Plusses:
- Experience in SnowFlake migrations
- Understanding of SnowFlake architecture
Apply Online
Apply with LinkedIn Apply with Facebook Apply with X

Send an email reminder to:

Share This Job:

Related Jobs:

About Dorchester, MA

Discover exciting job opportunities in the vibrant area surrounding Dorchester, Massachusetts! Nestled just a stone's throw away from Boston, this charming neighborhood offers an irresistible blend of rich history, diverse culture, and endless growth prospects. From strolls along the picturesque waterfront at John F. Kennedy Presidential Library and Museum to indulging in delicious seafood at local eateries like D Bar or The Industry, Dorchester is a hub of creativity and innovation. With renowned attractions like the Edward M. Kennedy Institute for the United States Senate and proximity to iconic venues such as Fenway Park, the city beckons job seekers with a mix of urban allure and small-town charm. Dive into our job listings today and embark on a career journey in this dynamic region!