Data Lead: Architecture, Ingestion & Platform Enablement

Job Summary

xScion is seeking a Data Lead: Architecture, Ingestion & Platform to work on an xScion project team with one of our clients. The candidate will lead the end-to-end Data Hub solution architecture and ingestion strategy, translating OEB's goals into a scalable, performant, and testable cloud data platform.

About the Role

The candidate will translate RFQ scope and OEB objectives into a solution blueprint spanning ingestion, storage, access, and analytics for DB/DC/Health benefits data. They will design the secure, cloud-based Data Hub architecture, define standards for file formats, schemas, metadata, data versioning, and reconciliation patterns, and advise on query optimization, clustering/partitioning, workload management, cost controls, and monitoring.

Responsibilities

• Design the secure, cloud-based Data Hub architecture (AWS, Databricks, Redshift, Glue, cataloging) optimized for performance, scalability, data quality, and resilience
• Produce logical and physical data models for structured/semi-structured sources from third-party recordkeeper and internal systems, ensuring IV&V testability
• Define standards for file formats, schemas, metadata, data versioning, and reconciliation patterns supporting analytics, IV&V, and audit readiness
• Design and prototype ingestion pipelines, transformation jobs, and storage layouts aligned to architecture and IV&V requirements
• Support troubleshooting of data-quality or performance issues identified during IV&V and testing
• Partner with Governance, Security, and IV&V leads to ensure delivery within the June–November term and support the November 2026 go-live goal

Requirements

• Bachelor's degree in Computer Science, Information Systems, Business IT Management or equivalent practical experience
• 8+ years in data architecture or data engineering with at least 3 years in cloud data platform roles
• Hands-on AWS data services experience: S3, Glue, Glue Data Catalog, Redshift, Athena, or equivalent
• Databricks experience required — Unity Catalog, Delta Lake, and ingestion pipeline design strongly preferred
• Strong data modeling skills (logical/physical), schema design, and metadata management
• Experience ingesting structured and semi-structured data from third-party or external recordkeeper systems
• Proficiency designing RBAC and ABAC security models for sensitive or regulated data environments
• Experience producing architecture documentation and standards that can be reviewed and validated by an independent IV&V team

Qualifications

• Prior experience with HIPAA-regulated health data or defined benefit/defined contribution plan data
• Familiarity with Federal Reserve, OCC, FDIC, or equivalent financial institution security and data standards
• Experience with data versioning, lineage tooling, and record storage management at scale
• AWS Certified Data Engineer, Solutions Architect, or Databricks certifications (nice to have)

Skills

• Proficiency in data architecture and engineering
• Experience with cloud platforms (AWS, Databricks)
• Strong analytical and problem-solving skills
• Excellent communication and collaboration skills

Benefits

• Medical, dental, 401(k) match
• Flexible spending account
• Parental leave
• Wellness benefits
• Up to 27 days off a year (including your birthday!)
• Remote work opportunities
• Continuous learning and development opportunities

Pay

Competitive salary commensurate with experience

Schedule

Full-time position

Company Culture

xScion is a woman-owned organization that values diversity and inclusion. We are committed to creating a workplace where everyone feels valued and respected. We offer a range of benefits, including medical, dental, and retirement plans, as well as remote work options and paid time off. We also prioritize continuous learning and development through our Communities of Practice, technology partnerships, and certification programs.

Why xScion?

We are a leading provider of regulatory technology solutions for financial services, healthcare, nonprofit, and public sector organizations. We are dedicated to helping our clients navigate complex compliance and technology requirements and achieve lasting value through digital transformation. As a woman-owned business, we are committed to promoting diversity and inclusion and providing a supportive and inclusive work environment.