Database developer Jobs in Edmonton, AB

The program supports the delivery of new tools and enhancement of JETI's existing online investment related tools to enable prospective investors to discover investment opportunities in Alberta. The following web applications are within scope of the work required:

Alberta Economic Dashboard: The AED is a public-facing dashboard designed to promote investment and business development in Alberta by providing investors, businesses and economic developers access to relevant economic data and industry insights.

Alberta Site Selector Tool: The Alberta Site Selector Tool is an investment information service that consolidates real-time property listings with infrastructure and socio-economic data from the Alberta Regional Dashboard into a user-friendly interface that enables businesses and investors to make informed decisions about where to expand or set up shop in Alberta.

Investment Data Hub: The upcoming Investment Data Hub provides easy access to key data and information on Alberta's sectors, providing investors and regional economic developers with a central hub for the data they need to build an investment case.

Alberta Regional Dashboard: The Alberta Regional Dashboard is a dynamic data application that provides investors and economic developers with key economic indicators and information on living, working, investing and doing business in Alberta municipalities.

Alberta Major Projects: Alberta Major Projects is an inventory of major public and private projects in Alberta above $5 million. The tool is used by Alberta businesses, particularly in the construction sector, for supply opportunities, and by investors. The tool is also used extensively within JETI and by economic developers to analyze and report on investment intentions in the province.

Alberta Export Tool: The Alberta Export Tool helps Alberta exporters find international markets for their products through detailed interactive charts of Alberta's exports.

This position will be responsible for Application Development Support activities for the Economic Intelligence & Investment Services branch, which involves critical technical expertise to support the maintenance and modernization of legacy applications developed across a broad variety of platforms over the past fifteen years. It requires a robust familiarity with different development methodologies, combined with the capacity to analyze and adapt to develop styles/strategies that were not aligned with typical IT development patterns.

Required technical systems knowledge/skills:

• Cloud Architecture, Full Stack Development, Agile Methodologies, Data Management and ETL Processes, Collaboration and Leadership, Quality Assurance and Test Automation, Compliance and Security
• StencilJS
• Umbraco CMS
• Application design and change management procedures
• Programming principles, techniques, practices, logic and database design
• Website development and maintenance, including .NET framework - ASP.Net, C#, LINQ, MS SQL (This list is not complete and may vary depending on which application is being worked on at any point in time)
• Windows Operating System, Microsoft Office software, Microsoft Project
• Formal application lifecycle development methodology knowledge
• Knowledge in Bootstrap framework, HTML5, CSS3 (LESS or SASS), JavaScript, XHTML Including web services (REST, SOAP) API's
• Angular
• Ability to support Cloud Services Including: Microsoft Azure, SQL Azure, Azure Data Factory, Databricks
• Experience with data visualization and charting libraries like AmCharts, as well as experience with Mapbox/Leaflet, ArcGIS

Duties:

• Develop frontend website architecture and backend web apps
• Maintain and upgrade software following implementation
• Work closely with product management teams and graphic designers for web features
• Stay updated with the latest technological advancements in web apps and programming languages
• Handle automated testing and provide feedback during the software development phase
• Develop, write, modify, integrate and test Web site related code and Web application interfaces
• Conduct tests and analyze data to monitor quality, security, user interface experiences and to identify areas for improvement
• Develop and implement procedures for ongoing Web site revision
• Create visually appealing user interactions
• Monitor and maintain Web site functionality
• Participate in Web site architecture and design in collaboration with designers or clients
• Liaises with business unit to ensure solutions meet current and strategic ministry needs and requirements.
• Provide application functional and technical expertise.
• Execute internal testing (unit testing) and support UAT activities
• Test changes to previously created programs
• Provide overall Technical Solution Quality Assurance (QA)
• Support warranty activities as required.
• Support transition to operations (hand off) to support teams.
• Provides and maintains technical documentation of design and changes
• Participates in agile delivery meetings.
• Handle and fix production defects efficiently.
• Provide tracking and reporting of time and status on all work as required.
• Identify and coordinate release schedules
• Ensure planned releases remain on schedule and on track

Support a high level of service availability:

• Provide on-call support on an as-needed basis
• Be able to work in a fast-paced environment with minimal supervision
• Status reporting to the Manager as required