Sr. Data Warehouse Engineer (Azure, Snowflake)

UBC is a pharmaceutical support industry leader dedicated to empowering health solutions for a better tomorrow. The Senior Data Warehouse Engineer will be part of the Enterprise Data Warehouse team, responsible for architecture, design, optimization, and governance of the EDW to meet client and business needs.

Responsibilities:

• Design and code efficient and effective solutions for challenging back-end data projects with varying complexity and size
• Develop, test, deploy and schedule complex ETL/ELT solutions to integrate multiple data sources
• Comply with data privacy and governance standards, along with organizational standard operating procedures related to the design, coding, testing, and deployment activities
• Collaborate with cross-functional project teams using exceptional oral and written communication as well the ability to problem solve and recommend solutions
• Support project planning, technical design, development, and solution deployment functions
• Identify opportunities in business processes, system capabilities, and delivery methodologies for continuous improvement
• Act as technical SME for assigned business segments/units supported

Requirements:

• Bachelor's Degree in Computer Science or a related field
• 5+ years experience with modern relational databases and building ETL processes
• 5+ years experience writing and optimizing SQL
• 3+ years experience working with healthcare data as a Data Engineer
• 2+ years experience working with Snowflake
• 2+ years experience working with SQL Server Integration Services (SSIS)
• 2+ year experience building data pipelines in Azure Data Factory
• 2+ year experience working with Azure Synapse
• 2+ year experience working with APIs as a data source for ETL processes
• Experience with ingesting and producing varied file formats (e.g. JSON, XML, etc)
• Proficient with either Python, R or SAS