DHCA is looking to integrate six housing databases and related programs into a unified platform, known as the Housing Portal Phase IIb, to advance their long-term data modernization goals, including unified reporting, automation, and improved operational efficiency.
Requirements
- 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-Sharp (.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.
- Experience with tools such as Azure DevOps
- Understanding of system development life cycle (SDLC) and Agile methodologies
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
Other
- Proven experience in systems analysis, preferably in government or housing related projects.
- Excellent communication, documentation, and stakeholder engagement skill
- Strong analytical and problem-solving abilities
- Ability to create technical design documents and integration blueprint
- Ability to model business processes and produce ER Diagrams
