Specialist Data Design - Jobs in Saddledome

Job Description

At CN, we work together to move our company-and North America-forward. Be part of our Informationamp; Technology (I amp;T) team, a critical piece of the engine that keeps us in motion. From enterprise architecture to operational technology, our teams use the agile methodology to automate and digitize our railroad ensuring our operations run optimally and safely and our employees can focus on value-added tasks. You will be able to develop your skills and career in our close-knit, safety-focused culture working together as ONE TEAM. The careers we offer are meaningful because the work we do matters. Join us!Job SummaryThe Specialist, Data Design is responsible for understanding business requirements, creating data definitions, business rules, data quality requirements, as well as logical and physical models. The role supervises and maintains the Data Management (DM) practice within the team. The incumbent brings technical expertise to ensure the quality and accuracy of data, then process, designs and presents it in ways to help people, businesses, and organizations make better decisions. The position ensures data integrity and normalization, and oversees and designs the reporting environment, including data sources, security, and metadata.Main ResponsibilitiesData Design and Management

• Build conceptual, logical, and physical data models using Erwin
• Build source to target mapping documents to describe data transformations
• Design and develop curated data assets in Data Lake and Data Warehouse to support operational reporting, data science and self-service analytics
• Define, document, and maintain standards and best practices around data modelling
• Perform DM reviews
• Handle the onboarding, support and mentorship of new data modellers
• Perform profiling and analyze data using Structures Query Language (SQL) and Python on multiple sources (e.g., Oracle, Netezza, SQL-Server, Databricks, etc.)

Testing, Troubleshooting and Delivery

• Assess and design data architecture components (e.g., data model, mapping, data flows, and transformations) to make sure they are well integrated and aligned with the data and technical architecture
• Troubleshoot data issues within the business and present solutions and recommendations
• Define unit testing to ensure Data Engineers follow specifications
• Participate in the delivery and support of data quality and consolidation initiatives
• Propose simplification initiatives to allow for more effective data design, and management

Working ConditionsThe role has standard working conditions in an office environment with a regular workweek from Monday to Friday.RequirementsExperienceData Design and Modelling

• Between 5 to 7 years overall work experience

o Minimum 4 years of experience in analysis, data design and data modellingo Experience performing root cause analysis to answer specific business questions and identify opportunities for improvemento Experience in real time data streaming and loading*o Experience modelling data for data science projects*o Experience working with Scale Agile Methodology (SAFe)*o Experience with semi-structured and unstructured data*

• Any experience for these above would be considered as an asset

Education/Certification/Designation

• Bachelor #39;s Degree specializing in Mathematics and Statistics, Computer Science, Business Analytics, or other quantitative field, related degree, or equivalent experience

Competencies

• Inspires others with impactful communications and adapts to the audience through speech and writing
• Applies analytical thinking
• Innovates through problem solving
• Knows the business and stays current with industry trends to elevate expertise and work
• Demonstrates organizational abilities
• Collaborates with key internal stakeholders to enable higher productivity
• Works independently with little supervision

Technical Skills/Knowledge

• Advanced knowledge of Erwin Data Modeller r9.8 or similar version
• Advanced knowledge of dimensional modelling techniques, data modelling and data architecture best practices
• Advanced SQL skills
• Knowledge of Azure Data Lake (ADLS), Data Warehouse, Data Factory, Development Operations (DevOps) Continuous Integration (CI) and Continuous Delivery (CD), GitHub, Databricks, and Business Intelligence or relevant data environment

About CNCN is a world-class transportation leader and trade-enabler. Essential to the economy, to the customers, and to the communities it serves, CN safely transports more than 300 million tons of natural resources, manufactured products, and finished goods throughout North America every year. As the only railroad connecting Canada #39;s Eastern and Western coasts with the Southern tip of the U.S. through a 19,500 mile rail network, CN and its affiliates have been contributing to community prosperity and sustainable trade since 1919. CN is committed to programs supporting social responsibility and environmental stewardship. At CN, we work as ONE TEAM, focused on safety, sustainability and our customers, providing operational and supply chain excellence to deliver results.For internal candidates, note that the grade level of the position will depend on the employee #39;s experience.