Data Modeller
6 months ago
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
**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
-
Data Modeling Specialist
6 months ago
Montréal, Canada National Bank of Canada Full timeA career as a Data Modeler in the Data Exposure Expertise team within the Data Office at National Bank means acting as an expert in business data modeling (conceptual data models) to move the Bank towards its data management target. In particular, you'll be working with our IT and business partners, and supporting modeling experts in the Bank's business...
-
Data Modeler
3 months ago
Montréal, QC, Canada High Tech Genesis Full timeLocation: Montreal, QC Hybrid Term: Permanent High Tech Genesis is looking for a Data Modeler to join our team. Reporting to the BI Lead, this role will play a key part in developing, implementing, and continuously evolving a best-in-class data management capability. You will leverage our extensive customer and operational data sets to drive insights,...
-
Data Modellers
2 weeks ago
Montréal, QC, Canada Synechron Full timeData Warehouse Engineer (Pyspark/ Python, Azure and Snowflake) Strong understanding or Snowflake on Azure Architecture, design, implementation and operationalization of large-scale data and analytics solutions on Snowflake Cloud Data Warehouse. Hands-on development experience with Snowflake features such as Snow SQL; Python; data sharing; Experience in...
-
Microsoft Power BI Data Modeler
2 months ago
Montréal, QC, Canada AstraNorth Full time**Experience (Years): 4-6** **Essential Skills**: - 2+ years of hands-on experience working with Power BI in a business intelligence or data analyst role - Strong understanding of Power BI desktop, Power BI service, and Power QueryProficiency in data modeling, DAX Expressions, and visualization best practices - Experience with RLS and automated report...
-
Business Modeling Specialist
6 months ago
Montréal, Canada Genetec Full time**What your day will look like**: The Business Modeling Specialist reports to the Manager, Voice of Customer. In this role, you will be responsible for the following aspects - Lead the business process modeling efforts for the key processes of the CX organization following the ArchiMate standards to build consistent and customer-centric models, while also...
-
Data Scientist, Data Valorization
6 days ago
Montréal, Canada Desjardins Full timeOversee data mining, evaluation, feature engineering, quality inspection and adjustment of available data, and the selection of predictors for a wide range of complex predictive modeling mandates- Analyze client and partner business needs, generate hypotheses, and lead mandates, taking into account the specifics of their operationalization and ensuring...
-
Financial Analyst, Na
6 months ago
Montréal, Canada Vantage Data Centers Full timeAbout 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...
-
Montréal, QC, Canada Data Sciences Full timeThe successful candidate will be responsible for designing and building dimensional models that will feed BI tools and facilitate reporting and analytics for technical and non-technical users alike. Lead interviews with technical and non-technical stakeholders in order to understand business objectives and document requirements. Work with our engineering...
-
Data Scientist, Data Driven Marketing
6 months ago
Montréal, Canada Cogeco Connexion Inc Full timeOur culture lifts you up—there is no ego in the way. Our common purpose? We all want to win for our customers. We aim to always be evolving, dynamic, and ambitious. We believe in the power of genuine connections. Each employee is a part of what makes us unique on the market: agile and dedicated. Time Type: Regular Job Description: We are seeking a highly...
-
Intermediate Hydrogeologist/groundwater Modeller
7 months ago
Montréal, Canada BluMetric Environmental Inc. Full time**The Opportunity**: **Key Job Responsibilities**: - Assists in the execution of hydrogeological and water resources management studies including the development of conceptual site models, geological and numerical modelling, applied to projects including proposed, active and abandoned mine sites, landfills, contaminated lands, and others. - Participation...
-
Hard Surface Modeler
1 week ago
Montréal, Canada Lakshya Digital Full time**Job Title**: Hard Surface Modeler **Location**: Canada (Remote - Within Pacific Time Zone (PST) to Eastern Time Zone (EST)) **Rate**: $40- $50/hour CAD **Employment Type**: Freelance **Position - Hard Surface Modeler** **Reporting** The Hard Surface Modeler will report to the Producer. **Responsibilities and Duties** - Create models from concept art to...
-
Data Scientist
6 months ago
Montréal, Canada International Air Transport Association (IATA) Full timeEmployment Type: Permanent Contract Duration: At IATA, we speak for the airlines of the world, serving and supporting over 300 of them across all continents. We are passionate and knowledgeable about the aviation industry, and we strive to make it safer, smarter, more sustainable and more inclusive. We celebrate diversity and inclusion in our workforce, and...
-
Data Scientist, Data Valorization
2 months ago
Montréal, QC, Canada Desjardins Full timeAs a data scientist, you provide the data needed to make business decisions, develop solutions and services adapted to business issues and understand member and client behaviour. You provide guidance and support to clients for advanced analytics and artificial intelligence mandates that involve using data and developing models adapted to business needs. Your...
-
Lead Data Scientist
6 months ago
Montréal, Canada Miebach Consulting GmbH Full timeRecent Graduates | Mid-level Professionals | Senior Professionals | Digital | - Montreal**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,...
-
Data Scientist, Data Valorization
2 months ago
Montréal, QC, Canada Desjardins Full timeOversee data mining, evaluation, feature engineering, quality inspection and adjustment of available data, and the selection of predictors for a wide range of complex predictive modeling mandates- Analyze client and partner business needs, generate hypotheses, and lead mandates, taking into account the specifics of their operationalization and ensuring...
-
Data Analyst
6 months ago
Montréal, Canada CTConsultants Full time**CTC007552 - Data Analyst**: **Secteur industriel: Infrastructure**: **Type d'emploi: Contract**: **Durée: Eleven months**: **Mode de travail: Remote**: **Description**: Remote work 40% of the time Join our dynamic team at CTC as we gear up to develop a winning proposal for an exciting new project! We are looking for an experienced Data Analyst to play a...
-
Data Scientist
6 months ago
Montréal, Canada GHGSat Full timeGHGSat offers greenhouse gas detection, measurement, and monitoring services to industrial and government customers around the world. We use our own satellites and aircraft sensors, combined with third-party data, to help industrial emitters better understand, control, and reduce their emissions. The Science and Systems team has a flexible work environment...
-
Analytics Engineer | Ingénieur Analytique
2 weeks ago
Montréal, QC, Canada Data Sciences Full timeSummary We are looking for an Analytics Engineer to join our diverse and rapidly growing team in Montreal. The successful candidate will be responsible for designing and building dimensional models that will feed BI tools and facilitate reporting and analytics for technical and non-technical users alike. We are looking for big picture thinkers with strong...
-
Data Scientist
7 months ago
Montréal, Canada Ubisoft Full timeCompany Description Ubisoft’s 20,000 team members, working across more than 30 countries around the world, are bound by a common mission to enrich players’ lives with original and memorable gaming experiences. Their commitment and talent have brought to life many acclaimed franchises such as Assassin’s Creed, Far Cry, Watch Dogs, Just Dance, Rainbow...
-
Data Scientis
2 months ago
Montréal, QC, Canada Desjardins Full timeAs a data scientist, you provide the data needed to make business decisions, develop solutions and services adapted to business issues and understand member and client behaviour. You provide guidance and support to clients for advanced analytics and artificial intelligence mandates that involve using data and developing models adapted to business needs. Your...