Data Administrator/Database Administrator

Spectraforce Technologies, Inc.; Nashville (TN); Vor Ort; USD 39.000 - 52.000; Vollzeit

Zusammenfassung

Spectraforce Technologies, Inc. is seeking a Data Administrator/Database Administrator in Nashville, TN for a 7-month in-person role with potential for hybrid work after training.

You will identify and document fields in the legacy system, profile data with SQL, ensure data quality, and support reporting and data migrations. The role requires strong SQL, Excel, data mapping, and stakeholder communication, with the ability to manage multiple workstreams and timelines.

Qualifikationen

• Advanced SQL skills for querying, profiling and data integrity validation.
• Strong Excel skills including lookups, pivot tables and data modeling.
• Experience with data mapping and documentation.
• Strong analytical and problem-solving abilities.
• Ability to manage timelines, deliverables and multiple workstreams.
• Effective communication with technical and non-technical stakeholders.

Aufgaben

• Identify, validate, and document all fields in the LARS legacy system.
• Analyze field relationships, dependencies, and usage across extracts, certificates, and API data feeds.
• Update data mapping docs and maintain a centralized data dictionary.
• Perform SQL-driven data profiling, validation checks and trend analyses.
• Respond to tickets and deliver accurate reporting outputs using SQL.
• Support data migration cycles through profiling, validation and testing.

Kenntnisse

Advanced SQL

Excel (lookups, pivot tables)

Data mapping

Data profiling

Analytical thinking

Timeline management

Stakeholder communication

Tools

ServiceNow

SQL

Jobbeschreibung

Data Administrator/Database Administrator

Work Schedule: Monday-Friday, 8:00 AM-4:30 PM CST

Duration: 7 months

Location: 665 Mainstream Dr, Nashville, TN 37243

Work Model: In-person, with potential for hybrid work after training

Key Responsibilities

1. Field Identification, Mapping & Documentation

• Identify, validate, and document all existing fields in the LARS legacy system.
• Analyze field relationships, dependencies, and usage 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 data anomalies and quality concerns, document findings, and elevate issues as needed.
• Track recurring issues and 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 is validated and results are clearly documented.
• Store completed reports and SQL scripts in the designated repository.

4. Modernization Project Support

• Participate in vendor meetings and represent legacy system data requirements.
• Review vendor mapping documents and validate the accuracy of source-to-target field mappings.
• Support data migration cycles through 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 data integrity validation.
• Strong Microsoft 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.