Opportunity: The client (DND) has a requirement for a Senior Technology Architect to work on the system implementation and preparation for In-Service Support phases of the Future Aircrew Training (FAcT) Program. The FAcT mandate is to develop and implement a new and cohesive training program that replaces the Royal Canadian Armed Forces existing Pilot, Air Combat Systems Office and Airborne Electronic Sensor Operation training systems.

Location: National Capital Region

Contract Duration: 3 years with possibility for extensions

Travel: May be required to travel outside of the National Capital Region

Mandatory Requirements:

Education/certifications:

• Degree/diploma in computer science, information technology, information management or another specialty relevant to the position (I.e. computer or software engineering, information systems, data science, etc.)
• Project Management Professional (PMP) Certificate/Equivalent

Experience:

• Minimum of 5 years in the past 10 years of combined and demonstrated experience with the production of Government of Canada and Treasury Board project approval documents and presentations for Major Capital Projects (over $5M). This includes but not limited to: Project Brief, Project Charter, Statement of Requirements (SOR), Business Case, Project Complexity and Risk Analysis (PCRA), Investment Plan Change Proposal (IPCP), PRICIE
• Minimum of 5 years of experience in the past 10 years using Microsoft Project.

Job Duties:

• Participate in various meetings: working group meetings, IM/IT sub-working group meetings, stakeholder meetings, internal FAcT team meetings, and others
• Analyze information and timelines against the IM/IT Requirements.
• Perform site inspections at each base focusing on Disaster Recovery, Threat Risk Assessments, and Vulnerability Testing
• Capture feedback, guidance and technical recommendations; developing presentations.
• Participate in system requirements review, Preliminary Design Review and Critical Design Review for Performance Management, Training and Data Analytics, Integration with Other Systems, System Architecture, Integrated Master Plan, etc.
• Act as the “Subject Matter Expert” for Performance Management, System Architecture, Issue Resolution and the Integrated Master Plan and Integrated Master Schedule
• Consult with IM/IT project team to develop an IM/IT project schedule
• Participate in IM/IT operational infrastructure planning
• Develop the IM/IT Design Review entry criteria and Functional Baseline
• Training Readiness Verification and Test Readiness Review
• Review the IM/IT final design and Product and Services Baseline ensuring the fulfilment of the entry criteria against the IM/IT system design
• Participate in planning sessions and meetings covering continuous improvements of the FAcT Training System, Maintenance and Support, Backup and Restore Procedures, etc.
• Update/analyze the System Architecture document, Maintenance and Support Plan, Baseline Configuration documents, Concept of Operations, etc.

Job Description:

• Develop and understand business drivers, definitions, and metrics to interpret findings, take-action, and provide meaningful business direction.

• Develop and maintain specialized Business Intelligence (BI) packages, dashboards and scorecards on the MS Azure Cloud Platform • Manage the repository of all reporting assets including and not limited to data analysis, development scripts, objects and documentation.

• Maintain expert knowledge of all main data sources for the data used within the business unit and ability to effectively utilize these data sources • Lead the discussion with business partners to understand business objectives and develop valuable reporting for enablement and fact based decisioning • Validate the quality and integrity of the data included in all artifacts • Develop substantial and insightful commentary/insights on new and existing BI packages • Work independently as the senior analyst / expert and may provide technical support to others

Additional Requirements

• Enthusiastic and focused self-starter who can work with minimal supervision to strict deadlines and is able to prioritize, multitask, and manage various projects simultaneously • Excellent verbal and written communication skills with the ability to work with various level of management and senior management to convey findings concisely through presentations and business commentaries • Strong ownership mentality, proactive attitude, and ability to get things done • Demonstrated passionate analytical thinker with track record of delivering business impact and results through developing and executing on innovative BI solutions • Strong problem-solving skills, with a history of using data to understand not only what is happening, but why it is happening, and what can be done to resolve the issue • Strong organizational skills, with the ability to excel in a fast-paced environment and run multiple deadlines and priorities

Must Have Skills

1. 8+ Experience in business or financial reporting/business insights and analysis development, is knowledgeable and savvy with new technology and tools preferably within the global financial services and back-office operations

2. Experience working in Agile environment

3. 5+ Hands-on experience in using business intelligence, analytics and/or data visualization tools (ex: Tableau)

4. 2+ Experience with Python, Databricks

5. 5+ years SQL

6. Strong team player who fosters and thrives in an environment of peer development and sharing

7. Strong analytically-anchored problem-solving skills – a logical and strategic thinker with strong critical reasoning skills, proactively identifies risks and issues, recommends solutions, challenges the status quo

Nice to have Skills

1. Experience with Microsoft Azure is desired

2. 2+ years JIRA and Confluence

