Description:
Reporting to the Manager, Institutional Analysis & Information Management (I-AIM), the Programmer Analyst is responsible for analyzing, designing, developing, testing, and implementing software and business intelligence solutions for all functional areas across the college. The incumbent will receive guidance and direction from the manager and senior programmer analysts to develop project plans and priorities.
Knowledge and Skills
Being able to deliver results by having:
- Education and Experience: Bachelor's degree in computer science or a related field, and a minimum of 3 years of recent, related experience. Or an equivalent combination of education and experience.
- Programming Skills: Proficiency in various programming technologies, languages, and tools, including Visual Studio, C#.NET, .NET Core, Entity Framework Core, Azure DevOps, Razor/Blazor, JavaScript, jQuery, JSON, CSS, T-SQL, Power BI, SSRS, and SSIS. Knowledge of VB6, VB.NET, ASP.NET, ASP.NET MVC, ADO.NET is an asset.
- Analysis Skills: Strong analytical and problem-solving skills to understand business needs and translate them into technical solutions.
- Database Skills: Proficiency in database management systems, preferably Microsoft SQL Server. Additional knowledge of Oracle or MySQL is an asset.
- Agile/Scrum Team Experience: Experience working in an Agile/Scrum project team. Knowledge of agile development principles and practices.
- Communication: Excellent communication and interpersonal skills to work effectively with both technical and non-technical stakeholders.
Duties and Responsibilities
Be Passionate and Taking Initiative with these Responsibilities:
- Develop and maintains BI and software applications and database systems by evaluating client needs and analyzing requirements.
- Accomplishes programming project requirements with support from management and senior programmer analysts.
- Collaborates with all programmer analysts, ERP system analyst, and Information and Technology Services (ITS) in conceptualizing and developing new software and BI applications.
- Analyzes and assesses existing business systems and procedures.
- Conducts research on emerging application development software products, languages, and standards in support of procurement and development efforts.
- Develops, documents, and maintains web-enabled and drillable reports and dashboards.
- Integrates data from different sources.
- Extracts and manipulates large amounts of data from SQL databases and other databases by writing complex and efficient SQL queries.
- Collaborates with ITS to assist in resolving problems with the network, in-house software applications, or college software systems.
- Designs, runs, and monitors software performance tests on new and existing applications for the purposes of correcting errors, isolating areas for improvement, quality assurance, and general debugging.