Software Developer - .Net, SSRS

NYS Office Of Information Technology Services • Menands, NY

1d • Hybrid

About The Position

The Software Developer will design, develop, and implement PORTS projects for the Office of Parks, Recreation and Historic Preservation (OPRHP). The role collaborates with team members and stakeholders to translate requirements into effective, scalable applications. Work is split between telecommuting and the Albany, New York office, with 50% in each setting. The position is a 30-month contract, with an in-person interview.

Requirements

• At least 84 months of experience developing backend services and REST APIs using Microsoft .NET 8, C#, Entity Framework, and ASP.NET.
• At least 84 months of experience in SQL Server database design and development, including tables, stored procedures, triggers, views, and functions using T-SQL.
• At least 60 months of experience designing and developing reports using SSRS and ETL packages using SSIS to automate data extraction and transfer processes.
• Bachelor’s degree in Computer Science or a related field.
• At least 60 months of experience in web development using Angular, HTML, CSS, and JavaScript for integration.
• At least 36 months of experience using a source code controller such as TFS or Git, including setting up CI/CD pipelines for automated builds and deployments.
• At least 60 months of experience creating technical documents based on business needs while working with internal teams who interact with external subject matter experts and vendors.

Responsibilities

• Develop and maintain REST APIs and backend services using .NET, C#, ASP.NET, and Entity Framework.
• Design, write, and optimize complex T-SQL queries, stored procedures, functions, views, and triggers in SQL Server.
• Create DDL and DML scripts and migrate them to lower and production databases.
• Work with business analysts and technical leads to translate business requirements into technical documentation.
• Create and maintain technical specifications and data-flow documentation.
• Participate in all phases of the Secure Software Development Life Cycle (SSDLC), ensuring compliance with security and quality standards.
• Design and develop SSRS reports for integration with the application.
• Design and develop SSIS packages to automate data extraction and transfers.
• Use Git for application code and document repositories, code reviews, and CI/CD pipeline workflows.

What This Job Offers

• Career Level: Senior