.NET Integration Developer/Systems Analyst

Job  Summary
The System Analyst will support DHCA’s Housing Portal Phase IIb by leading the integration of approximately six housing databases and related programs—Licensing, Code Enforcement, Multifamily, Landlord and Tenant, Rent Stabilization, and Common Ownership Communities—into a unified platform. The analyst will assess current systems, design and document integration workflows, and ensure seamless data exchange across SQL Server, SharePoint, Azure, and internal applications. This role will also define business process models, coordinate with stakeholders to capture functional needs, and provide technical guidance to advance DHCA’s long-term data modernization goals, including unified reporting, automation, and improved operational efficiency.

Responsibilities:

• Deliverables include a requirements traceability matrix, backend data architecture documentation, and integration design diagrams that define how DHCA databases will interconnect through the Housing Portal.
• The analyst will ensure that all data integration activities adhere to County IT security policies, data privacy standards, and applicable regulations related to housing data.
• The analyst will develop scripts, utilities, or proof-of-concept connectors to validate backend integration designs.
• Requirements traceability matrix
• Entity-relationship models
• System integration plan
• Gap analysis report between databases
• Technical design document and integration blueprint

Qualifications:

• Proven experience in systems analysis, preferably in government or housing
• related projects.
• Strong knowledge of data integration techniques, including ETL processes and API-based data exchange.
• Proficiency in SQL and experience with relational databases (e.g., SQL Server) .
• Programming experience in C# (.NET Framework/.NET Core) for backend development and system integration.
• Familiarity with RESTful APIs, JSON/XML, and web services.
• Experience with scripting or programming languages such as Python, JavaScript, or PowerShell is a plus.
• Understanding of system development life cycle (SDLC) and Agile methodologies.
• Experience with tools such as Azure DevOps
• Ability to create technical design documents and integration blueprint
• Ability to model business processes and produce ER Diagrams
• Ability to produce a traceability matrix, system integration plans, and gap analysis
• Excellent communication, documentation, and stakeholder engagement skill
• Strong analytical and problem-solving abilities

Powered by JazzHR

cmDNAEHjmv