Data Modeler ArchitectLocation: Dallas, TX (2 days onsite)Duration: 6 months (Possibility of Extension/C2H)Job 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, providing direction on adoption of Cloud technologies (Snowflake) and industry best practices in the field of data warehouse architecture and modelling. Establish data architecture strategy, best practices, standards, and roadmapExperience 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 requirementsBuild Data Flows mapping Source systems and Process flows.Mentor team members on best practices, efficient implementations and delivering high quality data productsAssemble large, complex data sets that meet non-functional and functional business requirementsBuild Data Warehouse Architecture including Data Ingestion, Transformation, Security, and Aggregate layersInitiate and facilitate continuous process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processesPerform code reviews and assist developers in optimization and troubleshooting.Review the architectural/ technological solutions for ongoing projects and ensure right choice of solutionExpertise 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 featuresKnowledge in AWS and management technologies such as S3.Strong written communication skills