- Company Name
- City of St. John's
- Job Title
- Business Systems Analyst
- Job Description
-
**Job Title**
Business Systems Analyst
**Role Summary**
Analyze, design, implement, and support business applications and systems for a municipal organization. Deliver enterprise-wide solutions, including commercial off‑the‑shelf (COTS), SaaS, and custom software, while ensuring user security, system performance, and integration with existing infrastructure.
**Expectations**
- Apply IT best practices and departmental procedures to all phases of application lifecycle.
- Keep abreast of vendor solutions and emerging technologies relevant to municipal operations.
- Provide ongoing training, documentation, and guidance to system users and junior developers.
**Key Responsibilities**
1. Define business system requirements and recommend applications (COTS, SaaS, custom).
2. Implement and deploy solutions: requirement definition, design, coding (C#, .NET, PHP, XML, HTML, CSS), testing, debugging, data conversion, documentation, and deployment.
3. Manage application‑level user access and security across all systems.
4. Offer primary application support: enhancements, configuration changes, software patching, troubleshooting, and vendor liaison.
5. Oversee enterprise SQL Server environment: create maintenance plans, perform backups, secure databases, monitor performance, and tune SQL Server.
6. Maintain ERP applications and develop integrations/interfaces.
7. Administer enterprise email, Microsoft Office 365, SharePoint, mobile deployments, intranet, and public websites: maintenance, web application development, security, upgrades, and user training.
8. Develop custom reports and queries: capture requirements, design SQL views, write stored procedures.
9. Mentor or coordinate with SQL/Reports Developer as needed.
**Required Skills**
- Programming and development: C#, .NET, PHP, XML, HTML, CSS, web design, web services.
- Development tools: Microsoft Visual Studio, Visual SVN.
- Web server and CMS proficiency: IIS, SharePoint, Drupal, Apache/Tomcat.
- Reporting: Crystal Reports, SQL Server Reporting Services (SSRS).
- Technical support: Microsoft SQL Server, enterprise business applications (financial management, HR/payroll, land management, mass appraisal, public safety/CAD, CRM, Office productivity).
- Networking fundamentals.
- Strong analytical, problem‑solving, and communication skills.
**Required Education & Certifications**
- High‑school diploma plus a 3‑year post‑secondary Diploma in Information Technology.
- Minimum 3 years’ experience in programming and systems analysis with comparable responsibility and complexity.
*(All statements may be used for ATS recognition and global job‑matching applications.)*