Key Facts

Remote From:

United States

Full time

Senior (5-10 years)

English

Hard Skills

Other Skills

•
Teamwork
•
Verbal Communication Skills
•
Problem Solving

Roles & Responsibilities

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
2+ years experience working with Snowflake

Requirements:

Design and code efficient and effective solutions for 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 SOPs related to the design, coding, testing, and deployment activities
Collaborate with cross-functional project teams using strong oral and written communication to problem solve and recommend solutions

UBC

Pharmaceuticals

About UBC

Dedicated to Global Product Safety, Brand Loyalty, and Patient Access Strategies that Support the Full Product Lifecycle United BioSource LLC (UBC) is a leading provider of pharmaceutical support services, partnering with life science companies to make medicine and medical products safer and more accessible. Our diverse suite of services helps bridge the gap between development and delivery and builds brand loyalty through patient access and adherence. UBC is well known for our ability to generate authoritative, real-world evidence of product effectiveness, safety, and value to assist healthcare decisions and enhance patient care. Developing a drug, taking it through commercialization, and demonstrating its post-launch value and safety is a complex journey. Regulatory hurdles and payer decision-making are increasing the complexity around drug development and product choices. UBC has aligned our expertise and industry insight to help manufacturers make informed decisions early in the product journey that ultimately optimize care and improve patient outcomes. The most successful product journeys start with great maps. UBC’s industry-leading experts work in unison to effectively navigate the product lifecycle, focusing on: Clinical Development Safety Commercialization We understand what it takes to compete in a crowded product market with many stakeholders that demand the right evidence at the right time. Our Past, Present, and Our Future UBC was founded in 2003 by industry experts with a passion for innovation and a commitment to working with pharmaceutical and biotech organizations in proving the safety, efficacy, and value of pharmaceutical and medical products. We recognized the opportunity to build an organization tailored to meet the need for scientific evidence in the healthcare industry. And, we quickly developed our core strength – the generation, analysis, and communication of real-world evidence throughout the product lifecycle.

Company type: Large

Industry: Pharmaceuticals

Founded: 2018

Company size: 1001 - 5000

Website LinkedIn See all jobs →

Job description

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.

Primary 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.

Required 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:

At UBC, employee growth and well-being are always at the forefront. We offer an extensive range of benefits to ensure that you have everything you need to thrive personally and professionally.

Here are some of the exciting perks UBC offers:

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

UBC is proud to be an equal opportunity employer and does not discriminate because of race, color, sex, age, national origin, religion, sexual orientation, gender identity and/or expression, status as a veteran, and basis of disability or any other federal, state, or local protected class. We are committed to a diverse, equitable and inclusive culture that fosters respect for each other, our clients, and our patients.

#LI-JS1

#LI-REMOTE

Ready to apply?

APPLY

Share ·