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