Data Architect (Snowflake)

23 May 2024

Vacancy expired!

Job Number: 240593

Data Architect (Snowflake)

Duration: 7+ months

Location: Dallas, TX - hybrid 2 days onsite / week

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

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

Duration: - Possibility of extensions and/or FTE conversion Location: - Hybrid position - 2 days a week on-site at the office location in Dallas, TX

THIRD PARTY AGENCIES, SUBCONTRACTORS, AND RECRUITERS NEED NOT APPLY. Applicants received from firms will not be considered. Subcontracting is not available for this position.

  • ID: #49982622
  • State: Texas Dallas / fort worth 75270 Dallas / fort worth USA
  • City: Dallas / fort worth
  • Salary: USD TBD TBD
  • Job type: Contract
  • Showed: 2023-05-23
  • Deadline: 2023-07-21
  • Category: Et cetera