Login | Register

Sr. Data Modeler/Jr. Data Architect to define and maintain an enterprise logical data model and data standardization/harmonization

Job Type: Permanent
Positions to fill: 1
Start Date: Oct 04, 2021
Job End Date: Oct 04, 2021
Pay Rate: Salary: Negotiable
Job ID: 112645
Location: Calgary
Our large oil and gas client is seeking a full-time employee Sr. Data Modeler/Jr. Data Architect to define and maintain an enterprise logical data model and data standardization/harmonization.

Must Have:
  • 8+ years overall experience managing and resolving data related issues or a Bachelor’s degree in Computer Science, Information Management Systems
  • 5+ years data modeling experience
  • 5+ years data governance/management principles, methodologies and tools
  • Experience working with a data modelling tool (ideally Power Designer, Erwin or similar)
  • Experience in facilitating, sharing and adoption of data governance best practices through governance councils/committees, with data stewards and various business stakeholders
  • Relational and dimensional data modelling experience
  • Knowledge of Oracle SQL/noSQL
  • Experience with cloud data management e.g. Microsoft Azure
  • Experience with physical data modelling
Overview: This company is on a journey to transform into a data-informed enterprise, where theirr people are empowered to make data-driven decisions. They are building an Enterprise Data team and have several exciting opportunities! By joining them in the early stages of their journey, you can help shape what Enterprise Data looks like at this company. Help them achieve their goal of transforming data into a strategic enterprise asset that is shared, accessible, trusted, stewarded and secure. With your experience in industry leading data management and architecture practices, you will be a great fit for our team! Using your continuous improvement experience and understanding of how data can be a critical business asset, you will work with partners across the company to ensure their data management and governance standards/policies are adopted.
In this senior level role, you will be responsible for providing hands-on architectural oversight of data flows, with an emphasis on defining and maintaining the enterprise logical data model and driving data standardization. Specifically, you will be accountable to develop conceptual, logical, and physical data models and data flows, supporting digital initiatives across our organization in partnership with business analysts and solution architects.

You will use your expertise to:
  • Analyze data and information requirements
  • Manage data model versioning and integration and prepare data models for deployment
  • Develop and map physical models and align the tables into the canonical data model to align and extend that model
  • Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization
  • Complete hands-on modeling, design, and work with the data engineers on configuration, installation, performance tuning, and sandbox POC
  • Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks
  • Capture relational and dimensional data modeling requirements, data definitions, and business rules
  • Develop and maintain data modeling standards
  • Work as a subject matter expert on high priority initiatives
  • Act as a domain expert for the Design and Build stage of delivery and works with Data Engineer/Wranglers to ensure the robustness of underlying foundation
  • Ensure adherence to standards across data product initiatives
Location: Calgary - This client will transition eventually to a 3 day/week in office hybrid model. Must show proof of vaccination or a negative test each 72 hours to come into the office. Relocation support will be provided if you're not in Calgary already.