Sr. Data Warehouse Engineer (Azure, Snowflake)

United Biosource Corporation

About The Position

As a pharmaceutical support industry leader, UBC is devoted to empowering health solutions for a better tomorrow. We take pride in improving patient outcomes and advancing healthcare. At UBC, we provide services to enhance the entire drug development process and commercialization lifecycle - From clinical trial support to real-world evidence generation. Embark on a rewarding career journey with UBC! Grow your career while making a meaningful impact on the world around you. UBC fosters a culture built on our Core Values of Respect, Accountability, Innovation, Quality, Integrity, and Collaboration. We believe in an inclusive workplace that fosters creativity. If you are seeking a career that will challenge, inspire, and reward you, join us at UBC! Job Title: ISE94I – Sr. Data Warehouse Engineer Brief Description: The Senior Data Warehouse Engineer will be a part of UBC’s Enterprise Data Warehouse (EDW) team. This team is responsible for the architecture, design, optimization, data modeling, extract/transform/load (ETL), data governance, and solutioning of the EDW. The primary objective of the Senior Data Warehouse Engineer is to ensure the EDW is comprehensive, optimized, well-governed, and meeting the needs of UBC’s client and business teams.

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

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.