Data Architect / Technical Documentation Analyst (Ref #: 1121686)

Estrada Consulting, Inc.

Rancho Cordova (CA)

Remote

USD 110,000 - 150,000

Full time

11 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Estrada Consulting, Inc. is seeking an experienced Data Architect / Technical Documentation Analyst to support a municipal enterprise data inventory and documentation initiative.

The role emphasizes relational data modeling, metadata analysis, data dictionaries, and crosswalks translating business terms into technical specs. You will develop and maintain application data inventories, create business-readable dictionaries, and document table structures, keys, and relationships.

Qualifications

  • Experience in relational database architecture, data modeling, or metadata analysis.
  • 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.

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.

Skills

Relational database modeling
Metadata analysis
Data dictionaries
Source-to-target mapping
Entity relationship diagrams
Technical documentation
Stakeholder communication

Tools

Microsoft Excel
ER diagram tools

Job description

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Project Manager / Business Analyst (Ref #: 1121684)
Project Manager / Business Analyst (Ref #: 1121684)

Estrada Consulting, Inc. • Rancho Cordova (CA)

Remote
USD 90,000 - 140,000
Independent Quality Assurance / Deliverable Reviewer (Ref #: 1121687)
Independent Quality Assurance / Deliverable Reviewer (Ref #: 1121687)

Estrada Consulting, Inc. • Rancho Cordova (CA)

Remote
USD 55,000 - 117,000
Remote Data Architect & Technical Documentation Analyst
Remote Data Architect & Technical Documentation Analyst

Estrada Consulting, Inc. • Rancho Cordova (CA)

Remote
USD 110,000 - 150,000
Tyler EnerGov Functional-Technical Lead (Ref #: 1121685)
Tyler EnerGov Functional-Technical Lead (Ref #: 1121685)

Estrada Consulting, Inc. • Rancho Cordova (CA)

Remote
USD 124,000 - 220,000
Remote Project Manager & Business Analyst for Municipal Data
Remote Project Manager & Business Analyst for Municipal Data

Estrada Consulting, Inc. • Rancho Cordova (CA)

Remote
USD 90,000 - 140,000
Tyler EnerGov Functional-Technical Lead (Ref #: 1121685)
Tyler EnerGov Functional-Technical Lead (Ref #: 1121685)

Estrada Consultingorporated • United States

Remote
USD 90,000 - 130,000
Tyler EnerGov Functional-Technical Lead (Ref #: 1121685)
Tyler EnerGov Functional-Technical Lead (Ref #: 1121685)

Estrada Consulting Incorporated • Rancho Cordova (CA)

Remote
USD 120,000 - 180,000
Database Administrator 1775
Database Administrator 1775

Sistema Technologies Inc. • Austin (TX)

Hybrid
USD 90,000 - 120,000
Data Architect
Data Architect

City of San Jose • San Jose (CA)

Hybrid
USD 168,000 - 204,000
Database Administrator 1778
Database Administrator 1778

Sistema Technologies Inc. • Austin (TX)

Hybrid
USD 90,000 - 120,000