Data Warehouse Engineer

About Jones Healthcare Group

Jones Healthcare Group is a world-class provider of advanced packaging and medication dispensing solutions. With roots firmly established in healthcare, Jones has been a long-time, trusted partner for some of the most recognized global pharmaceutical brands and the largest pharmacy groups, independent pharmacies, hospitals and long-term care facilities across the world.

Imagine working at Jones, where we embrace our commitment to the environment, team members, communities, and consumers – and we’re inspired to package the future of healthcare.

Learn more about our story here: www.joneshealthcaregroup.com.

What our colleagues are saying:

“I love the people, the positive organizational culture, my team and the genuine spirit of cooperation and shared goals. I’m very optimistic about my professional growth and development and the value that I hope to bring to the company.”

What we offer:

• A safe, respectful, 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!

Summary of position:

If you love the idea of immersing yourself in data transformation projects where your curiosity can lead to tangible business results, then this position will be of interest to you.

If you get excited about liaising with a wide range of users, independently owning projects from beginning to end, and solving business problems, then this position is a perfect fit for you.

If you are a naturally a self-motivated problem solver with a key eye for detail, then you’ll want to consider this opportunity.

This hands-on individual leads the design and development of our internal data warehouse using the Microsoft platform.  As someone who has spent years interacting with and extracting data from various systems, this individual will understand how best to build ETL processes and the database objects they populate to provide the best actionable intelligence to end users across the organization.

Here are some of the different activities you’ll be asked to do:

• Design, development and support of data extraction and ingestion using the Microsoft platform
• Model, design and build of data warehouse structures (e.g. tables, views) in collaboration with business and technology partners
• Build, schedule and monitor of automated ETL jobs
• Maintain appropriate documentation for items pertaining to the data warehouse
• Bring in new sources of data by working with the team to explore the global Jones ecosystem
• Support Business and Data Analysts who are building business facing tools using visualization platforms such as Power BI and Tableau
• Work with other areas of technology as needed for planning patching and performance monitoring

If you’ve got:

• Values that mirror ours, from the Inside Out: Inspire, Nimble, Supportive, Inclusive, Driven, Empathetic
• 3 - 5 years of Microsoft SSIS ETL development experience
• 3 - 5 years of Microsoft SQL Server development experience including table, view, index, function, stored procedure and other DDL/DML related development
• 5+ years building data warehouse solutions based on dimensional modeling principles
• Ability to clearly communicate with both technical and non-technical teammates
• Data modeling experience an asset
• Experience extracting and exploring data from core business (such as ERPs) is an asset

We’d like to hear from you!

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.