What are the responsibilities and job description for the Sr. Data Warehouse Engineer position at United BioSource?
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 our Data Warehousing team, who is responsible for providing the direction, planning, and implementation for future development of data warehousing technologies as well as identifying and evaluating newer technologies to help UBC implement those tools at the cutting edge of the industry.
Specific job duties :
- Work closely with the technical and business teams to understand their requirements, perform detailed analysis, design the appropriate solutions and implement them within the agreed upon timelines.
- Build enterprise data warehouse solutions as per existing policies and procedures and support the data and cloud transformation initiatives.
- Contribute the design, development and support of data architecture, database design and integration, transformations, and load processes.
- Have discussions with internal and external stakeholders, understand the business processes, create design and mapping documents and guide the junior resources in the team.
- Proven experience with data warehousing and data modeling using Microsoft Azure data management technologies, creating and maintaining SQL data structures and store procedures.
- Should be able to work with and / or transform structured, semi structured and unstructured data.
- Develop appropriate solutions to address current and future data warehousing requirements, identify the opportunities for process improvement, document and implement them as necessary.
- Possess working knowledge of Cloud based data warehousing tools, Relational Database Management Systems and Data integration tools.
- Perform analysis of external data sources and perform source-to-target mapping of an external source to a common data model in enterprise data warehouse.
- Should have strong SQL development skills and should 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.
- Should be able to work independently as well as a team player as needed.
Supervisory Responsibility :
N / A
Desired Skills and Qualifications :
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 :
