Data Modeler

Found in: beBee jobs CA - 2 weeks ago

Montreal, Quebec, Canada CN 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

Are you passionate about shaping the foundation of data-driven decision-making? We are seeking a skilled Expert Data Modeler to join our talented team. The role of the Expert Data Modeler is to lead the collection of business requirements to be translated into efficient data structures, while ensuring data integrity and usability. A core responsibility of this role is to design, implement, and maintain data models that serve as the backbone of our organization's data infrastructure. You will also be a key contributor of a center of excellence to set data design standards for the practice. The Expert Data Modeler brings technical expertise to ensure data integrity, quality and accuracy.

Main Responsibilities

  • Understand and translate complex business data and analytics requirements to lead the hands-on creation of conceptual, logical and physical data models
  • Lead the definition of source to target mappings to describe data transformations
  • Assess and produce data analytics artefacts including data model, mapping, data flows, data lineage, metadata documentation and transformations, ensuring the integration in the technical architecture and the alignment with data quality and governance guidelines
  • Perform profiling and data analysis using advance SQL / Python techniques on multiple platforms, including Databricks, Netezza, SQL-Server, Oracle, etc.
  • Participate in the delivery and support of data quality, data consolidation and data migration initiatives
  • Perform design reviews and improve the effectiveness of data design and management
  • Lead the data analytics design practice by defining and maintaining standards and best practices
  • Provide guidance, onboarding and mentorship to new data designers
  • Lead the troubleshooting of data issues within the business and present solutions and recommendations
  • Collaborate with various stakeholders including Architecture, Data Engineers, Product Management, DBAs, Infrastructure and Data Governance teams

Requirements

Education and experience

  • Bachelor's degree specializing in Mathematics and Statistics / Computer Science / Business Analytics / or other quantitative field, related degree or equivalent experience
  • 10 years and more overall work experience
  • Minimum 5 years of data design and data modeling experience
  • Strong experience in requirements gathering, process analysis and workflow modeling
  • Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
  • Experience in leading and participating in business workshops and business presentations

Skills and Competencies

  • Experience with data design tools (Erwin Data Modeler r12.5 or similar version)
  • Experience with dimensional modeling and relational database modeling techniques
  • Advanced SQL skills to support data profiling, unit testing and data extraction
  • Experience in a Data Lake, Data Warehouse/Business Intelligence or relevant data environment
  • Proficiency working with Azure Data Lake (ADLS), Azure Data Factory and Databricks
  • Experience working with DevOps CI/CD, Azure DevOps or GitHub
  • Exposure to data modeling and data architecture best practices
  • Expert ability to identify data gaps and assess end-to-end data requirements
  • Ability to learn quickly, problem solve/troubleshoot, work independently or in a team
  • Excellent verbal and written communication skills and the ability to interact professionally with a diverse group

Assets

  • 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
  • Familiar with Data Lakehouse architecture

This position is posted as a grade LEVEL 7. For internal candidates, note that the grade level of the position may adjust based on the employee's experience.

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.

For internal candidates, note that the grade level of the position will depend on the employee's experience.

