Job title: Expert Data Designer
Company: Canadian National Railway
Job description: 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 role of Expert Data Designer is to lead the business requirements gathering, create metrics framework, create data definitions, business rules, data quality requirements, and design solutions that drive value. He/she will also supervise and maintain the Data Analytics practise within the team. The Expert Data Designer brings technical expertise to ensure the quality and accuracy of data, then process, design and present it in ways to help people, businesses, and organizations make better decisions. The role ensures data integrity and normalization, and oversees and designs the reporting environment, including data sources, security, and metadata.
Main Responsibilities
- Lead conceptual, logical and physical data models to deliver the Analytics solutions.
- Lead the source to target mapping definition to describe data transformations.
- Design and develop analytics solution in Data Lake and Data Warehouse environments to support operational reporting.
- Lead the practice, standards and best practices around data analytics design.
- Performs design reviews.
- Onboard, support and mentor new data designers.
- Performs profiling and analyze data using SQL / Python on multiple sources: Oracle, Netezza, SQL-Server, Databricks, etc.
- Assess and design data analytics components (data model, mapping, data flows, and transformations) to make sure they are well integrated and aligned with the data and technical architecture.
- Lead the Troubleshooting of data issues within the business and presents solutions and recommendations.
- Participate in the delivery and support of data quality and data consolidation initiatives.
- Lead simplification initiatives to allow for more effective data design, and management.
- Provide analytical support by developing dashboards and reports using Power BI or Tableau to deliver business insight.
- Work with stakeholders including Architecture, Data Engineers, Product Management, DBAs, Infrastructure, Data & Design Teams to assist with data-related technical issues and support their data infrastructure needs.
Requirements
Experience
- 10 years and more overall work experience.
- Minimum 5 years of analysis, 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 defining metric frameworks
Education/Certification/Designation
- Bachelor’s degree specializing in Mathematics and Statistics / Computer Science / Business Analytics / or other quantitative field, related degree or equivalent experience
General Skills and Competencies
- Expert ability to identify data gaps and assess end-to-end data requirements.
- Excellent Communication skills to build alliances and gain consensus with key stakeholders.
Technical Skills/Knowledge
- Advanced experience with data design tools (Erwin Data Modeler r9.8 or similar version)
- Advanced experience with dimensional modeling techniques.
- Exposure to Data modeling experience, and data architecture best practices.
- Experience with relational database modeling techniques.
- Advanced SQL skills to support data profiling, unit testing and data extraction.
- Experience in Data Lake, Data Warehouse/Business Intelligence or relevant data environment; in either a development or a support role.
- Experience using Azure Data Lake (ADLS), Azure Data Factory and Databricks.
- Excellent verbal and written communication skills and the ability to interact professionally with a diverse group.
- Experience working with DevOps CI/CD. Azure DevOps or GitHub
Assets
- Experience in real time data streaming and loading.
- Experience modelling data for data science projects.
- Experience working with Scale Agile Methodology (SAFe).
- Experience working with Tableau or Power BI.
- Experience with semi-structured and unstructured data.
- Familiar with Data Lakehouse architecture.
- Written presentation experience; presenting insights in plain language and images.
- The ability to learn quickly, problem solve/troubleshoot, work independently and in a team.
- Experience in leading and participating in business workshops
- Ability to promote business intelligence, analytics, and reporting vision
- Willingness to work on multiple projects at one time
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.
Expected salary:
Location: Montreal, QC
Job date: Thu, 07 Dec 2023 05:08:32 GMT
