Data Architect - ETL / Data Warehousing

Job Description :

We are seeking an experienced Data Architect with a strong background in Snowflake and data modeling to join our dynamic team. The ideal candidate will have over 12 years of experience in data architecture, data modeling, and enterprise data warehousing, with specific expertise in the Payer Responsibilities :

• Design and implement scalable database structures using Snowflake.
• Create and maintain conceptual, logical, and physical data models.
• Lead the migration of data warehouses from legacy systems to Snowflake.
• Collaborate with cross-functional teams to gather and analyze data requirements.
• Apply best practices in data modeling and database design.
• Ensure compliance with data governance standards.
• Support data warehousing and ETL processes, particularly using Matillion.
• Perform performance tuning and optimization of complex database queries.
• Interpret client schemas across various data platforms and redesign them for optimal use in :
• Strong proficiency in SQL and dimensional data modeling.
• Hands-on experience with data modeling tools.
• In-depth knowledge of ETL frameworks and tools, especially Matillion.
• Familiarity with cloud platforms, particularly Azure.
• Exposure to visualization tools like Power BI is a plus.
• Experience in the healthcare or payer domain is highly desirable.

ref : hirist.tech)