Educational Requirements/Accreditations:

• Undergraduate degree or above preferably in an analytically based discipline. Master preferred.

• 8-10 years of relevant experience

Responsibilities:

• Undertakes the design of hosting technology solutions based on the client’s service specifications, standards, policies, best practices and cost models, in order to meet client application business requirement and project/initiative deliverables.

General Skills:

• Knowledge of integrated networking technologies, mainframe, midrange server, enterprise storage and SAN, and personal computer system technologies
• Knowledge of related best practices, OPS directory/messaging standards, standard facilities infrastructure/architecture management, facility service delivery processes, infrastructures policies, procedures and direction, cost models and procurement processes,
• Ability to gather client business requirements; corporate I&IT information mandates, client information technology strategic plans, environment and standards
• Ability to participate in the development of solutions and provide advice on short/long term solution service development activities.
• Knowledge of leading edge technologies design criteria, security and recovery procedures, preparation of technical specifications for installation, testing and performance of integrated, multi-services systems; assess performance and capacity of existing system making recommendations for improving performance and develop technical documentation.
• Experience planning, migrating, implementing and sustaining large complex system development projects
• Knowledge of technology developments, trends and new products to evaluated application to client short and long term technology requirements.
• Basic knowledge of project management methodology (e.g. PMBOK), analytical tools and processes.
• Conceptual and analytical skills to assess and evaluate client needs and conduct cost/benefit analyses for new technology requirements in planning and designing solutions.
• Experience designing and developing large, complex, highly available, mission critical server applications
• Experience with systems evaluation to assess conditions, technical performance and capacity of existing systems and determine need and feasibility of expansion, renovation or replacement
• Excellent analytical, problem-solving and decision-making skills, verbal and written communication skills, interpersonal skills and negotiation skills, team work skills
• A team player with a track record for meeting deadlines

Specific Skills:

• Proven experience of working with data as well as the related functional applications
• Conversant with Power BI Design / Accessibility Standards, works with business to drive out KPIs and assists with visualization and impactful insights leveraging knowledge of business domain data to drive out business needs using Power BI Proof of Concepts/mock-ups.
• Demonstrated experience with capturing source to target requirements, supporting business rules and dataflow requirements, comfortable navigating databases using SQL to conduct analysis in support of feasibility and documentation.
• Demonstrated experience with: Microsoft Azure Data Factory Services, SSIS, SSAS, SSRS, Power BI, DataStage, Quality Stage, Visual Studio, Team Foundation Services, SQL Server Management Studio
• An asset if the resource also has Erwin Data Modeler, Power Designer (Hands-on Development Role)
• Proven ability to guide the architecture leveraging Azure cloud services, including effective standard use of Microsoft Stack tools and services critical for the integrity, quality and pace of delivery.
• Demonstrated knowledge and deep MS stack experience (10 Years) with at least 4 years with Microsoft Azure Data Factory experience
• Demonstrated experience with data ingestion from multiple sources, staging and data cleansing, including dimensional modeling and data model architecture and design aligned with data standards and analytics needs of various stakeholders. Includes creation of data warehouses, views, cubes, and other data services products.

Responsibilities:

• Design the overall functionality of key features within complex online services in order to ensure a great user experience
• Facilitate a variety of design-thinking activities and collaborative sessions to understand the problem a digital solution needs to solve
• Plan and execute user research to understand user expectations, behaviours and needs to inform design decisions
• Develop user personas, journey maps, service design blueprints, information architecture diagrams and other design artefacts as suits the needs of the project or product team
• Conduct research to ensure designs are aligned with industry best practices
• Translate concepts into wireframes, wireflows, low and high-fidelity mock-ups and clickable prototypes that illustrate the product's functionality and can be used for usability testing and user research
• Take a user-centred design approach and rapidly test and iterate your designs
• Ensure designs are accessible, optimized for a wide range of devices and interfaces, and aligned with the Ontario government’s design system
• Help to mature the organizations’ design and research operations

Experience design expertise

• Human-centred design experience and expertise in developing and executing strategies that improve overall user interactions with digital products and services, resulting in measurable enhancements and positive user feedback
• Ability to lead the design of complex digital services from concept to production, including experience designing information architecture, UI and UX optimized for a wide range of devices (e.g. web responsive)
• Demonstrated experience creating research and design deliverables such as empathy maps, site maps, journey maps, user flows, wireframes, mock-ups, clickable prototypes, presentations and reports
• A solid understanding of generative and evaluative user research methods and how user research can be incorporated continuously in the digital product lifecycle
• Hands-on experience creating user research plans, recruiting participants, facilitating user research, analyzing findings and delivering insights
• Experience researching and applying industry best practices to support your design deliverables
• The ability to incorporate web analytics, visitor feedback, performance metrics and other data to inform design decisions
• Practice providing rationale for design decisions in group settings with multiple stakeholders
• Proficient with design and prototyping software, digital collaboration and web conferencing tools

