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