Expert Application Data Architect

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

CN Customer Solutions Group is seeking a Senior Data Architect to drive strategic innovation and modernization initiatives and architecture practices. As a data and technology architect, you will lead the architecture of cloud native APIs, Data-Hubs, Data-Lake Information models and cloud infrastructures to drive the creation industry leading products. As an expert product builder, you will define practical architectures that ensure the performance, scalability, and maintainability of complex distributed systems. You will also contribute to the definition of strategic data and technology directions and define continuous improvement objectives in collaboration with Innovation leadership team. 

Main Responsibilities 

Responsibility 1  

·       Assist in developing and of modernization initiatives that is in line with business processes. The strategy includes data model designs, database development standards. 

·       Coordinate and collaborate with cross-functional teams, stakeholders, and vendors for the smooth functioning of the enterprise data system.  

·       Managing product end-to-end data architecture, designing the technical architecture. 

·       Integrating technical functionality, ensuring data accessibility, accuracy, and security. 

·       Builds roadmap(s) for implementing and manage best practices in alignment with product architecture strategy. 

·       Keeps abreast of latest technological/industry trends. 

·       Lead modern data architecture best practices including Domain Driven Design and Analytical data models. 

·       Design and optimize application and integration strategies for the cost-effective delivery of scalable and reliable distributed systems. 

Responsibility 2  

-Evaluate current and emerging Data, Analytics and AI technologies. Be a leader in the architecture and engineering group, fostering a culture of design thinking, brainstorming, efficiency, and balancing vision with practicality. 

-Define architecture and engineering standards, patterns & best practices. 

-Influence leadership with effective communication of proposals, directions and strategic decision making. 

·      

Requirements 

Experience 

Education/Certification/Designation 

Competencies  

Technical Skills/Knowledge 

Must haves 

·       Expert knowledge of engineering, architecting, and delivering enterprise grade products. 

·       Expert knowledge of designing integration solutions, with good understanding of Enterprise Data Integration and Architectural Data Patterns. 

·       Expert knowledge of Information and Data Architecture patterns 

·       Good knowledge of Data Governance and Data Lineage and technologies. 

·       Goof knowledge of SOA architecture, patterns and implementation 

·       Good knowledge of analytical data models Star Schema, Snowflake Schema, Fact and dimensional Tables, Physical and Logical Data Modeling 

·       Good knowledge of Database Architectures - SQL, NoSQL, Document, Graph, Search, In-memoryDB 

·       Good knowledge of Micro Service Architecture, Domain Driven Design, Event Sourcing, CQRS 

·       Good knowledge of API Architecture and Schema Modeling is a plus 

·       Ability to simplify complex concepts. 

·       Good communication and presentation skills 

·       Ability to plan and lead the work of data designers and developers 

Nice to haves 

·       Experience in program & project scoping and planning with Agile process and tools 

·       Experience in delivering agile and iterative architectures 

·       Experience architecting/operating solutions build on Azure, GCP, others 

·       Experience implementing Big Data, Pipelines and Data Warehouse Architectures 

o   Like Hadoop, ADLS, Spark, DeltaLake 

o   Tools like Sqoop, Flume, Kafka, Oozie, Solr, Avro 

·       Experience with Event Driven Architecture - Pub-Sub, Kafka, MQ, MQTT 

·       Experience with Integration of Transactions, Data, Streaming, Batch, Files, APIs 

·       Cloud Data Services Architecture knowledge 

·       DevOps knowledge 

·       Experience working with DevOps, CI/CD/CT - Azure DevOps, GitHub, GitLab 

·       Experience with Test Automation, TDD, BDD, ATDD  

·       Experience with AI/ML technologies 

·       Experience with Legacy Systems Modernization (Mainframe, SAP, Java) is a plus 

·       Lead the architecture and delivery of data products with very high strategic value and business visibility 

·       Lead strategic data architecture practices and modernization approaches of the innovation group 

·       Create strategic technology directions 

·       Define continuous improvement objectives 

Employees Supervised/Organizational Structure 

Be a functional and though leader to indirect reports

This position is posted as a grade 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.