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. 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.
Senior Data Warehouse Engineer
Location
United States
Posted
1 day ago
Salary
Not specified
Seniority
Senior
Job Description
Role 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.
- 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.
Qualifications
- 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
Benefits
- Competitive salaries
- Growth opportunities for promotion
- 401K with company match*
- Tuition reimbursement
- Flexible work environment
- Discretionary PTO (Paid Time Off)
- Paid Holidays
- Employee assistance programs
- Medical, Dental, and vision coverage
- HSA/FSA
- Telemedicine (Virtual doctor appointments)
- Wellness program
- Adoption assistance
- Short term disability
- Long term disability
- Life insurance
- Discount programs
Job 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
Benefits
- Competitive salaries
- Growth opportunities for promotion
- 401K with company match*
- Tuition reimbursement
- Flexible work environment
- Discretionary PTO (Paid Time Off)
- Paid Holidays
- Employee assistance programs
- Medical, Dental, and vision coverage
- HSA/FSA
- Telemedicine (Virtual doctor appointments)
- Wellness program
- Adoption assistance
- Short term disability
- Long term disability
- Life insurance
- Discount programs
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
Staff Data Platform Engineer (ClickHouse | OLAP)
Growth Acceleration PartnersConsult • Design • Build • Modernize
The Staff Data Platform Engineer will architect and optimize large-scale ClickHouse or OLAP databases, designing distributed systems capable of handling multi-terabyte datasets and defining best practices for analytical data models and query performance. This role also involves mentoring engineers on system design, guiding architectural decisions, and ensuring the platform supports real-time analytics and AI workloads.
The primary responsibility involves architecting, implementing, and optimizing cloud-based solutions while leveraging industry best practices. This role also requires mentoring junior engineers and driving continuous improvement across CloudOps and DevOps practices.
Data Operations Engineer enabling data-driven decision-making for Veritone
The Data Architect will own and evolve the end-to-end architecture for the Consumer Canvas platform, designing systems across ingestion, identity spine creation, enrichment, governance, and activation workflows. This strategic role involves defining and enforcing PII governance, privacy controls, and security best practices while translating complex requirements into scalable architecture.
