AddressCITY OF DIEPPE
Information Technology Department
Job Description
Business Systems Analyst and Programmer
SUMMARY
Reporting to the IT Department's Business Systems Manager, the incumbent plans, designs, develops, tests, documents, implements and maintains new and existing software in support of the municipality's operational requirements and business processes. He performs preliminary, functional and organic analyses of the various Business Systems to help managers make sound technological decisions and maximize the benefits of IT system investments. In addition, he provides level 2+ and 3 support to level 1 support analysts and users, and solves more complex problems relating to Business Systems, databases and system integrations.
DUTIES AND RESPONSIBILITIES
• Collaborate with external partners, suppliers and teams to meet the operational requirements of the municipality's departments, participating in the selection and implementation of appropriate technical solutions and Business Systems
• Analyze and model system requirements, document processes and develop improvement strategies, based on in-depth research into solutions and systems available on the market, and then manage some of the projects involving the implementation of new systems and improvement of existing ones
• Develop a variety of technical solutions including system integrations, data conversions, automated tasks and more by performing reliable and efficient programming in common programming languages such as C#, .NET, ASP.NET and Python
• Perform sometimes complex analyses in an SQL Server (and occasionally Oracle) environment and, as needed, prepare SQL Server Reporting Services (SSRS) reports against the databases of the City's various systems, often in the absence of documentation describing the data model
• Develop sometimes complex programmed workflows to meet municipal operational requirements
• Establish rigorous validation procedures to guarantee the quality of systems implemented, developed or modified
• Play the super-user role in systems under his responsibility, providing technical support to level 1 support analysts and sometimes to users for the most complex problems (levels 2+ and 3), carrying out analysis, coordinating with suppliers and implementing corrective measures
• Keep abreast of new technologies in the field to ensure that the municipality is up to date in terms of IT services
• Develop user training and documentation for the Business Systems and solutions under his responsibility
• Ensure good security practices to guarantee the availability, integrity and confidentiality of IT services
• Manage the complete lifecycle of systems and determine the impact of new versions and legislative changes on systems
MINIMUM REQUIREMENTS
Education and experience
• University degree or college diploma in computer science or software engineering, and five (5) years' recent work experience with programming techniques, relational database technology and project management
• An equivalent combination of education and experience may be considered
Knowledge
• Good knowledge of business processes and/or Microsoft Dynamics GP software or equivalent
• Extensive knowledge of Microsoft Office (Word, Excel, Outlook, Access)
• Knowledge of common programming languages, including C#, Python and ASP.Net
• Knowledge of code and system resource management concepts with Git
• Advanced knowledge of SQL queries
• General knowledge of MS SQL and Oracle database management
• Knowledge of creating reports using SSRS
• In-depth practical knowledge of data import and transformation for analytical purposes
• Solid understanding of application architecture and database structure
• Knowledge of development under Azure and Microsoft 365 (definite asset)
• Development knowledge of ArcGIS and ESRI systems and APIs (definite asset)
• Knowledge of the New Brunswick Right to Information and Protection of Privacy Act and other laws and ethical codes pertaining to the computer field (asset)
• Basic accounting knowledge (asset)
• Knowledge of Lean Six Sigma improvement processes (asset)
Skills
• Strong communication skills in spoken and written French and English
• Strong analytical, reasoning and creative problem-solving skills
• Ability to manage multiple projects and tasks simultaneously and to set and meet deadlines
• Ability to write technical and non-technical documentation
• Ability to communicate ideas and technical concepts in a clear and accessible manner
• Ability to adapt to change and be resourceful in overcoming challenges
• Initiative, discernment, discretion and confidentiality
• Ability to work independently and as part of a team
• Excellent interpersonal skills
• Positive attitude with respect to the interests of the municipality and the community in general
• Physical ability to do the work assigned
• Punctuality and regular attendance
• Good past record of job performance
• Respect for the City of Dieppe's confidentiality rules and organizational values
WORK SCHEDULE
• Thirty-five (35) hours per week (must be available outside of regular business hours)
SALARY
• Based on the current salary scale
N.B.: The above statements reflect the characteristic aspects of the job in question and are intended to describe the general nature and level of work performed. They should not, however, be considered an exhaustive list of all the responsibilities, duties, abilities, and inherent requirements of the position. All staff members may, from time to time, be required to perform duties outside their normal responsibilities, as needed.
Note: The municipality officially declared itself a francophone city offering bilingual services in 2000 (Municipal Administration Language Policy A-9). As the language of work is French, all employees must be able to communicate orally and in writing in English and French.
Revised - November 2023
