WHAT YOU'LL DO
- Design and develop system architecture, technical documentation, and full-stack application code for City and Landlord portals.
- Create and build database specifications, including user access controls, permissions, and data security configurations.
- Perform coding and unit testing of all portal functionalities and workflows to ensure they meet functional requirements.
- Develop structured diagrams for databases, communication systems, network infrastructure, and security programs to support golden record maintenance and landlord record management.
- Design and maintain SSIS Packages, Stored Procedures, Functions, Triggers, and SQL statements within Microsoft SQL Server to support data accessibility and multi-table reporting.
- Generate complex, customized reports using Microsoft SSRS to track existing applications, pending claims, and other key program metrics.
- Develop and maintain nightly batch and ETL processes, generating daily, weekly, and monthly reports from golden records to track new and ongoing requests.
REQUIRED SKILLS
01
Front-End & Full-Stack Development
8+ years of experience with HTML/CSS, JavaScript, Angular, and .NET
02
UI/UX, Responsive Design & Security
8+ years of experience with UI/UX design principles, responsive design, and authentication/authorization
03
API, Mobile App Development & DevOps
8+ years of experience in API development, mobile app development, DevOps practices, and deployment pipelines
04
Cloud, Version Control & Collaboration
8+ years of experience with Azure, AWS, Git/GitHub/GitLab, and Azure DevOps (ADO)
PREFERRED QUALIFICATIONS
- Experience with Microsoft SQL Server, SSIS, and SSRS reporting tools.
- Familiarity with ETL process design and nightly batch job automation.
- Prior experience working on government or public sector applications.
- Experience developing multi-portal systems with role-based access control.
NOTE : ONLY LOCALS FROM NY METROPOLITAN and NJ AREA WILL BE CONSIDERED (Please check Commutable distance before applying for the position)
- Understanding of data governance practices and golden record management.