Data Specialist / Web Content Analyst

NuAxis Innovations; Washington (District of Columbia); On-site; USD 95,000 - 125,000; Full time

Job summary

NuAxis Innovations seeks a Data Specialist / Web Content Analyst to bridge content operations and data engineering in Washington, DC. You will map legacy content, craft migration scripts, and ensure data quality while moving data from legacy platforms into Drupal 10+ and cloud services.

Responsibilities include auditing content, writing complex SQL, defining IA and taxonomies, validating migrations, and protecting PII in test data. 508 compliance and analytics support are expected.

Qualifications

• 5+ years in a content analyst, data analyst, or data migration role supporting enterprise web platforms.
• Strong SQL against relational databases with joins and data-quality queries; experience with DB2 and/or Aurora/MySQL.
• Hands-on CMS content migration experience (Drupal migrate framework, ETL scripting in Python/PHP).
• Knowledge of taxonomy design, metadata standards, and structured content modeling.
• Experience with data profiling, cleansing, and reconciliation on migrations at scale.
• Familiarity with JSON/XML/CSV data interchange and APIs; privacy and PII protection awareness.

Responsibilities

• Perform content inventory and audit across legacy applications and sites; create migration maps.
• Write and tune SQL to extract, profile, cleanse, de-duplicate, and reconcile content and reference data.
• Build and run repeatable migration scripts and validation; document results and defects.
• Define information architecture, metadata schemas, and controlled vocabularies for search and analytics.
• Analyze site analytics, logs, and user feedback to recommend IA improvements.
• Generate test data sets for development and QA, safeguarding PII.
• Produce data quality dashboards and stakeholder reports.
• Collaborate with developers and testers to validate post-migration content fidelity and SEO continuity.
• Support migration from legacy DB2/.NET structures to Drupal 10+ and MySQL on DOL PACE platform.
• Define and validate interface mappings for Appian-based systems, Kafka, APIs, and analytics services.
• Maintain data dictionaries and mapping specs in repositories.

Skills

SQL

Data migration

Drupal

JSON/XML

PII handling

508 Compliance

Taxonomy design

Python/PHP scripting

Tools

DB2

Aurora/MySQL

Drupal migrate

ETL scripting

Job description

Data Specialist / Web Content Analyst

Location Washington, DC

# of openings 1

Salary Range (Min-Max) 00

We are a federal IT company on a mission to make customer experience (CX) the center of every government solution.

Technology is our Passion. People are our Purpose.

We know tech, but we love people. NuAxis is home to thinkers and feelers; engineers and artists. We work hard and support each other along the way. Teamwork is more than just a buzzword for us, it's a state of mind.

We believe happy employees do amazing work, so join our team NOW! We are currently seeking a talented and motivated Data & Web Content Analyst for a Full-Time position.

Role Summary

Bridges content operations and data engineering. Analyzes structured and unstructured content, defines content models and taxonomies for a legacy-to-modern migration, and executes the data mapping, extraction, cleansing, and validation required to move content and application data from legacy platforms into a modern CMS and cloud data services.

Key Responsibilities

• Perform content inventory and audit across legacy applications and sites; produce migration maps from legacy structures to target content types, fields, and taxonomies.
• Write and tune SQL to extract, profile, cleanse, de-duplicate, and reconcile content and reference data.
• Build and execute repeatable migration scripts and validation harnesses; document reconciliation results and defect dispositions.
• Define information architecture, metadata schemas, and controlled vocabularies supporting search, filtering, and downstream analytics.
• Analyze site analytics, search logs, and user feedback to recommend content and IA improvements grounded in evidence.
• Generate representative test data sets for development and QA activities while protecting sensitive and PII-bearing data.
• Produce data quality dashboards and recurring reporting for program stakeholders.
• Partner with developers and testers to validate post-migration content fidelity, redirects, and SEO continuity.
• Support migration from legacy DB2/.NET data and content structures to Drupal 10+ and MySQL on the DOL PACE platform, preserving functional parity, records integrity, and auditability.
• Define and validate interface/data mappings for integrations with Appian-based systems (including WISE/CAPS/PWRS), Kafka/event flows, APIs, and analytics/reporting services.
• Maintain data dictionaries, mapping specifications, migration reconciliation evidence, and data-quality artifacts in DOL repositories.

Required Skills & Experience

• 5+ years in a content analyst, data analyst, or data migration role supporting enterprise web platforms.
• Strong SQL against relational databases; ability to write complex joins, aggregations, and data-quality queries. Exposure to IBM DB2 and/or Aurora/PostgreSQL/MySQL.
• Hands-on CMS content migration experience (Drupal migrate framework, ETL scripting in Python/PHP, or equivalent).
• Working knowledge of taxonomy design, metadata standards, and structured content modeling.
• Experience with data profiling, cleansing, and reconciliation on migrations at scale.
• Comfort with JSON/XML/CSV interchange formats and API-delivered data.
• Section 508 / accessibility awareness as it applies to structured content and data presentation.
• Experience validating legacy-to-modern migrations involving relational databases, APIs, and CMS data models; DB2 and MySQL/PostgreSQL experience preferred.
• Working knowledge of privacy, records retention, immutable/tamper-evident audit logging, and protection of PII in test and migration data.

Preferred Qualifications

• Experience migrating .NET/legacy application content into Drupal.
• Familiarity with event-driven data flows (Kafka topics, message schemas).
• Python or PHP scripting for automation.