Application Developer - Grant Management System Remediation & Workday Integration
Position Summary
The Application Developer is responsible for the remediation, enhancement, maintenance, and integration of the organization's Grant Management System (GMS) with Workday and related enterprise applications. This role will design, develop, test, and support Windows desktop applications, web services, data integrations, reports, and database components that support grant lifecycle management, financial compliance, budgeting, cost allocation, and reporting functions.
The Developer will work closely with business stakeholders, project managers, database administrators, and Workday integration teams to modernize and maintain a mission-critical application environment. The position requires strong expertise in Microsoft technologies, including C#, .NET Framework, WPF, SQL Server, SSRS, SSIS, and enterprise integration services.
Essential Duties and Responsibilities
1. Application Development
- Remediate, enhance, and maintain the organization's Grant Management System to support evolving business and compliance requirements.
- Design, develop, and support Windows desktop applications using C# and .NET Framework 4.6.2.
- Develop and maintain user interfaces utilizing Windows Presentation Foundation (WPF), Ribbon controls, and WinForms components.
- Implement and support Model-View-ViewModel (MVVM) architecture using SimpleMvvmToolkit.
- Develop reusable application components, business logic, and service layers.
2. System Integration
- Design and maintain integrations between the Grant Management System and Workday.
- Develop and support WCF (SOAP) services utilizing FSADataService and related enterprise service components.
- Design and consume APIs, web services, and data exchange processes.
- Utilize Newtonsoft.Json for data serialization and JSON processing.
3. Database Development
- Develop, optimize, and maintain Microsoft SQL Server databases.
- Create and support T-SQL stored procedures, functions, views, triggers, and queries.
- Manage and maintain SSDT database projects.
- Design and troubleshoot database performance issues and data integrity concerns.
- Develop and maintain ADO.NET data access layers using typed DataSets.
4. Reporting & Analytics
- Design, develop, and maintain SQL Server Reporting Services (SSRS) reports.
- Support embedded reporting solutions utilizing Microsoft ReportViewer controls.
- Develop data extracts, dashboards, and operational reports supporting grant management activities.
5. Data Integration & ETL
- Design, develop, and maintain SSIS packages for ETL processes and data feeds.
- Support data migration, validation, transformation, and reconciliation activities.
- Monitor and troubleshoot automated integration processes.
6. Testing & Quality Assurance
- Create and execute MSTest unit tests.
- Participate in code reviews and application testing activities.
- Develop documentation, deployment procedures, and technical specifications.
- Ensure adherence to software development lifecycle (SDLC) standards and best practices.
7. DevOps & Source Control
- Utilize Visual Studio, MSBuild, and NuGet package management tools.
- Manage source code through Azure DevOps, TFS, or equivalent version control platforms.
- Participate in release management, deployment automation, and application support activities.
8. Production Support
- Analyze and resolve application defects, incidents, and performance issues.
- Provide technical support for business users and operational teams.
- Participate in after-hours support activities as required for critical system releases or production incidents.
