Data Specialist / Web Content Analyst

International Executive Service Corps; Washington, Northern (District of Columbia, KY); Hybrid; USD 90,000 - 130,000; Full time

Job summary

NuAxis in Washington, DC seeks a Data & Web Content Analyst to bridge content operations and data engineering. You will analyze structured and unstructured content, define content models and taxonomies for a legacy-to-modern migration, and perform data mapping, cleansing, and validation to move data into a modern CMS and cloud data services.

The role requires 5+ years in content or data migration, strong SQL skills, CMS experience (Drupal), and familiarity with metadata standards, privacy

Qualifications

• 5+ years in a content analyst, data analyst, or data migration role
• Strong SQL across relational databases and data-quality queries
• Hands-on CMS content migration experience (Drupal migrate framework or ETL scripting)
• Knowledge of taxonomy design, metadata standards, and structured content modeling
• Experience validating legacy-to-modern migrations involving relational databases, APIs, and CMS data models
• Awareness of privacy, records retention, and PII protection in test/migration data

Responsibilities

• Perform content inventory and audit across legacy applications and sites; produce migration maps.
• Write and tune SQL to extract, profile, cleanse, deduplicate, and reconcile content and reference data.
• Build and execute repeatable migration scripts and validation harnesses; document results and defects.
• Define information architecture, metadata schemas, and controlled vocabularies for search and analytics.
• Analyze site analytics, search logs, and user feedback to propose IA improvements.
• Generate test data sets for development and QA while protecting sensitive data.
• Produce data quality dashboards and recurring reporting for stakeholders.
• Collaborate with developers and testers to validate post-migration content fidelity, redirects, and SEO continuity.

Skills

SQL proficiency

Content analysis

Data migration

ETL scripting

Education

Bachelor's degree in Information Systems or related field

Tools

Drupal migrate framework

Python/PHP ETL scripting

Power BI/Tableau

Job description

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 is a state of mind.

We believe happy employees do amazing work, so join our team NOW! We are currently seeking a talented and motivatedData & 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.
• BI/reporting tool experience (Power BI, Tableau, QuickSight).

Education

Bachelor's degree in Information Systems, Data Science, Library/Information Science, or a related field; equivalent experience considered.

Our Profile:

We are an IT company with a unique mission- to make people the center of every federal IT solution. Our technologists have always gone the extra mile to help our federal clients succeed. And over the years, we saw a growing disconnect in how federal IT initiatives were built and managed.Time after time, programs failed because the focus was on the tools and products and not the people using them. Learn More.

NuAxis is an Equal Opportunity Employer. Employment is contingent upon successful completion of a background investigation. Learn Moreabout our Benefits and Culture!

#NAI #DICE