Role : Data Architect

MOI : 2 Video Rounds

Exp : 10 Years

Location : Dallas,TX Hybrid 2 days onsite / week

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

- Experience in SnowFlake migrations
- Understanding of SnowFlake architecture

Regards

Pavan

Sr Technical Recruiter

(7 3 2) - - 7 9 0 - - 2 2 9 0

Pavan(.)kumar(at)primesoftinc(.)com