CN is an employment equity employer and we encourage all qualified candidates to apply. We thank all applicants for their interest, however, only candidates under consideration will be contacted. Please monitor your email on a regular basis, as communication is primarily made through email.

  • Data Modeling Specialist

    Found in: beBee jobs CA - 2 weeks ago

    Montreal, Quebec, Canada DELAN - IT Head Hunters Full time

    Tasks/Responsibilities The Data Modeling Specialist will be responsible for ensuring that the solutions proposed and developed by the company perfectly correspond to the needs and challenges of clients. MORE PRECISELYAnalyze the business needs of major clients and define modeling needsDesign modeling models on the platformWork in Agile mode, mainly with...

  • Lead Data Scientist

    Found in: beBee jobs CA - 2 weeks ago

    Montreal, Quebec, Canada Montreal | Miebach Consulting, Inc. Canada Full time

    We are seeking Data Scientists with proven experience developing models to solve business problems to join our Digital Innovation team.What's in it for you: You will drive large-scale Supply Chain decisions for significant improvements in Sales, Service, Inventory, Cost, Investments and Carbon Emissions for our customers. You will be in direct contact with...

  • Data Analyst/ Analyste de données

    Found in: beBee jobs CA - 2 weeks ago

    Montreal, Quebec, Canada Electronic Arts Full time

    Pour visualiser la description de poste en français, veuillez sélectionner le français, "Select Language" dans le menu déroulant au haut de la pageThe Player & Quality Insights team focuses on understanding player behavior and designing player feedback events which help game teams develop high-quality games to meet our player's expectations. We are a...

  • Data Analyst

    Found in: beBee jobs CA - 2 weeks ago

    Montreal, Quebec, Canada Dialogue Health Technologies Inc. Full time

    Your role as Data AnalystReporting to Jad Abdallah, Manager of Data Analytics, you will contribute to Dialogue's mission of improving the health and wellness of employees by defining and driving its data strategy. The Data Analytics team is in charge of building data products that empower every Dialogue stakeholder to make strategic decisions and achieve...

  • Director, Product Data

    Found in: beBee jobs CA - 2 weeks ago

    Montreal, Quebec, Canada Knewin Full time

    Company Description Summary Assent is the leading solution for supply chain sustainability tailored for the world's top-tier, sustainability-driven manufacturers. Hidden risks riddle supply chains, many of which weren't built with sustainability in mind. That's where we step in. With insights from experts, Assent is the tool manufacturers trust for...

  • Microsoft Data Engineering Specialist

    Found in: beBee jobs CA - 2 weeks ago

    Montreal, Quebec, Canada Larochelle Groupe Conseil Full time

    Larochelle Consulting Group is seeking a consultant who specializes in data engineering with the Microsoft stack to reach our Business Intelligence Center of Excellence in Montreal.ResponsibilitiesParticipate actively in the conception, development, deployment and optimization of dynamic data pipelines (batches, micro-batches, continuous flux) for varied...

  • Data Analytics and Planning Specialist

    Found in: beBee jobs CA - 2 weeks ago

    Montreal, Quebec, Canada ICAO - International Civil Aviation Organization Full time

    Work LocationMontrealExpected durationIt should be noted that this consultancy is to be filled for an initial period of twelve (12) months with a possibility of an extension.Duties and ResponsibilitiesTHE ORGANIZATIONAL SETTING The Air Navigation Bureau (ANB) in ICAO is responsible for providing technical guidance to the Air Navigation Commission (ANC), the...

  • Intern, Data Scientist Computer Vision

    Found in: beBee jobs CA - 2 weeks ago

    Montreal, Quebec, Canada Canadian National Railway Company Full time

    At CN, everyday brings new and exciting challenges. You can expect an interesting environment where you're part of making sure our business is running optimally and safely helping keep the economy on track. We welcome students who share their ideas, perspectives and understanding of new technologies with our teams. In return, we provide the opportunity to...

  • DevOps Engineer 3

    Found in: beBee jobs CA - 4 days ago

    Montreal, Quebec, Canada Behavox Full time

    About BehavoxBehavox is shaping the future for how businesses harness their most important raw material - data. Our mission is bold: Organize enterprise data into actionable information that protects and promotes the business growth of multinational companies around the world.From managing enterprise risk and compliance to maximizing revenue and value, our...

  • Senior R&D Engineer

    Found in: beBee jobs CA - 2 weeks ago

    Montreal, Quebec, Canada DELAN - IT Head Hunters Full time

    Tasks/Responsibilities The Senior R&D Engineer will be responsible for leading the research and development of the company's various products to improve efficiency and maximize innovation. MORE PRECISELYConduct various research, anticipate market trends, and analyze data Recommend new technologies, propose initiatives, and consider solutions Optimize current...

  • Chef de Projets Techniques Data H/F

    Found in: beBee jobs CA - 2 weeks ago

    Montreal, Quebec, Canada Don't Nod Full time

    Directrice, Directeur technique Animation at Don't Nod This job might no longer be available. Directrice, Directeur technique Animation Don't Nod Montréal QC ca 1 day ago Apply Description du poste Tu souhaites participer au nouveau projet narratif de DON'T NOD Montréal porté par des membres clef de l'équipe Life is Strange et enrichi de talents...

  • Early Careers: Retirement Actuarial Analyst- Montreal- 2024

    Found in: beBee jobs CA - 2 weeks ago

    Montreal, Quebec, Canada Willis Towers Watson Full time

    Job DescriptionPlease submit a CV/resume, cover letter, and unofficial transcript with your application. The Business Create your future. Join our Retirement consulting team in providing expertise in retirement and investment consulting to support global organizations in designing, managing, administering, and communicating various retirement plans. Whether...

  • Early Careers: Retirement Actuarial Analyst- Montreal- 2024

    Found in: beBee jobs CA - 2 weeks ago

    Montreal, Quebec, Canada WTW (Willis Towers Watson) Full time

    Please submit a CV/resume, cover letter, and unofficial transcript with your application. The Business Create your future. Join our Retirement consulting team in providing expertise in retirement and investment consulting to support global organizations in designing, managing, administering, and communicating various retirement plans. Whether a client has...

  • Analyst Health

    Found in: beBee jobs CA - 2 weeks ago

    Montreal, Quebec, Canada Willis Towers Watson Full time

    Job DescriptionAs an Analyst, you will contribute to a wide variety of projects involving the design, financing and ongoing management of the full spectrum of health and benefit programs. You will serve as the project manager on select projects, interface with vendors and contribute to key client communication internally and externally, support client...

  • Analyst Health

    Found in: beBee jobs CA - 2 weeks ago

    Montreal, Quebec, Canada WTW Full time

    As an Analyst, you will contribute to a wide variety of projects involving the design, financing and ongoing management of the full spectrum of health and benefit programs. You will serve as the project manager on select projects, interface with vendors and contribute to key client communication internally and externally, support client deliverables, and...

  • Nouveau diplômé 2024

    Found in: beBee jobs CA - 2 weeks ago

    Montreal, Quebec, Canada Rio Tinto Full time

    Montréal Développeur intelligences d'affaires Nouveau diplômé 2024 Si vous voulez piloter un vrai changement, nous avons l'endroit pour le faire. Nos programmes de talents émergents vous permettent de façonner Rio Tinto. Nous voulons que vous fassiez partie de notre équipe pour nous aider à avancer en résolvant les défis émergents de notre...

  • Aircraft Control Law Engineering Professional Intern

    Found in: beBee jobs CA - 2 weeks ago

    Montreal, Quebec, Canada Wisk Aero LLC. Full time

    At Wisk, we're transforming the future of urban mobility through safe, all-electric, autonomous flight.We are a passionate team working together toward a sustainable future, solving high-impact problems that have never been solved before. By delivering everyday flight for everyone, we're making it possible to spend less time getting there and more time...

  • Développeur de données

    Found in: beBee jobs CA - 4 days ago

    Montreal, Quebec, Canada Plusgrade Full time

    Le voyage n'est pas seulement une question de destination ; il s'agit de chaque souvenir créé en cours de route. Nous nous engageons à façonner l'avenir du voyage en nous associant à plus de 200 sociétés de compagnies aériennes, d'hôtellerie, de croisière, de transport ferroviaire de passagers et de services financiers pour créer de nouvelles...

  • Specialist, Strategic Business Analytics

    Found in: beBee jobs CA - 2 weeks ago

    Montreal, Quebec, Canada UAP Inc. Full time

    Strategic Analytics Initiatives (60%)Conduct in-depth analyses of multi-faceted sources across all divisions, business processes, systems, and data to identify opportunities for performance improvements.Develop complex and advanced analytics to support business transformation and UAP strategic objectives, and provide recommendations and action plans based on...

  • Ingénieur chevronné en apprentissage automatique

    Found in: beBee jobs CA - 2 weeks ago

    Montreal, Quebec, Canada Microsoft Canada Full time

    OverviewENGLISH TEXT TO FOLLOW FRENCH TEXT Vue d'ensembleMicrosoft Research (MSR) est à la recherche d'un Ingénieur chevronné en apprentissage automatique pour travailler dans nos laboratoires à Montréal Vous aurez également l'occasion de collaborer avec nos autres laboratoires de la ville de New York et de la Nouvelle-Angleterre. Nous recherchons un...