Data Modeler
Express Scripts
Mississauga, ON
The Data Modeler will be responsible for developing conceptual, logical, and physical data models across database platforms at Express Scripts Canada that includes, but not limited to, Oracle, SQL Server, and Hadoop (HIVE, HBase) etc.

As part of an enterprise focused data analytics, business intelligence and reporting initiatives, this position is responsible for collecting, understanding, modeling, documenting, and communicating the data requirements necessary to build and integrate data models for business processes, including performing data rationalization, and collaborating with information stewards, data analysts, and stewardship facilitators. This position is also responsible for developing the data lineage (traceability) to the enterprise data models.

Understand and translate business needs into data models supporting short/long-term solutions.
Develop best practices, develop and maintain naming standards and ETL best practices to ensure consistency of data models.
Work with the Data Strategy team to implement data strategies, build data flows and develop conceptual/logical/physical data models using best practices to ensure high data quality and reduced redundancy.
Maintain, Optimize and update conceptual, logical and physical data models along with corresponding metadata to support new and existing projects.
Recommend opportunities for reuse of data models in new environments.
Perform reverse engineering of physical data models from databases and SQL scripts.
Evaluate data models and physical databases for variances and discrepancies.
Analyze data-related system integration challenges and propose appropriate solutions.
Guide System Analysts, Engineers, Programmers and others on project limitations and capabilities, performance requirements and interfaces.
Review modifications to existing data models to improve efficiency and performance.
Provide physical data models and direct support to data analytics, Business Intelligence and Report development teams during the transformation from logical data models to physical data models implementations/deployments.
Contribute to the development and documentation for information and data management standards and processes.

Bachelor Degree in Computer Science or related field.
5+ years of professional technology experience.
3+ years of experience building conceptual, logical and physical data models.
Experience in the development of data models using the ERWIN or related modeling software(s) is required.
Advance knowledge OLTP/OLAP technologies, data strategy disciplines, relational databases, data warehouse development and Big Data solutions.
Great verbal and written communication skills required.
Knowledge of business process development within health care, life, P&C insurance, health care, or finance is going to be an asset.
Knowledge of enterprise Meta data management, process modeling, and data model development and usage.
Comply with HIPAA, Diversity Principles, Corporate Integrity, Compliance Program policies and other applicable corporate and departmental policies.

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 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.

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

  • LI-NC1