Specialist Data Developer/software Development

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 Specialist Software Development is to contribute to the whole solution by analyzing functional specifications to identify the best technical design (blueprint) and coding parts of the solution. The Specialist takes full responsibility of assigned deliverables, aligns own workload and focuses on key tasks in order to deliver as per service commitment, leveraging own expertise and skill set to achieve delivery goals. Depending on the assignment, the role may apply in either a Project, Enhancement or Support environment.

Main Responsibilities

Deliver & Support

• Write performing quality code to fulfill design and pass code review with minimal number of defects

• Apply configuration on development environment when required

• Participate in implementing and supporting full product in production.

• Analyze source system data to assess data quality, connect to data sources, import data and transform data for Business Intelligence

Technical Expertise

• Design ETL processes and develop source-to-target data mappings, integration workflows, and load processes

• Interact with Data Designer to understand requirements for solutions. Highlight the technical impacts of the functional design on existing solutions based on a detailed analysis.

• Deliver technical design and database structure for medium to high product complexity

• Create, review and maintain technical documentations.

• Analyze and troubleshoot the production issues and provide remediation

Architecture

• Contribute in developing the design and coding standards that will apply to the whole practice

• Document blueprint based on requirements & functional designs

• Document designs and architect data maps, develop data quality components and establish and/or conduct unit tests

• Involved in gathering, understanding and validating the project specifications and participate in ETL architecture design reviews

Quality Controls

• Ensure Quality KPI are identified, measured and produced ensuring respect of development standards. Ensure right level of testing is consistent across all projects.

• Identify problems, develop ideas and propose solutions within differing situations requiring analytical, evaluative or constructive thinking in daily work.

• Perform reviews and quality checks after data has been loaded

Working Conditions

• N/A

Requirements

Experience

• Minimum 4 years overall work experience as a developer

• Hands On with Azure, ADF and Databricks is a MUST

• Proficiency with programming languages Java, Python and Shell scripting is a MUST

• Proficiency with programming language Scala is a plus

• Ability to develop Batch and Streaming applications

• Exposure to NoSQL database and thorough experience with SQL

• Experience working in Agile environments and Azure devops

Assets

• Azure Certification, DataBricks Certification, Snowflake expertise

• Knowledge of Hadoop ecosystem (Hive, Spark, HDFS, NiFi)

Education/Certification/Designation

• Bachelor's degree in computer science or equivalent degree or work experience

Functional competencies/Soft Skills

• Strong communication skills, including the ability to speak clearly to technical and nontechnical people.

• Self-driven, highly motivated, team player and able to learn quickly

Technical skills/ Knowledge

• Proficiency with SQL and/or data modeling skills.

• Proficiency with programming technologies in area of expertise, Python, Java/Scala, PowerShell

• Experience in troubleshooting and resolving database integrity and performance issues

• Experience in Data warehouse design, ELT/ETL and BI reporting/analytics tools

• Experience with Big Data techniques and Cloud, Knowledge of Messaging Queue (Kafka, Azure Event Hub, RabbitMQ, Etc..) and ELK

• Experience developing CI/CD pipelines

• Awareness of Agile principles, automation, Scripting Skills and DevOps

• Strong understanding of data warehousing and business intelligence architecture

• Experience with Azure (DataLake, DataFactory, DataBricks, Data Explorer, Data warehouse)

• Experience with version control systems (git) and Azure DevOps

• Knowledge of Big Data analytics technologies in a Cloud 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.

At CN, we are dedicated to building North America's safest, most inclusive and sustainable railroad, which includes reflecting the communities in which we operate. Research shows that candidates from underrepresented groups often don't apply unless they feel they fit the job posting at 100%. Even if you don't see yourself in every job requirement listed in a posting, we still encourage you to apply. If you require an accommodation for the recruitment process (including alternate formats of materials, accessible meeting rooms or other accommodations), please reach out to our team at cnrecruitment@cn.ca.

As an equal employment opportunity employer, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, and other protected status as required by applicable law. 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.