Peersight
Employers
Jobs
Companies
Top Cities
Log In
Jobs
Order Picker Customer Service - Work from Home Service Registered Nurse - Emergency Room Chef Caissier Become a Maths Teacher in England Registered Nurse - Emergency Room Service Angular Developer Make up to Livreur Delivery Driver Delivery Driver Make up to Livreur Delivery Driver Delivery Driver - No Experience Needed Make up to Livreur Delivery Driver Livreur Delivery Driver - No Experience Needed Delivery Driver Make up to Make up to Make up to Delivery Driver Delivery Driver - No Experience Needed Delivery Driver - No Experience Needed Make up to Delivery Driver Hardware Sales Associate Part Time Superviseur de d Service Associ Building Maintenance - 1st Shift Service Become a Maths Teacher in England Agent Service Customer Service - Work from Home Teach Science in England CALL CENTRE REPRESENTATIVE Certified Canadian Teachers - Teach Service Service Service Service Certified Canadian Teachers - Teach Certified Canadian Teachers - Teach Newest Jobs
Companies
Yelp ContactMonkey CareGuide Sterling-Turner Clearbanc Exact Media Two Sigma Aecom Aerotek AsteroidX Jane Street Insight Global Akira WeWork Peel Regional Police Doordash Shopify Borrowell First Convenience Bank AT&T American Income Life Square Amazon Flex Vector Marketing Instacart Hatchways Microsoft Walgreens Creative Circle Clickworker Recovhub Scotiabank 51talk UnitedHealth Group LowCostWebDesignFirm.com TD Bank Top Hat Desjardins CI&T Paylocity mappedin Mobeewave Checkout 51 The Youth Connection Hootsuite SnapTravel GoParkr ScribbleLive autoTRADER.ca Xiaomi All Companies
Top Cities
Chicago, Illinois Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs New York, New York Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Toronto, Ontario Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Vancouver, British Columbia Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Calgary, Alberta Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs San Francisco, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Montréal, Quebec Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Los Angeles, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs
Navigation
My Profile Log Out

Data Modeler At Express Scripts

Location: Mississauga, Ontario

Job Description

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.

ESSENTIAL FUNCTIONS:

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

QUALIFICATIONS:

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

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 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 www.express-scripts.ca.

  • LI-NC1

INDEXP