Desirable Skills:

• Familiar with using Axure for creating realistic prototype
• Knowledge of how to design to meet WCAG 2.0 Level AA standards
• Experience working in an agile environment
• ·Experience designing for government or comparable solutions involving complex navigation and interactions

Description

Responsibilities Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities. Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests. Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations. General Skills Experience in programming and analysis; specialized software package support at the specified experience level Ability to collaborate with IT Professionals throughout the Software Development Life Cycle Experience in structured methodologies for the development, design, implementation and maintenance of applications Experience in design, code, test, debug and document applications Experience in the use of object and/or third generation language development tools Experience in one or more programming languages Experience in application design, latest design patters, deployment and troubleshooting Experience with relational and hierarchical database technologies Experience in the use of information retrieval packages using query languages Experience with one or more communications protocols Experience in structured methodologies for the design, development, implementation and maintenance of applications Experience eliciting and documenting information from diverse business area stakeholders and subject matter experts Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills A team player with a track record for meeting deadlines Full Stack Skills Proficient with both front end and back end development, including any associated areas such as database design/management and DevOps Knowledge and experience with design and implementation of the overall web architecture Experience with implementation of approved user interface, design and deployment of database Knowledge and experience ensuring the entire stack is designed and built for speed and scalability Knowledge and experience with the design and construction of REST API services Knowledge and experience integrating front-end UI with the constructed API Knowledge and experience in design and implementation of continuous integration and deployment Desirable Skills Knowledge and experience with programming Internet-ready applications Knowledge and experience in rapid application development (RAD) methodologies Knowledge and understanding of Information Management principles, concepts, policies and practices Experience with middleware and gateways Experience reviewing, analyzing, and modifying product installation scripts including encoding, testing, debugging Ability to provide post-implementation support and resolve any post-implementation technical issues Experience conducting design walkthrough sessions with project team Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards Ability to provide user and system documentation as required

Skills

Experience and Skill Set Requirements

Programmer and Development Skills - 65%

·        Experience in n-tier web-based applications, database technologies, software, tools and Java EE (J2EE) technologies

·        Experience, knowledge and skills in large-scale system analysis, design and implementation for multi-client use with AODA compliance

·        Demonstrated experience directly supporting the SDLC (agile/iterative) and implementation of business-critical software applications and systems

·        Experience in writing application architecture artifacts and data modelling to lead the team for development and customization of large web-based applications

·        Experience with J-rules, Oracle content management system and Websphere application server

·        Experience in complex programming concepts and languages JSF, Spring, MyBatis and Hibernate ORM Framework, EJBs, Servlets, Core Java, , WebSphere 8 +, Oracle 19c +, SQL Server, JDBC, Oracle UCM, iText, Jasper Report, web based applications implementing with MVC framework, , AngularJS, Apache MyFaces, HTML5, CSS3, JavaScript, JQuery, Bootstrap, Foundation, Perl, NodeJs, RESTful Services and SML; IBM RSA/RAD, Eclipse, Maven, Junit, ANT Build; .Multiple platforms Solaris/Linux/ Windows and system testing methods

·        Extensive experience with security and Cryptography

·        Experience with software development, migration and deployment for virtualized infrastructure and cloud computing environment

·        Extensive experience with printing management systems and PDF architecture

Analytical and Problem-Solving Skill - 30%

·        Analytical and problem-solving skills to identify and resolve existing and potential systems issues and perform threat and risk assessments and business impact analyses

·        Oral and written communication skills

·        Presentation skills to conduct training and information sessions and lead committees and task groups

·        Consultative skills to consult with and provide advice to clients, program staff and senior management

·        A team player with a track record for meeting deadlines

·        Experience in providing technical leadership to junior developers

Hands on experience with azure cloud, AKS, WebSphere liberty or open liberty, and DevOps tool chain (Nice to have)

Public Sector Experience - 5%

·        Experience with OPS architecture, methodologies and GO–ITS standards would be an asset

·        Familiar with OPS Threat Risk Assessment (TRA) and Privacy Impact Assessment (TRA) process

MUST

• 10+ years of Experience in n-tier web-based applications, database technologies, software, tools and Java EE (J2EE) technologies

• Experience in complex programming concepts and languages JSF, Spring, MyBatis and Hibernate ORM Framework, EJBs,

• Experience, knowledge and skills in large-scale system analysis, design and implementation for multi-client use with AODA compliance

NICE

• Experience in migrating application to Azure cloud and using DevOps