Sr. Data Warehouse Engineer

Job Title

ISE
94I – Sr. Data Warehouse Engineer

The Senior Data Warehouse Engineer will be part of our Data Warehousing team, responsible for providing 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.

• Work closely with technical and business teams to understand requirements, perform detailed analysis, design appropriate solutions, and implement them within agreed timelines.
• Build enterprise data warehouse solutions as per existing policies and procedures and support data and cloud transformation initiatives.
• Contribute to the design, development, and support of data architecture, database design, integration, transformations, and load processes.
• Have discussions with internal and external stakeholders, understand business processes, create design and mapping documents, and guide junior resources.
• Proven experience with data warehousing and data modeling using Microsoft Azure data management technologies, creating and maintaining SQL data structures and stored procedures.
• Work with and/or transform structured, semi‑structured, and unstructured data.
• Develop appropriate solutions to address current and future data warehousing requirements, identify opportunities for process improvement, document and implement them.
• 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.
• Have strong SQL development skills; set up 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.
• Work independently as well as a team player as needed.

• 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’s degree in Computer Science or related field;
  Master’s degree, MBA, Analytics a plus.
• Pharma experience a plus.
• Experience with Microsoft Azure ecosystem and proficiency in using Azure Data Warehouse, Azure SQL Database, Azure Dev Ops, and Azure Data Factory (ADF) products.
• Experience creating data flows and stored procedures using Microsoft Visual Studio; nice to have experience with SQL Server Integration Services (SSIS).
• Proven ability in written and verbal communication, managing work between multiple projects with strong 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 specified deadlines.
• Nice to have Microsoft Azure certification.
• Nice to have proficiency with one of Python, R or SAS.

• Competitive salaries
• Growth opportunities for promotion
• 401(k) 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