TELECOMMUTE Data Architect

CHITECH RESOURCES, INC.

United States

6 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

5 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Application Programming Interfaces (APIs) Databases Data Governance Extract Transform Load (ETL) Data Migration Datasheets Human Resources Information System (HRIS) Intrusion Detection Systems Netsuite QuickBooks (Software) Standard Sql SAP (Applications)

+7 more

SQL Databases Boomi Zapier Enterprise Integration Data Management Workday Mulesoft

Job description

A database-focused engineer to resolve cross-platform data-matching failures, cleanse legacy data, and act as the data-integrity gatekeeper across NetSuite, Archdesk, and Paycor - plus recommend and stand up an iPaaS layer for long-term governance.

What you’ll own

Database ID override resolution - fix the architectural conflict blocking external Employee IDs (from Paycor) and Job IDs (from Archdesk or similar external project systems) from being accepted into NetSuite.
Legacy QuickBooks cleansing & mapping - dedupe and migrate 2 years of customer/vendor master data into a clean NetSuite master database.
Cross-system employee ID reconciliation
Database-to-process swim lane mapping with the IT Director.
Custom field/metadata audit structures for client billing portal parameters.
iPaaS recommendation and implementation for ongoing API connectivity and data governance.

Deliverables

Reconciled, locked cross-system Employee ID and Job ID matching database.
CFO-approved, cleansed customer/vendor CSV import templates for NetSuite sandbox loading.
A full database-to-operational-process workflow spec sheet for API programmers., * Experience specifically resolving NetSuite internal-ID-vs-external-ID conflicts (this is a known, named pain point in NetSuite implementations with multiple source systems - candidates who’ve hit this before will ramp fastest). * Direct Archdesk or Paycor data-reconciliation experience. * CFO/finance-facing communication experience (this person will present cleansed data for CFO sign-off).

Requirements

5+ years in data migration/integration engineering, ideally with at least one ERP (NetSuite strongly preferred; SAP/Dynamics/Workday acceptable if paired with strong SQL and API integration depth).
Hands-on ETL and data-cleansing experience at the scale of full customer/vendor master migrations.
SQL fluency and comfort auditing/repairing ID-matching logic across disparate systems.
Experience with at least one iPaaS platform (Celigo, Boomi, Workato, MuleSoft) - implementation, not just usage.
Payroll/HRIS data reconciliation experience (Paycor a plus) and construction/field-services data patterns a plus.