Data Administrator/Database Administrator

Key Responsibilities

1. Field Identification, Mapping & Documentation
Identify, validate, and document all existing fields in the LARS legacy system.
Analyze field relationships, dependencies, and how each field is used across extracts, correspondence, certificates, and API data feeds.
Update data mapping documentation when inconsistencies or gaps are identified.
Maintain a centralized data dictionary for agency-wide reference.

2. Data Integrity & Quality Review
Perform recurring SQL-driven data profiling, validation checks, and trend analyses.
Identify anomalies and data quality concerns; document findings and escalate as needed.
Track recurring issues, systemic data risks, and recommend improvements or governance standards.
Collaborate with business units to validate data usage and improve data entry practices.

3. Ticket & Reporting Support
Respond to help desk and ServiceNow ticket requests within established timelines.
Write and execute SQL queries to deliver accurate reporting outputs.
Ensure all requested data delivers validated, clearly documented results.
Store completed reports and SQL scripts in the designated repository.

4. Modernization Project Support
Participate in vendor meetings and represent legacy system data needs.
Review vendor mapping documents and validate accuracy of sourcetotarget fields.
Support data migration cycles with profiling, validation, issue resolution, and testing.
Contribute to new system architecture, dashboards, reports, and long term data governance frameworks.
Required Skills & Qualifications
Advanced SQL skills for querying, data profiling, and integrity validation
Strong Excel skills including lookups, pivot tables, and data modeling
Experience with data mapping and documentation
Strong analytical and problem solving skills
Ability to manage timelines, deliverables, and multiple workstreams
Effective communication skills with both technical and non-technical stakeholders