Systems Analyst II (.NET Developer) – Design & Delivery
Job Summary
- Motor Registration Division (MRD) supporting driver licensing vehicle registration carrier registration/compliance and Interprovincial Record Exchange (IRE).
- Ticket Management System (TMS) supporting the administration of offences for the Department of Justice and Public Safety.
- Design develop enhance and maintain enterprise applications using the ecosystem.
- Develop solutions using:
- C#
- Core
- MVC
- Framework
- Implement application functionality and system enhancements based on technical and business requirements.
- Troubleshoot application issues and perform performance optimization.
- Develop reusable scalable maintainable and secure application components.
- Work across integration data business logic and presentation layers.
- Design develop and maintain RESTful APIs technologies.
- Develop and integrate service-based and SOAP web services where required.
- Implement secure performant scalable API and integration patterns.
- Support integration between enterprise applications and downstream/upstream systems.
- Participate in redevelopment and modernization of existing data extraction processes.
- Support API testing documentation deployment and troubleshooting across environments.
- Apply appropriate security authentication authorization validation and error-handling practices.
- Design and develop SQL-based solutions using Microsoft SQL Server.
- Write complex SQL queries and stored procedures.
- Support data extraction transformation reporting feeds and data exports.
- Analyze existing data structures and develop efficient database solutions.
- Support data quality validation reconciliation and issue resolution.
- Work with project stakeholders to ensure accurate and reliable downstream reporting and analytics data.
- Develop and enhance user interfaces integrated back-end services.
- Build front-end solutions using:
- HTML
- CSS
- Modern CSS frameworks
- JavaScript
- Razor and/or Blazor
- Implement UI components based on UX designs and established accessibility standards.
- Maintain consistency between the core solution associated modules and portals.
- Troubleshoot UI issues and contribute to front-end performance optimization.
- Participate in planning and executing migration of data from legacy/source systems to the modernized target platform.
- Develop migration utilities transformation logic and validation routines.
- Perform data quality checks and reconciliation.
- Investigate and resolve migration-related data issues.
- Collaborate with data specialists developers business stakeholders and testing teams.
- Support migration testing cycles and production cutover activities.
- Assist with solution testing including:
- Test script development
- Test execution
- Defect identification
- Remediation
- Regression testing
- Support API and integration testing.
- Investigate application defects and implement appropriate fixes.
- Participate in performance and technical troubleshooting activities.
- Assist with solution design and technical documentation.
- Document APIs integration processes data flows and technical solutions.
- Track tasks and deliverables using Kanban/Planner boards or equivalent project management tools.
- Participate in regular development meetings stand-ups technical discussions and project planning sessions.
- Follow established development source-control security accessibility and deployment practices.
- Post-secondary education through a 2 year program in:
- Computer Science
- Information Systems
- Management
- Business
- Education must be from a recognized institution.
- Equivalent demonstrated professional experience may be considered.
- C#
- Core / MVC
- Framework
- RESTful web services
- SOAP-based web services
- Git-based version control
- SQL development
- Complex SQL queries
- Stored procedures
- Microsoft SQL Server
- Data extraction
- Reporting feeds
- Data exports
- HTML
- CSS
- Modern CSS frameworks
- JavaScript
- Razor and/or Blazor
- 5 years of demonstrated experience working in a Systems Analyst / Developer capacity.
- Recent hands-on experience within the ecosystem including .NET Framework and/ Core.
- Designing secure and scalable APIs.
- Developing RESTful APIs.
- Developing/integrating service-based implementations.
- Supporting secure enterprise integrations.
- Supporting downstream data extraction.
- Supporting reporting and analytics capabilities.
- Their specific role and responsibilities within development teams.
- Experience working within appropriately sized development teams and technical structures.
- Collaboration with:
- Software developers
- Solution architects
- DevOps teams
- QA/testing teams
- Data specialists
- Business analysts
- Business stakeholders
- Other technical/business partners
- Participation in Agile or comparable software development practices.
- Attendance at technical meetings stand-ups planning sessions and solution discussions.
- Contribution to achieving project milestones and successful application delivery.
- Legacy/mainframe modernization
- Enterprise application modernization
- Data migration
- Government or public-sector systems
- Large-scale enterprise applications
- API-led integration
- REST/SOAP services
- SQL Server-based applications
- .NET Framework Core modernization
- Secure and scalable API architectures
- Accessibility-compliant web applications
- Reporting/data extraction solutions
- Application integration and interface modernization
- Organization/client name
- Project name
- Project purpose and scope
- Project start and end dates
- Candidates role
- Assignment duration and allocation
- Team size and structure
- Candidates responsibilities and contributions
- Technologies used
- Nature of integrations/data migration
- Relevant deliverables and outcomes
Required Skills:
C# .NET Core Framework REST APIs SOAP Web Services API Integration SQL Server Complex SQL Queries Stored Procedures Data Extraction Data Migration HTML CSS JavaScript Razor Blazor Git Front-End Development Enterprise Application Development Systems Analysis Software Development Application Testing API Testing Data Validation Troubleshooting Agile Technical Documentation Legacy/Mainframe Modernization
Required Education:
2 year post-secondary program in Computer Science Information Systems Management or Business from a recognized institution; equivalent professional experience may be considered.