Data Architect: III (Senior)-

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

Interview Process:

- 2 interviews to hire

Required Skills : Erwin (Relational and Dimensional Structure Modeling) High level Architecture designs SQL Server
Basic Qualification :
Additional Skills : Hybrid role
Background Check :Yes
Drug Screen :Yes
Notes :
Selling points for candidate :Hybrid role
Project Verification Info :
Candidate must be your W2 Employee :No
Exclusive to Apex :No
Face to face interview required :Yes
Candidate must be local :Yes
Candidate must be authorized to work without sponsorship ::No
Interview times set :Yes
Type of project :Other Project Type
Master Job Title :Architect: Apps (Other)
Branch Code :Dallas