Cloud Data Architecture Engineer

Memorial Hermann Health System is dedicated to delivering high quality, efficient care and exceptional experiences to its community. The Cloud Data Architecture Engineer will design and build data processes and infrastructure for analytical and operational use cases, collaborating with various customers to onboard and integrate data while ensuring data quality and governance.

Responsibilities:

• Responsible for analysis, design and development of analytics data pipelines
• Completion and maintenance of source to target mapping across core systems
• Responsible for working with customers to identify data on-boarding needs and implement end-to-end solutions
• Build data flow for data warehousing projects
• Proactively curate data sources to meet the needs of customers
• Actively ensure data sources are tuned to handle data in the most efficient manner possible to maximize performance
• Maintain and monitor data warehouse and ensure data uptime
• Work with Analytics Team, specifically Data Architect, to identify, notify and manage downtimes with minimal disruptions
• Educate broader employee base on data architecture methods to gain efficiencies and data insights
• Serve as in-house resource for various types of data ETL methodologies and guide customers to the best option for quick turnaround of BI tasks
• Assist in development of task plans including schedule and effort estimation
• Participate in governance activities
• Lead solution development across multiple analytic projects
• Demonstrates commitment to caring for every member of our community by creating compassionate and personalized experiences. Models Memorial Hermann’s service standards by providing safe, caring, personalized and efficient experiences to patients and colleagues

Requirements:

• Bachelor's Degree in Computer Science, Electrical Engineering, Mathematics, Computer Applications, Information Systems or Engineering, or four (4) years of equivalent experience is required
• Five (5) years of experience in data warehousing required
• Expert SQL Experience required
• Demonstrated experience with all phases of the design and development life cycle of analytics applications and reporting tools
• Must have advanced programming language skills (i.e., Python, R, SQL)
• Must have advanced knowledge of extract, transform, and load (ETL) tools
• Must be knowledgeable of best practices for designing highly-tuned datasets to meet business requirements and optimize end-user performance
• SNOWPRO preferred
• Minimum of one (1) year experience in Snowflake preferred or experience in other data warehousing such as Redshift or BigQuery
• SnowSQL preferred
• Experience with deploying models using Snowflake functions preferred
• Experiencing working in cloud infrastructure, AWS preferred
• Experience with Tableau, Tableau Prep, and Tableau Server, preferred
• Experience utilizing HealtheIntent, preferred