Specialist Data Design

3 weeks ago

Montréal, Canada Canadian National Railway Full time

At CN, we work together to move our company—and North America—forward. Be part of our Information & Technology (I&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 Summary**

The 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 Responsibilities**

Data 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 Conditions

The role has standard working conditions in an office environment with a regular workweek from Monday to Friday.

**Requirements**:
Experience

Data Design and Modelling
- Between 5 to 7 years overall work experience
- Minimum 4 years of experience in analysis, data design and data modelling
- Experience performing root cause analysis to answer specific business questions and identify opportunities for improvement
- Experience in real time data streaming and loading*
- Experience modelling data for data science projects*
- Experience working with Scale Agile Methodology (SAFe)*
- Experience with semi-structured and unstructured data*
- Any experience for these above would be considered as an asset

Education/Certification/Designation
- Bachelor’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 CN**

CN 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’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

  • Accounting Operations Specialist, Na

    4 days ago

    Montréal, Canada Vantage Data Centers Full time

    About Vantage Data Centers Vantage is committed to being a workplace of inclusion, equity, respect and acceptance. We celebrate diversity and intentionally seek out opportunities to learn from one another’s experience. Vantage Data Centers powers, cools, protects and connects the technology of the world’s well-known hyperscalers, cloud providers and...

  • Senior Network Specialist, NA

    3 weeks ago

    Montréal, QC, Canada Vantage Data Centers Full time

    Senior Network Specialist, NA page is loaded Senior Network Specialist, NA Apply locations Montreal, Quebec time type Full time posted on Posted 2 Days Ago job requisition id R14093 About Vantage Data Centers Vantage is committed to being a workplace of inclusion, equity, respect and acceptance. We celebrate diversity and intentionally seek out...

  • Senior Data Visualization Specialist

    7 days ago

    Montréal, QC, Canada Pharmascience Full time

    Description : We are seeking a Senior Data Visualization Specialist to spearhead the design of analytical solutions, transforming data into actionable insights for our Supply Chain team. This role is a key part of our Supply Chain Transformation team, working in close collaboration with both the IT Business Intelligence team and all Supply Chain members....

  • Infrastructure And Data Centre Specialist

    1 day ago

    Montréal, Canada The AIM Group Full time

    The candidate will participate as a Data Center and Network Specialist member of the Naval Development team in a multi-disciplined team environment to perform tasks related to data center technologies in application to next generation mission critical systems (i.e. High Availability System, Automated Recovery). The data center technologies comprise...

  • Infrastructure And Data Centre Specialist

    4 weeks ago

    Montréal, Canada The AIM Group Full time

    The candidate will participate as a Data Center and Network Specialist member of the Naval Development team in a multi-disciplined team environment to perform tasks related to data center technologies in application to next generation mission critical systems (i.e. High Availability System, Automated Recovery). The data center technologies comprise...

  • Infrastructure And Data Centre Specialist

    3 weeks ago

    Montréal, Canada The AIM Group Full time

    The candidate will participate as a Data Center and Network Specialist member of the Naval Development team in a multi-disciplined team environment to perform tasks related to data center technologies in application to next generation mission critical systems (i.e. High Availability System, Automated Recovery). The data center technologies comprise...

  • Infrastructure And Data Centre Specialist

    3 weeks ago

    Montréal, Canada The AIM Group Full time

    The candidate will participate as a Data Center and Network Specialist member of the Naval Development team in a multi-disciplined team environment to perform tasks related to data center technologies in application to next generation mission critical systems (i.e. High Availability System, Automated Recovery). The data center technologies comprise...

  • Infrastructure And Data Centre Specialist

    4 weeks ago

    Montréal, QC, Canada The AIM Group Full time

    The candidate will participate as a Data Center and Network Specialist member of the Naval Development team in a multi-disciplined team environment to perform tasks related to data center technologies in application to next generation mission critical systems (i.e. High Availability System, Automated Recovery). The data center technologies comprise...

  • Voice & Data Specialist

    2 weeks ago

    Montréal, QC, Canada Lightspeed Alumni Job Board Full time

    Are you actively looking for a new opportunity? Or just checking the market? Well… you might just be in the right place! Lightspeed is looking for a Voice & Data Specialist to join our rapidly scaling team. The successful candidate will be responsible for the ongoing support and maintenance of the existing Telephony and Contact Center solutions as well...

  • Tier One Service Desk Specialist

    4 days ago

    Montréal, Canada Vantage Data Centers Full time

    About Vantage Data Centers Vantage is committed to being a workplace of inclusion, equity, respect and acceptance. We celebrate diversity and intentionally seek out opportunities to learn from one another’s experience. Vantage Data Centers powers, cools, protects and connects the technology of the world’s well-known hyperscalers, cloud providers and...

  • Tier One Service Desk Specialist

    4 days ago

    Montréal, Canada Vantage Data Centers Full time

    About Vantage Data Centers Vantage is committed to being a workplace of inclusion, equity, respect and acceptance. We celebrate diversity and intentionally seek out opportunities to learn from one another’s experience. Vantage Data Centers powers, cools, protects and connects the technology of the world’s well-known hyperscalers, cloud providers and...

  • Specialist System Design

    7 days ago

    Montréal, QC, Canada Spruce InfoTech Full time

    Company Description Spruce InfoTech is a leading information technology firm that provides varied services to help clients change manage and transform their businesses by means of high quality, innovative and cost effective solutions. We provide services to different companies from small scale level to even fortune 500 organizations and guide them in the...

  • Virtual Design Specialist

    3 weeks ago

    Montréal, QC, Canada Ubisoft Full time

    As a Camera Specialist (Gameplay) at Ubi MTL, you'll be responsible for developing and ensuring the quality of in-game cameras, which will bring out the important elements of the game during playable sequences.In collaboration with the creative and level design directors, develop the style and role of the cameras in the overall game experience; With level...

  • Infrastructure and Data Centre Specialist

    3 weeks ago

    Montréal, QC, Canada Hunter Bond Full time

    My client are seeking a Data Center Infrastructure & Infrastructure Specialist to join their team. The position is a mixture of hands on and hands off Data Center based work, with the role revolving around Data Center infrastructure. Sourcing, preparing and installing equipment into Data Centers Organising and coordinating with smart hands at remote...

  • Data Specialist

    4 weeks ago

    Montréal, Canada AlayaCare Full time

    **About AlayaCare**: AlayaCare is revolutionizing the way home health care is delivered. Our leading cloud-based software allows our clients around the world to manage their employees, scheduling, billing, and enable better delivery of care. We are a fast-growing SaaS company with a team of 550+ team members across Canada, US, Australia, and Brazil. We aim...

  • Data Entry Specialist

    1 week ago

    Montréal, QC, Canada Fuze HR Solutions Full time

    Spécialiste, entrée de données Poste temporaire - Durée de 6 mois à 1 an avec la possibilité de permanence Location: Montréal (Ville Saint-Laurent) ou Iberville 1 jour par semaine au bureau et 4 jours en télétravail Dans ce rôle, vous serez responsable de la création et de la maintenance des données de base pour le Canada, conformément aux...

  • Data Entry Specialist

    7 days ago

    Montréal, QC, Canada Fuze HR Solutions Full time

    Spécialiste, entrée de données Poste temporaire - Durée de 6 mois à 1 an avec la possibilité de permanence Location: Montréal (Ville Saint-Laurent) ou Iberville 1 jour par semaine au bureau et 4 jours en télétravail Dans ce rôle, vous serez responsable de la création et de la maintenance des données de base pour le Canada, conformément aux...

  • Learning & Development Design Specialist

    4 weeks ago

    Montréal, Canada Glentel – French Full time

    This is a contract position and will end in October 2024. **Overview** We are seeking an innovative, self-driven, and creative L&D Instructional Design Specialist who is passionate about creating best-in-class learning solutions! The L&D Design Specialist will create new learning experiences as well as improve existing learning programs using various...

  • Data Center

    3 weeks ago

    Montréal, QC, Canada Hunter Bond Full time

    My client are seeking a Data Center Infrastructure & Infrastructure Specialist to join their team. The position is a mixture of hands on and hands off Data Center based work, with the role revolving around Data Center infrastructure. Responsibilities include: Sourcing, preparing and installing equipment into Data Centers Documentation Organising and...

  • Application Support Specialist

    4 weeks ago

    Montréal, Canada Estruxture Data Centers Full time

    La version française suit la version anglaise **_ **We host the data. We provide the connections. We protect the information.** eStruxture is more than a data center: it's THE largest Canadian data center platform. It's 15 locations across the country, over 760,000 square feet of space, over 130MW of power and access to over 1,400 network and cloud...