The Sr. Data Engineer will be responsible for expanding and optimizing the data and data pipeline architecture across the enterprise.  The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up. The Sr. Data Engineer will support our software developers, data architects, data analysts and data scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects. They must be self-directed and comfortable supporting the data needs of multiple teams, systems and products. The right candidate will be excited by the prospect of optimizing Express Script Canada’s data architecture to support our next generation of products and data initiatives.

Key Responsibilities:

• Create and maintain optimal data pipeline architecture.

• Assemble large, complex data sets that meet functional / non-functional business requirements.

• Optimize the value of technology investments in data management for the business by aligning the business architectures with technology architectures. Identify and drive key technology investments to meet business objectives, remediate technology and process gaps. Determine feasibility, cost and time required, compatibility with current system, and system capabilities.

• Identify product, technology and process gaps in current data & technology architectures and recommend solutions to bridge gaps between the business and the data & technology deployed to support the business.

• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.

• Coordinate with data users and key stakeholders across ESC’s Lines of Business to refine and achieve various long-term objectives for data architecture

• Work with stakeholders including Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.

• Create data tools for analytics and data scientist team members that assist them in building and optimizing our product.

• Work with data and analytics experts to strive for greater functionality in our data systems.

Qualifications:

• Minimum 6 years of experience in a large-scale, multi-platform, multi-tier processing environment with a Bachelor’s degree in Information Systems or related field

• Extensive experience on projects implementing Master Data Management and Enterprise Content Management techniques and platforms.

• Expert domain knowledge & experience in data warehousing, reporting and advanced analytics platforms, encompassing data model design, dimensional modeling, master data management, cross-cutting concerns, common integration technologies, patterns & standards and emerging technologies.

• Advanced knowledge of data architecture and analytics principles and practices for application development and data warehousing purposes.

• Advanced knowledge of data model development and governance methods and practices.

• Previous data management experience in a data warehouse and data lake environment.

• Experience with enterprise database consolidation, data warehouse migration and/or consolidation to data lakes or integrated data architectures.

• Highly proficient in Relational Database Management Systems
  (RDBMS) and Big Data, data architecture, data modeling (including dimensional),
  data warehousing, object-oriented methodologies, and client/server development.

• Advanced knowledge of PowerDesigner or similar Data Modelling Tool

• Advanced knowledge of Talend or similar Data Integration Tool

• Hands-on experience implementing data profiling tools

• Experience implementing data visualization tools like Oracle Analytics Server, Tableau, Qlik, etc.

• Strategic thinker with ability to formulate plans, strategies and outcomes

• Willingness to work a flexible schedule to accommodate project deadlines and travel requirements

Assets:

• Knowledge of Microsoft Dynamics AX and underlying data model.

• Knowledge of the group health insurance (pharmacy, dental, other health) industry or adjudication systems is an asset

• Knowledge of advanced analytics tools like R, SAS, and machine learning algorithms.

• Knowledge of one or more programming or scripting languages like Java, C, C#, .Net, Javascript, PHP, Python

• Practical experience with Talend for Data Integration

• Practical experience with Oracle Analytics Server for visualizations

• Knowledge of the DAMA Book of Knowledge

• Knowledge of Big Data & Logical Warehouse architecture

• Knowledge of TOGAF, Zachman or other
  architecture frameworks

ABOUT THE DEPARTMENT

Applications Delivery ensures that Express Scripts Canada load balancing techniques are robust and can handle the increasingly complex mix of application traffic being delivered over a wider variety of network connectivity options. Specifically, this team provides for application availability, security, visibility and acceleration.

ABOUT EXPRESS SCRIPTS CANADA

Express Scripts Canada, a registered business name of ESI Canada, an Ontario partnership indirectly controlled by Express Scripts, Inc. (Nasdaq: ESRX), is one of Canada’s leading providers of health benefits management services. From its corporate headquarters in Mississauga, Ontario, just outside Toronto, Express Scripts Canada provides a full range of integrated pharmacy benefit management (PBM) services to insurers, third-party administrators, plan sponsors and the public sector, including health-claims adjudication and processing services, Home Delivery Pharmacy Services, benefit-design consultation, drug-utilization review, formulary management, and medical and drug-data analysis services, to better facilitate the best possible health outcomes at the lowest possible cost.

It will be a condition of employment that the successful candidate receives the Enhanced Reliability Clearance from the Federal Government. The candidate will be required to provide supporting documentation in order to receive Clearance if required.

We offer a competitive salary, along with a positive work environment built on solid corporate values, integrity, mutual respect, collaboration, passion, service and alignment.

We are an equal opportunity employer that promotes a diverse, inclusive and accessible workplace. By embracing diversity, we build a more effective organization that empowers our employees to be the best that they can be.

We are committed to creating a working environment that is barrier-free and we are prepared to provide accommodation for people with disabilities. Thank you for your interest in this position, however only qualified candidates will be contacted for an interview. No telephone calls please.

For more information about Express Scripts Canada, visit its Web site at www.express-scripts.ca.

Internal candidates should apply before December 13, 2021.

Express Scripts Canada is a Cigna company

Express Scripts Canada is a subsidiary of Express Scripts, a Cigna company. Cigna Corporation (NYSE: CI) is a global health service company dedicated to improving the health, wellbeing and peace of mind of those we serve. Cigna offers an integrated suite of health services through Cigna, Express Scripts, and our affiliates including medical, dental, behavioural health, pharmacy, vision, supplemental benefits, and other related products.

About Express Scripts Canada

Express Scripts Canada is a leading health benefits manager and has been recognized as one of the most innovative. Our clients include Canada's leading insurers, third party administrators and governments. We work with these clients to develop industry-leading solutions to deliver superior healthcare in a cost-controlled environment. We provide Active Pharmacyâ„¢ services to more than 7 million Canadian patients and adjudicate more than 100 million pharmacy, dental, and extended health claims annually. Through our proprietary consumer intelligence, clinical expertise, and patients-first approach, we promote better health decisions for plan members, while managing and reducing drug benefit costs for plan sponsors.

It will be a condition of employment that the successful candidate obtains an Enhanced Reliability Clearance from the Federal Government. The candidate will be required to provide supporting documentation to receive clearance if required.

We offer a competitive salary and benefits package, along with a positive work environment built on solid corporate values, integrity, mutual respect, collaboration, passion, service and alignment.

We are an equal opportunity employer that promotes a diverse, inclusive and accessible workplace. By embracing diversity, we build a more effective organization that empowers our employees to be the best that they can be.

We are committed to creating a working environment that is barrier-free and we are prepared to provide accommodation for people with disabilities.

If you require accommodation in completing the online application process, please email: eschr2@express-scripts.com Do not email eschr2@express-scripts.com for an update on your application or to provide your resume as you will not receive a response.