Data Warehouse Engineer

by Jones Healthcare Group

Position Type: Full-time
Location: London, ON
Date Posted: Jun 10, 2024
Jones Healthcare Group

Job Description

Data Warehouse Engineer

Join Jones Healthcare Group - Where Innovation Meets Purpose!
At Jones, we’re committed to the environment, our team, communities, and consumers, and we're inspired to make a meaningful impact through advanced packaging and medication dispensing solutions.
Our Packaging Services Business Unit offers a series of primary and secondary packaging services for pharmaceutical, natural health product, medical device, personal care, wellness, and specialty markets. 
Learn more about us here:
Summary of position:
If you love diving deep into data, uncovering insights, and solving complex puzzles creatively and precisely, you should consider this opportunity.
If you get inspired by the prospect of shaping data infrastructure and processes to optimize organizational performance, then this position will be of interest to you.
If you are driven by a passion for innovation and continuous improvement, identifying opportunities to enhance data management, then you’ll want to consider this opportunity.
As a Data Warehouse Engineer, you will play a pivotal role in building and maintaining our data warehouse infrastructure, collaborating with cross-functional teams to collect requirements, design databases, analyze data, and implement data administration policies.
More about your responsibilities:

  • Design, develop, and maintain multiple databases within the data warehouse.
  • Create, implement, and test data models and database management systems.
  • Conduct research and support internal/external groups with the selection and implementation of applications and database management tools.
  • Identify and utilize database management systems to aggregate and analyze data.
  • In collaboration with the VP, IBT and the Senior Data Warehouse Engineer, develop and implement data administration policies, standards, and models.
  • Work with internal departments and colleagues to understand and document specific data and user requirements, data collection and administration policies, and data access rules.
  • Develop and implement procedures for determining network access and usage and for the backup and recovery of data.
  • Write scripts to support automation, data extraction, and reporting.
  • Design and automate routine and self-service reporting solutions (i.e., Power BI).
  • Identify opportunities and provide recommendations to enhance efficiencies in data management and analysis.
  • Create and maintain system context diagrams and process maps, capturing flows of information between systems and typical customer flows.
  • Analyze business operations and workflows to understand and define opportunities where information solutions can be implemented to mitigate business challenges.
  • Perform ad-hoc data extraction, analysis, and interpretation.
What you’ll bring
  • Values that mirror ours, from the Inside Out: Inspire, Nimble, Supportive, Inclusive, Driven, Empathetic.
  • University or College Degree/Diploma in computer science, finance, or business analysis.
  • 2+ years of experience in a data warehouse, business analysis, or data analysis role.
  • Proficiency in T-SQL, ETL Process, Python, R, and/or other programming languages.
  • Ability to develop methodologies and approaches for new tasks and projects.
  • Knowledge of data mining and segmentation techniques.
  • Strong interest in data analysis and developing creative solutions to problems.
  • Experience in transforming raw data into meaningful insights through data visualization and analysis.
  • Experience creating data sets from various data sources, leveraging automation to ensure data quality and accuracy.
  • Excellent communication, collaboration, and interpersonal skills.
We care about our colleagues, some benefits we offer are:
  • A safe, respectful, diverse, and inclusive environment
  • Competitive compensation and equitable people practices
  • Comprehensive benefits and an RRSP program where we match up to 5% of your earnings
  • Opportunities to grow and develop, alongside a supportive team
  • Employee and family assistance program
  • Referral bonuses
  • Education reimbursement program
  • Colleague appreciation events
  • and more!
Join us in shaping the future of healthcare! Apply now to join our dynamic team and make a meaningful impact in a collaborative environment.
Please submit a resume and let us know why you are interested.
While we thank all candidates for their interest, only those selected for an interview will be contacted.
As part of our commitment to accessibility for all persons with disabilities, Jones Healthcare Group will, upon the request of the applicant, provide accommodation during the recruitment process to ensure equal access to applicants with disabilities. Please contact the Jones Human Resources department at 1.800.265.9093 about your needs, and we will consult with you to ensure suitable accommodation is provided.
For all feedback on equity and accommodation needs, please also contact the Human Resources department.