Specialist Data Design

1 week ago

Toronto, Ontario, 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, data quality requirements, define data transformation rules, as well as logical and physical data models.

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.


Main Responsibilities
Data Design and Management

  • Build conceptual, logical, and physical data models
  • Build source to target mapping documents to describe data transformations
  • Design and develop curated data assets in Data Lake and Data Warehouse to support reporting, data science and data engineering
  • Define, document, and maintain standards and best practices around data modelling

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

Requirements:

Experience

Data Design and Modelling

  • Between 3 to 5 years overall work experience
  • Minimum 3 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 with big data processing
  • Experience in real time data streaming and loading
  • Experience modelling data for data science projects
  • Experience working with Scale Agile Methodology (SAFe)
  • Experience with semistructured and unstructured data**Any experience for these above would be considered as an asset

Education/Certification/Designation

  • Bachelor's Degree specializing in Computer Science, Business Analytics, Mathematics and Statistics, 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 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), 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, we work as ONE TEAM, focused on safety, sustainability and our customers, providing operational and supply chain excellence to deliver results.

  • Purchasing Specialist

    1 week ago

    Toronto, Ontario, Canada Lori Morris Design Full time

    We Are HiringPurchasing Specialist - Decoration DepartmentThis opportunity offers an exciting entry point into a dynamic career path. While an Interior Design or Product Procurement background would be advantageous, a passion for detail and organization is paramount.Job DescriptionAs a Purchasing Specialist at Lori Morris Design, you'll undertake a...

  • Communications Specialist

    1 week ago

    Toronto, Ontario, Canada League Data Ltd. Full time

    COMMUNICATIONS SPECIALIST Halifax, Nova Scotia (Remote or Hybrid) Employment Term: Full Time Minimum Experience: Experienced WHAT WE OFFER At League Data, we pride ourselves on being an engaged, innovative, team-oriented company that drives results through collaboration and leadership at every level. We offer a flexible work environment that includes...

  • Purchasing Specialist

    1 week ago

    Toronto, Ontario, Canada Lori Morris Design Full time

    We Are HiringPurchasing Specialist - Decoration DepartmentThis opportunity offers an exciting entry point into a dynamic career path. While an Interior Design or Product Procurement background would be advantageous, a passion for detail and organization is paramount.Job DescriptionAs a Purchasing Specialist at Lori Morris Design, you'll undertake a...

  • Purchasing Specialist

    4 weeks ago

    Toronto, Ontario, Ontario, Canada Lori Morris Design Full time

    We Are HiringPurchasing Specialist - Decoration DepartmentThis opportunity offers an exciting entry point into a dynamic career path. While an Interior Design or Product Procurement background would be advantageous, a passion for detail and organization is paramount.Job DescriptionAs a Purchasing Specialist at Lori Morris Design, you'll undertake a...

  • Purchasing Specialist

    4 weeks ago

    Toronto, Ontario, Ontario, Canada Lori Morris Design Full time

    We Are HiringPurchasing Specialist - Decoration DepartmentThis opportunity offers an exciting entry point into a dynamic career path. While an Interior Design or Product Procurement background would be advantageous, a passion for detail and organization is paramount.Job DescriptionAs a Purchasing Specialist at Lori Morris Design, you'll undertake a...

  • Senior UI/ux Designer

    1 month ago

    Toronto, Ontario, Canada NTT Data Full time

    Req ID: NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Senior UI/UX Designer - Salesforce - Remote Canada Position NTT DATA America strives to hire exceptional, innovative,...

  • Senior UI/ux Designer

    4 weeks ago

    Toronto, Ontario, Canada NTT Data Full time

    Req ID: NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Senior UI/UX Designer - Salesforce - Remote Canada Position NTT DATA America strives to hire exceptional, innovative,...

  • Specialist, Scm Data

    1 week ago

    Toronto, Ontario, Canada Celestica Full time

    Req ID: 116624Remote Position: HybridRegion: AmericasCountry: CanadaState/Province: OntarioCity: TorontoAs the Specialist SCM Data (Data Science Specialist), you will be joining a small team that embraces data and technology to develop advanced and innovative solutions. The Data Science Specialist works with the Strategic Sourcing and Source to Contract...

  • Data Governance Specialist

    1 week ago

    Toronto, Ontario, Canada OnX Canada Full time

    Hybrid: Onsite 2-3 Days a weekOffice is located in TorontoPermanent PositionLooking for someone to support in the Data Governance initiative, who understands all components of Data management and its governance, and has experience setting up Data Governance practice in their organization by creating policies, standards, best practices, has excellent...

  • IT Data Specialist

    1 week ago

    Toronto, Ontario, Canada TD Bank Full time

    IT Data Specialist:BRJob Category - Primary Technology SolutionsWork Location TD Centre West 100 Wellington Street WestEmployment Type RegularCity TorontoTime Type Full TimeProvince/State OntarioHours 37.5Workplace Model HybridPay DetailsDepartment OverviewBuilding a World-Class Technology Team at TDWe can't afford to be boring. Neither can you. The scale...

  • Data Warehouse Specialist

    1 week ago

    Toronto, Ontario, Canada Synechron Full time

    We are At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron's progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps,...

  • Data Scientist/ Specialist

    1 week ago

    Toronto, Ontario, Canada Drake International Full time

    Title: Data Scientist/ SpecialistLocation: Toronto, ON (Hybrid)Type: Long Term ContractIntroduction:Join a rock-solid organization as our client's next Data Scientist/ Specialist and sit at the center of projects that drives decisions. You'll help one of Canada's most trusted organizations work on the latest project, and be rewarded with great...

  • Data Governance Specialist

    1 week ago

    Toronto, Ontario, Canada OCS Full time

    About UsThe Ontario Cannabis Store provides safe, responsible access to recreational cannabis for adults 19 and older. We operate the provincial online store for recreational cannabis in Ontario and are the exclusive provincial wholesaler to authorized private retail stores.Working at the OCS is a unique opportunity to be part of an agile start-up in a...

  • Data Entry Specialist

    1 week ago

    Toronto, Ontario, Canada CB Canada Full time

    Ref ID: Classification: Data Entry ClerkCompensation: $19.25 to $23.25 hourlyRobert Half is looking for a sharp Data Entry Specialist for our highly regarded client in Toronto area. If you are a data-driven expert with great attention to details, this contract to hire Data Entry Specialist position is a perfect fit for you Data Entry Specialist who wants to...

  • Recruitment Specialist

    1 week ago

    Toronto, Ontario, Canada Recruitment By Design Full time

    Recruitment By Design is hiring We are a full-service, boutique staffing agency specializing in the Architecture, Design & Engineering industries across Canada. We are currently seeking a Junior Recruitment Specialist to join our growing team in the Greater Toronto Area. In this role you will work

  • Data Engineer

    1 week ago

    Toronto, Ontario, Canada NTT DATA Services Full time

    Req ID: NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Data Engineer (Snowflake/Python) - Remote Canada Position Day to Day / Job Responsibilities: As a Snowflake/Python...

  • Senior Data Specialist

    1 week ago

    Old Toronto, Ontario, Canada CBCRadio-Canada Full time

    Senior Data Specialist (Procurement) (Finance) (Hybrid)Job ID: 42525 Job Type: Full Time Category: Finance Educations:Posted: Location:Job Views: 4 USD Negotiable Job Description:Job information Job Description:Job information Senior Data Specialist (Procurement) (Finance) (Hybrid) from the Company CBC/Radio-Canada, this latest Senior Data Specialist...

  • data specialist

    1 week ago

    Toronto, Ontario, Canada City of Toronto Full time

    Responsibilities : Implements detailed plans and recommends policies/procedures regarding program specific requirements. Collaborate, motivates and trains staff, ensuring effective teamwork, high standards of work quality and organizational performance, continuous learning and encourages innovation in others. Leads tasks and projects related to the...

  • Purchasing Specialist

    1 week ago

    Toronto, Ontario, Canada Lori Morris Design Full time

    We Are Hiring Purchasing SpecialistDecoration Department This role provides a great starting point for anyone looking to embark on a promising career journey. While experience in Interior Design or Product Procurement would be beneficial, a strong focus on precision and efficient organization is key. Job Description: As a Purcha

  • Specialist, Data

    1 week ago

    Toronto, Ontario, Canada Air Canada Full time

    DescriptionBeing part of Air Canada is to become part of an iconic Canadian symbol, recently ranked the best Airline in North America. Let your career take flight by joining our diverse and vibrant team at the leading edge of passenger aviation.Introduction:Ops Modernization is a collaborative effort between Air Canada's Business and IT teams who are...