SAP Technical Architect

City of Ottawa; Ottawa; On-site; CAD 102,000 - 125,000; Full time

Job summary

The City of Ottawa seeks an IT professional responsible for overseeing the design and implementation of technical solutions impacting the IT ecosystem. This role emphasizes SAP Data Architecture, Azure integration, and advanced data governance skills, demanding extensive experience in IT architecture and development.

Benefits

Diversity and inclusion initiatives

Accommodation for applicants

Qualifications

• Minimum of 7 years of experience in technical design and architecture.
• Strong experience with ETL/ELT tools.
• Experience in developing data warehouse architectures.

Responsibilities

• Provide technical oversight on high-risk IT solutions.
• Lead day-to-day operations of critical IT systems.
• Serve as technical subject matter expert for assigned solutions.

Skills

SAP Data Architecture

Azure integration

Data governance

Proficiency in Power BI

Education

4 year university degree in Computer Science

Tools

SAP Data Services

Azure Data Factory

MS Fabric

Job description

Select how often (in days) to receive an alert: Create alert

Requisition ID: 18145
Department: Finance and Corporate Services Dept.
Service: Information Technology Services
Branch:Applications Management Branch
Employment Type: 1 Full-time Temporary-Up to 2 years
Work Hours: 35.00hours per week
Affiliation: CIPP
Salary Information: $102,307.66- $124,480.72 annually (2025 rates of pay)
Location: 100 Constellation, Nepean
City: Ottawa, ON
Job Category: Information Technology
Application Close:03/07/2025

JOB SUMMARY

The mandate of Information Technology Services is to create business value by providing innovative and strategic technology solutions for the business operations of the City of Ottawa.

You are responsible for providing technical oversight to the design, planning and implementation of assigned high-risk/large-scale and highly technical IT solutions that impact the overall IT Ecosystem. You are also responsible for serving as the department’s technical subject matter expert on the assigned solution, and leading the provision of its critical, day-to-day operations.

This role requires extensive expertise in SAP Data Architecture with a focus on Azure integration. It necessitates a comprehensive understanding of SAP modules such as Finance, HR/Success Factors, and Ariba, along with proficiency in SAP data structures, CDS Views, BW/4HANA, and SAP HANA Native Modeling. Experience with ETL/ELT tools, including SAP Data Services, Azure Data Factory, and MS Fabric, is essential. Advanced skills in data governance, metadata management, and modeling are critical, as is the ability to integrate business process knowledge with technical data flow design. Proficiency in reporting tools such as Power BI and SAP Analytics Cloud, coupled with the ability to develop data warehouse and Lakehouse architectures, is also a key requirement.

EDUCATION AND EXPERIENCE

Completion of 4 year university degree in Computer Science, Computer Engineering or related field

Minimum of 7 years of progressively responsible experience conducting technical design and architecture over a broad variety of software and hardware environments

KNOWLEDGE

• Computer science/IT concepts, principles and methodologies relevant to Ecosystem-wide technical design and architecture
• ITIL service delivery framework, including ITIL processes and best practices (including change management processes)
• Current and emerging industry standards and best practices used in solution design, architecture, development, testing, integration, implementation and maintenance
• IT security practices
• Process data modelling techniques
• Technical QA/QC processes
• Awareness of the department’s IT Project Life Cycle, and policies, standards, procedures and processes that pertain to the work activities
• Relevant legislation and regulations (e.g. AODA)
• Knowledge of applicable health and safety legislation, including the rights and duties of workers.
• For technology infrastructure positions:
• Technology infrastructure security practices and products (firewalls, virus protection)
• Internet connectivity protocols, issues and services (TCIP/IP, QoS, VLAN)
• IP/data/voice LAN/WAN network architecture and components (routers and switches, gateways, Ethernet, Fast Ethernet, Gigabit, SNMP and protocol analyzers)
• Infrastructure applications (Citrix)
• Storage and back-up technologies (Hitachi Storage Systems, NetApp, Commvault)
• Knowledge of underlying storage protocols (NFS, Fibre channel)
• Virtualization technologies (VMWare, Citrix)
• Technology infrastructure hardware (HP servers, SUN servers, CISCO, F5)
• Deployment of applications in both LAN and WAN environments
• Network Management tools (CISCO Prime, MS-SCCM)
• For web software architecture positions:
• Strong demonstrated development experience and knowledge in web technology including web application and server architectures, .NET framework, Java web application frameworks (Spring, Hibernate, Java Server Faces), application security, user interface design, portal architectures and web services (including SOAP and REST)
• For database positions:
• Experience in database and Extract-Transform-Load (ETL) architectures with Oracle, SQL Server and MySQL databases on multiple operating systems such as Windows, Solaris and Linux platforms; in database software and infrastructure operations; and in database management and maintenance for third party software.
• Knowledge of SAP ERP 6, SAP netweaver, HANA, S4/HANA architecture
• Knowledge of SAP modules: PM, HR, PS, MM, FI, CRM, etc.
• Demonstrated development experience using legacy SAP technologies including structured ABAP, ALV reports, function modules, Data Dictionary, SAP forms, etc.
• Experience analysing standard SAP functionality and identifying functionality gaps and approaches to enhance using: Customization, core mods, Badis, User Exits, enhancements, etc.
• Experience integrating SAP with other systems using idocs, ETL, APIs, Add-Ons and PI
• Demonstrated development experience using new SAP technologies including ABAP OOP, Web Dynpro ABAP/Java, Fiori (Odata, HTML5, JQuery) and HANA
• Knowledge and experience in Data Modeling and Database Design, Data Storage and SAN principles and Data Analytics
• For software architecture positions:
• Strong demonstrated experience and knowledge in Application Design and Modeling

COMPETENCIES, SKILLS AND ABILITIES

• Troubleshoot and solve problems
• Work in partnership with other sections of ITS, the Corporation and the vendor community
• Develop and maintain effective working relationships with clients and interact with staff at all levels
• Brief and advise senior management on technical decisions in a non-technical manner
• Lead teams comprised of different technical specialists, including external consultants
• Negotiate service agreements with external suppliers
• Handle multiple, overlapping projects
• Research, analytical and forecasting skills
• Demonstrates initiative and a good work ethic
• Self-motivated and reliable
• Works effectively under pressure
• Tact and diplomacy
• Client service focussed

WHAT YOU NEED TO KNOW

• Language Requirement:English oral, reading, writing
• Experience and formal training combined with demonstrated performance and ability may substitute for stipulated academic requirements.
• Please save a copy of the job poster. Once the closing date has passed, it will no longer be available.

We wish to thank all applicants for their interest and effort in applying for this position. Only candidates selected for interviews will be contacted.

The City of Ottawa promotes the principles of diversity and inclusion and adheres to the tenets of the Canadian Human Rights Act and the Ontario Human Rights Code. We encourage applications from members of Indigenous, Black and other racialized communities, persons with disabilities, women and non-binary persons, persons of all ethnic origins, religions, sexual orientations, classes, gender identities and expressions.
Candidates are encouraged to self-identify as a member of one or more designated employment equity groups in the self-identification questionnaire.

The City of Ottawa provides accommodation to applicants during all parts of the hiring process, upon request. If contacted to proceed to the selection process, please advise us if you require any accommodation.

Accessible formats and communication supports are available upon request. Please contact the Employee Service Centre at 613-580-2424 extension 12211 or via email at [e-mail] .