TO APPLY:
EDUCATION, TECHNICAL SKILLS AND CERTIFICATION
• Understanding of database architecture, applications programming, and network systems, achieved through a three-year College diploma in Information Technology, Computer Programmer Analyst or a related discipline or equivalent combination of education and experience. This job may be considered for educational equivalency in accordance with County Policy.
• Knowledge of two or more of the following core technologies (Microsoft Fabric, MS-SQL, MS-SSIS/Azure Synapse/Azure Data Factory (or equivalent ETL/ELT/Pipeline toolset), Azure or other Cloud Service Provider, .NET, SAP-Netweaver, Service Oriented Architecture, and Python, PowerShell, PySpark, R, XML, JSON, JavaScript, REST, oData, SAP UI5 / Fiori, etc.).
• Knowledge of web technologies (HTML(5), XML, .Net, Python, Java, JavaScript, REST, JSON, APIs, SAP UI5 / Fiori)
• Problem solving and critical thinking skills to diagnose problems and determine steps necessary to achieve an effective solution.
• Ability to communicate effectively to users with varying levels of computer understanding. Ability to translate complicated technical language into layperson terms for training purposes.
• Ability to work effectively with constant interruptions; ability to work simultaneously on several projects independently and to use good judgment in determining priorities.
• Knowledge and experience extracting and transforming data from various operational systems, databases and datastores, such as SAP S/4HANA, SQL, NoSQL, SaaS solutions through the use of APIs
• Relevant experience supporting a production environment, support management and continuous improvement
• Relevant certifications (e.g. Microsoft Azure / BI, DP-900, DP-600, PL-300 or equivalent experience) are highly desirable.
• Knowledge and application of CI/CD processes / Source Code Management Tools (Azure DevOps, GitHub, etc.) and utilizing Deployment Pipelines (CI/CD) to productionize applications, reports, dashboards and source code.
• Technical writing skills required to document systems procedures and prepare reports.
• Valid G class drivers license and access to reliable vehicle.
• Criminal records check that is less than 6 months old at time of hire.
EXPERIENCE
• Four (4) years of experience in the information technology field developing and maintaining complex corporate database systems, BI Environments, Reporting Platforms and associated server platforms, web-enabled applications, in a large corporate setting.
• Two (2) to Three (3) years reporting and database development experience with 1 or more of the following technologies: SQL, MDX, Power BI and MS-SSRS (or equivalent reporting platform), MS-SSIS/Azure Synapse, Azure Data Factor (or equivalent ETL/ELT), MS-SSAS (or equivalent Cube Structures), DAX, PowerShell, HTML5, REST, JSON, Python, Java, JavaScript, .NET, XML, SAP UI5 / Fiori
• Experience working in Microsoft Fabric / Azure Synapse considered an asset
• Experience working in a large, complex technical environment with a wide range of infrastructure
• Experience designing, developing, and supporting/maintaining BI, Reporting Platforms, Databases and/or web applications and Interfaces
$83,331.00 - $101,374.00 per annum
