Technical Architect, Data Architecture

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 focusing on data architecture, data technologies, standards , enterprise data and processes you are responsible for : developing Solution Architectures and end-to-end Data / Information Architectures for various client scenarios, architect data warehouse, DataMart’s and data stores, that impact the overall IT Ecosystem.  You are also responsible for supporting the Data Governance initiatives in the organization, providing technical oversight to the design, planning and implementation of  data strategy and roadmaps, You are also responsible for supporting the identification and classification of existing enterprise data sets to produce a comprehensive data architecture map serving as the department’s technical subject matter expert  on the assigned solution, and leading the provision of its critical, day-to-day operations.

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
• Cost-benefit analysis techniques
• Technical performance management 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)
• E-mail systems (MS Exchange)
• Server operating systems (Microsoft Server 2008, UNIX, Solaris)
• Virtualization technologies (VMWare, Citrix)
• Technology infrastructure hardware (HP servers, SUN servers, CISCO, F5)
• Wireless/mobile technologies (Blackberry, WiFi, Remote Access)
• 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.
• For SAP architecture positions:
• 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
• For data architecture positions:
• 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

• Organize work and meet deadlines
• 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
• Conduct risk analysis
• Demonstrates initiative and a good work ethic
• Self-motivated and reliable
• Works effectively under pressure
• Tact and diplomacy
• Client service focussed