Report this job

---

What is the problem? *

Incorrect company
Incorrect location
Job is expired
Job may be a scam
Other

Data Architect 

Dallas, TX

Erwin (Relational and Dimensional Structure Modeling) High level Architecture designs SQL Server

Nice to have: AWS Snowflake

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