Senior Data Warehouse Engineer

February 24

Apply Now

Receive Emails with Similar Jobs

UBC

WebsiteLinkedInAll Job Openings

UBC is a company dedicated to improving patient outcomes by uniting evidence and access to specialty therapies. They offer modern, customized solutions that facilitate patient access, safety, and integrated evidence generation across various therapeutic areas, including oncology and rare diseases. With expertise in risk management, patient support, and data analytics, UBC helps biopharmaceutical companies navigate the complexities of product development and demonstrate the value of medications in real-world settings.

Evidence Development • Modernized Study Design & Execution • Late-Stage Research • Risk Evaluation & Mitigation Strategies • Pharmacovigilance

1001 - 5000 employees

Founded 2003

🧬 Biotechnology

⚕️ Healthcare Insurance

💊 Pharmaceuticals

📋 Description

• As a pharmaceutical support industry leader, UBC is devoted to empowering health solutions for a better tomorrow. • We provide services to enhance the entire drug development process and commercialization lifecycle - From clinical trial support to real-world evidence generation. • The Senior Data Warehouse Engineer will be a part of our Data Warehousing team, who is responsible for providing the direction, planning, and implementation for future development of data warehousing technologies. • Work closely with the technical and business teams to understand their requirements, perform detailed analysis, design the appropriate solutions and implement them within agreed timelines. • Build enterprise data warehouse solutions as per existing policies and support the data and cloud transformation initiatives. • Contribute to design, development and support of data architecture, database design and integration, transformations, and load processes. • Should have strong SQL development skills and be able to setup and troubleshoot SQL Agent Jobs to run SSIS packages. • Create and maintain data integration pipelines using Azure Data Factory to move data between environments/systems. • Develop appropriate solutions to address current and future data warehousing requirements, identify opportunities for process improvement, document and implement them as necessary.

🎯 Requirements

• 7 – 10 years of technology experience with 5+ years of data warehouse experience. • 3+ years of experience developing with Microsoft development stack. • Snowflake experience a plus. • Minimum Bachelor in Computer Science or related degree, Master’s degree in Computer Science, MBA, Analytics a plus. • Pharma Experience a Plus. • Experience with Microsoft Azure ecosystem and proficient in using Azure Data warehouse, Azure SQL Database, Azure DevOps and Azure Data Factory (ADF) products. • Experience in creating data flows and stored procedures using Microsoft Visual Studio. • Nice to have experience with SQL Server Integration Server (SSIS). • Proven ability in written and verbal communication, managing work between multiple projects with better planning and organization skills. • Write functional and design specifications for data warehousing systems and analyze and integrate third party software tools and libraries, as necessary. • Ability to work in a fast-paced environment within the specified deadlines. • Nice to have Microsoft Azure certification. • Nice to have proficiency with one of 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