[Hiring] Architect @TekWissen

Role Description

We are seeking experienced Data Archival professionals to lead the design and implementation of an enterprise-grade archival solution on Platform 3 (Archon). Product-specific training on Archon will be provided; the role demands strong foundations in enterprise data archival, ETL design, and data-platform architecture. Scope spans end-to-end delivery — from source-system discovery and retention-rule design, through platform setup, ETL build, archival execution, validation, and operational handover. Candidates will work across Production and Non-Production environments, deliver Warm and Cold archival tiers (with de-identification), and align the solution to enterprise security and compliance standards.

Key Responsibilities

• Solution Architecture & Design
  • Define end-to-end archival architecture on Platform 3 (Archon), including Archon Data Store (ADS), Archon ETL, and Archon Analyzer components.
  • Design Warm Archive, Cold Archive (de-identified), and Data Bunker tiers in line with retention, legal-hold, and WORM compliance requirements.
  • Translate business retention, privacy, and regulatory policies into archival rules, data classification, tier-mapping logic, and de-identification/tokenization strategies.
  • Produce reference architecture, data flow, integration, and security design artifacts aligned to the customer's System Security Plan (SSP).
  • Define retrieval patterns including predefined SQL/reports via the Archon UI, distributed query (Trino/Spark), and API-based access where required.
• Implementation & Delivery
  • Lead Platform 3 (Archon) setup and configuration across Production and Non-Production environments, including DR and HA where in scope.
  • Design and oversee build of archival ETL pipelines using Archon native ETL, including extraction, transformation, indexing, and loading into ADS.
  • Drive source-system connectivity, schema discovery, and dependency mapping using Archon Analyzer.
  • Own pilot execution on a defined data subset, then scale-up to full archival of in-scope source systems.
  • Lead data validation, reconciliation, volumetric verification, and source-system archival sign-off.
• Performance, Monitoring & Issue Resolution
  • Develop monitoring dashboards and operational reports for archival jobs, ETL pipelines, and storage tiers.
  • Troubleshoot and resolve issues across Archon ETL pipelines, archival workflows, source-system connectivity, and retrieval performance.
  • Define SLAs, alerting thresholds, and run-book remediation steps for common failure modes.
  • Drive root-cause analysis for Sev1 and Sev2 issues.
• Governance, Compliance & Stakeholder Management
  • Ensure archival design meets regulatory, audit, and information-governance requirements applicable to the customer's industry.
  • Partner with customer Architecture, Security, Compliance, DBAs, application owners, infrastructure teams, and SMEs.
  • Represent delivery in design and architecture reviews.
  • Define monitoring, runbooks, documentation, and knowledge-transfer artifacts.
  • Support warranty and operational handover.
  • Provide technical guidance and structured training to DBAs, application owners, operations teams, and business users.
  • Identify and manage technical risks and drive Change Control when scope or assumptions change.

Qualifications

• Strong SQL and relational database expertise including:
  • DB2
  • Oracle
  • SQL Server
  • Mainframe / AS-400 data sources (preferred)
• Strong experience with:
  • Data Warehousing
  • Data Lakehouse Architectures
  • ELT / ETL Design Patterns
  • Parquet / ORC
  • Iceberg / Delta
  • Metadata-driven ingestion
• Experience with Azure storage technologies:
  • Azure Blob Storage
  • ADLS Gen2
  • Tiering and Lifecycle Policies
  • Cost Optimization
• AWS S3 experience is a plus.
• Working knowledge of:
  • SSO
  • SAML
  • OIDC
  • AES-256 Encryption
  • KMS
  • Secure Credential Management
• Experience with:
  • REST APIs
  • File-based extraction patterns
  • CDC-based extraction patterns
  • MuleSoft and iPaaS integrations
• Strong understanding of:
  • Data Retention
  • Legal Hold
  • Audit Trails
  • Information Lifecycle Management
• Knowledge of:
  • GLBA
  • SOX
  • HIPAA
  • GDPR
  • NAIC Model Regulation #672
  • PII/PHI Handling
• Experience implementing:
  • WORM Compliance
  • Chain-of-Custody Controls
  • Role-Based Access Controls
• Prior Archival / Decommissioning Implementation Experience
• End-to-end delivery of one or more enterprise archival or application decommissioning programs.
• Preferably 2+ completed archival/decommissioning programs for Senior Architect-level candidates.
• Experience archiving data from at least two of the following:
  • Mainframe (AS/400, COBOL/DB2, VSAM)
  • SAP ECC
  • PeopleSoft
  • JD Edwards
  • Siebel
  • Lotus Notes
  • Legacy Policy Administration Systems
  • Healthcare EHR Platforms
  • Custom RDBMS Applications
• Experience with TB-scale archival projects.
• Experience in:
  • Volumetric Estimation
  • Throughput Optimization
  • Reconciliation Activities
• Prior experience with one or more archival platforms:
  • Archon / Platform 3
  • Informatica ILM
  • OpenText InfoArchive
  • Solix EDMS
  • Archive360
  • IBM Optim
• Experience defining and operationalizing:
  • Retention Rule Sets
  • Legal Hold Workflows
  • De-identification Rules
• Experience driving:
  • Pilot-to-Scale Deployments
  • Go/No-Go Governance
  • Defect Triage
  • Production Sign-Off
• Experience with:
  • Application Decommissioning
  • Infrastructure Shutdown
  • License Recovery
  • Audit Closure

Soft Skills

• Strong written and verbal communication.
• Ability to author:
  • Solution Designs
  • Architecture Documents
  • Runbooks
  • Technical Procedures
• Strong stakeholder management across business, application, security, compliance, and infrastructure teams.
• Strong problem-solving abilities.
• Ability to work independently in complex, multi-stakeholder environments.

Preferred Qualifications

• Hands-on experience or familiarity with:
  • Archon Data Store (ADS)
  • Archon Native ETL
  • Archon Analyzer
  • Archon Data Bunker
  • Archon UI
  • Trino
  • Spark-based retrieval
• Insurance domain experience, especially:
  • Life & Annuity (L&A)
  • Closed-Block Administration
• Experience with Policy Administration Systems:
  • Verisk FAST
  • Oracle OIPA
  • LifePRO
• Certifications in:
  • Archon
  • Informatica ILM
  • Equivalent Archival / ETL Technologies
• Exposure to:
  • Collibra
  • Alation
  • Gartner-recognized archival and governance platforms

Years of Experience

• 14.00 Years of Experience

TekWissen® Group is an equal opportunity employer supporting workforce diversity.