Data Warehouse Developer

Data Warehouse Developer

About Jones Healthcare Group

Jones Healthcare Group is a world-class provider of advanced packaging and medication dispensing solutions. With over 100 years serving health and wellness markets, the privately held company is moving through an aggressive growth strategy with plans to invest $20 million into the business over the next two years.

“Over a century ago, Jones provided apothecary packaging to help pharmacists safely dispense medication to patients,” says Ron Harris, President & CEO at Jones. “One thing has never wavered since our beginning: we have always been focused on wellness. It’s in our DNA.”

Through its four business units—Cartons & Labels, Packaging Services, Canadian Pharmacy and Medication Adherence —and its three European subsidiaries Venalink UK, Venalink Spain, and MEDI-Clear, the company brings a unique expertise across health sectors to its customers. And, with a continued vision to advance healthcare with progressive packaging platforms, Jones puts consumer well-being first while responding to evolving market needs.

For more information, please visit www.joneshealthcaregroup.com.

Summary of position

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.

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.

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:

• 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 send us 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.