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

  • Network Specialist

    3 weeks ago

    Montréal, Canada Estruxture Data Centers Full time

    **The position can be based in Calgary, Montreal, Toronto or in Vancouver / Le poste peut être basé à Calgary, Montréal, Toronto ou Vancouver.** - ** La version française suit la version anglaise **_ **We host the data. We provide the connections. We protect the information.** Everything starts with our dedicated and talented team. As an award-winning...

  • Network Specialist

    3 weeks ago

    Montréal, Canada Estruxture Data Centers Full time

    **The position can be based in Calgary, Montreal, Toronto or in Vancouver / Le poste peut être basé à Calgary, Montréal, Toronto ou **à **Vancouver.** - ** La version française suit la version anglaise **_ **We host the data. We provide the connections. We protect the information.** Everything starts with our dedicated and talented team. As an...

  • Accounting Operations Specialist, Na

    4 weeks 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...

  • Data Warehouse Specialist

    3 weeks ago

    Montréal, Canada Infocodec Solutions Full time

    We are looking to hire **Data Warehouse Specialist** with a financial background. Who will play a crucial role in leveraging a cloud-based data warehousing platform, to manage and analyze financial data. **Basic Qualifications**: - Overall 10+ years of experience is required. - Minimum 3 years of experience in design and implementation of large-scale data...

  • Data Warehouse Specialist

    5 days ago

    Montréal, Canada AppTad Technologies Pvt Ltd Full time

    **Job Title**:Data Warehouse Specialist **Job Location**: Montreal, Mississauga, Ontario Canada &Montreal, Québec, Canada (Need Onsite day 1, Hybrid 3 days from office). **Job Duration**:Long-Term **Technical skills -** - Top skills: snowflake architecture, snowSQL (Strong background), data factory (ADF) - need capital market experience (equity/fixed...

  • Data Platform Specialist

    1 week ago

    Montréal, Canada Business Development Bank of Canada Full time

    We are banking at another level. Choosing BDC as your employer means working in a healthy, inclusive, and skilled workplace that puts forward the best conditions to bring together unique teams where employees are empowered to act. It also means being at the centre of ambitious economic and financial projects to see further and to do things differently, to...

  • Tier 2 Service Desk Specialist, Na

    1 week 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...

  • Mechanical Design Intern

    4 weeks 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...

  • Invoicing 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.** Everything starts with our dedicated and talented team. As an award-winning industry leader, our data centers help our customers improve network connectivity, redundancy and uptime, scale up or down, increase cost savings, and...

  • Data Governance Specialist

    2 weeks ago

    Montréal, Canada Business Development Bank of Canada Full time

    No other bank is doing what we do. At BDC, we help Canada and its entrepreneurs create a prosperous, inclusive and green economy. Our mission is to help Canadian businesses thrive by providing financing, capital and advisory services. We’re devoted to Canadian entrepreneurs. We’re also dedicated to our employees. Adaptable. Inspiring. Different....

  • Accounts Payable Specialist, Na

    4 weeks 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...

  • IT Support Specialist, NA

    1 month ago

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

    About Vantage Data CentersVantage 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 large...

  • IT Support Specialist, NA

    1 month ago

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

    About Vantage Data CentersVantage 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 large...

  • Specialist System Design

    2 weeks ago

    Montréal, Canada spruceinfotech 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...

  • Electronic Design Specialist

    2 weeks ago

    Montréal, Canada Sistemalux Full time

    **Electronic design specialist**: **Service**: Design Department **Location**: Montreal From its well established office in Montreal, Toronto and Vancouver, **SISTEMALUX **serves all of North America with a wide range of architectural lightning at the cutting edge of design. In recent year, our major growth has position us as an Employer of choice which...

  • Business Analyst

    2 weeks ago

    Montréal, Canada InterRent REIT Full time

    **Responsibilities**: - Data Integration: Design, develop, and maintain data integration pipelines using Data Platform services to enable seamless data movement and transformation from diverse sources into the data lake. - Data Quality Assurance: Ensure data quality through the implementation of robust data validation processes, error handling mechanisms,...

  • Specialist Solution Design

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

  • Infrastructure And Data Centre Specialist

    1 month 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

    1 month 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...

  • Data Center Operator, Na

    2 weeks 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...