Expert Application Data Architect

at  Canadian National Railway

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.

REQUIREMENTS

• Experience
• 12+ years of experience with data engineering and architecture for API, applications, analytics BI and AI.
• 5+ years of experience as an Architect with application, technology architecture covering Applications, APIs, MicroServices, Integration, BI, Analytics and AI.
• 3+ years of experience as Senior Architect using cloud native data architecture and technologies.
• Education/Certification/Designation
• Bachelor’s degree in technology related field or equivalent experience

Competencies

• Leadership
• Communication
• Time management
• Business Acumen

Technical Skills/Knowledge

• Strong Experience engineering, architecting, and delivering enterprise grade products
• Strong Experience with Information and Data Architecture patterns
• Strong Experience managing BI Frameworks, design principles, and standards
• Good understanding of Data Governance and Data Lineage and technologies.
• Experience implementing Big Data, Pipelines and Data Warehouse Architectures
• Like Hadoop, ADLS, Spark, DeltaLake
• Tools like Sqoop, Flume, Kafka, Oozie, Solr, Avro
• Relevant current and legacy patterns Star Schema, Snowflake Schema, Fact and Dimensional Tables, Physical and Logical Data Modeling
• Database Architectures - SQL, NoSQL, Document, Graph, Search, In-memoryDB
• Experience with data architecture for Cloud Native Application and APIs
• Web & Mobile Application Architecture
• Micro Service Architecture, Domain Driven Design, Event Sourcing, CQRS
• API Architecture – knowledge of Schema Modeling is a plus
• Process Driven Architecture – BPMS/Workflow/RulesEngines/SAGA
• Experience with Event Driven Architecture - Pub-Sub, Kafka, MQ, MQTT
• Experience with SOA architecture, patterns and implementation
• Experience with Integration of Transactions, Data, Streaming, Batch, Files, APIs
• Cloud Data Services Architecture knowledge is an asset
• Experience architecting/operating solutions build on Azure, GCP, others
• DevOps knowledge is an asset
• Experience working with DevOps, CI/CD/CT – Azure DevOps, GitHub, GitLab
• Experience with Test Automation, TDD, BDD, ATDD
• Experience with AI/ML technologies is an asset
• Experience in program & project scoping and planning with Agile process and tools
• Experience in delivering agile and iterative architectures
• Experience with Legacy Systems Modernization (Mainframe, SAP, Java) is a plus

Responsibility 1

• Lead the delivery of modernization initiatives and create great products by focusing on the needs of our customers and business value delivery.
• Lead modern data architecture best practices including Domain Driven Design and Analytical data models.
• Create systems architectures and modernization strategies; moving to cloud native applications, APIs, MicroServices, Data Lake, BI and AI with target and transitions architectures and Roadmaps over multiple years.
• 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.