Data Architect / Technical Documentation Analyst
Location: Rancho Cordova, CA
Work Arrangement: Remote
Job Description
Estrada Consulting, Inc. (ECI) is seeking an experienced Data Architect / Technical Documentation Analyst to support a municipal enterprise application data inventory and documentation initiative.
The ideal candidate will have expertise in relational database modeling, metadata analysis, data dictionaries, source-to-target mapping, and technical documentation.
Key Responsibilities
- Develop and maintain comprehensive application data inventories.
- Create business-readable data dictionaries and technical documentation.
- Develop business-to-technical data crosswalks and relationship matrices.
- Document database tables, fields, identifiers, keys, and relationships.
- Analyze historical data structures and document relevant data relationships.
- Create and maintain editable entity relationship diagrams (ERDs).
- Review system metadata and approved technical evidence to validate documentation.
- Maintain consistent identifiers, definitions, and terminology across project deliverables.
- Record source evidence, technical limitations, assumptions, and items requiring further confirmation.
- Collaborate with functional and technical leads to ensure accurate interpretation of application data structures.
- Translate complex database concepts into clear documentation for business and technical stakeholders.
Required Qualifications
- Experience in relational database architecture, data modeling, or metadata analysis.
- Demonstrated experience developing data dictionaries, data inventories, and mapping documentation.
- Strong understanding of relational database keys, relationships, and data structures.
- Proficiency with Microsoft Excel and database diagramming tools.
- Experience producing entity relationship diagrams and technical documentation.
- Strong analytical skills and ability to communicate technical concepts to nontechnical stakeholders.
Preferred Qualifications
- Experience with Tyler EnerGov or comparable municipal enterprise applications.
- Experience documenting permitting, licensing, planning, or regulatory systems.
- Experience working with legacy data, historical records, and complex application configurations.
- Previous public-sector data architecture or documentation experience.