United Biosource Corporation

Compensation

Full 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