.NET Systems Integration Analyst/ Systems Analyst

Job SummaryThe System Analyst will support DHCAs 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 DHCAs 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 matrixEntity-relationship modelsSystem integration planGap analysis report between databasesTechnical design document and integration blueprintQualifications:Proven experience in systems analysis, preferably in government or housingrelated 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 DevOpsAbility to create technical design documents and integration blueprintAbility to model business processes and produce ER DiagramsAbility to produce a traceability matrix, system integration plans, and gap analysisExcellent communication, documentation, and stakeholder engagement skillStrong analytical and problem-solving abilitiesWe will never send communications through any other domain, including @, @

Created: 2025-11-01