xScion Solutions

Data Scientist

• Translate RFQ scope and OEB objectives into a solution blueprint spanning ingestion, storage, access, and analytics for DB/DC/Health benefits data
• 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
• Advise on query optimization, clustering/partitioning, workload management, cost controls, and monitoring for DB/DC/Health datasets in Redshift and Databricks
• 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.

Data Lead – Architecture, Ingestion, Platform Enablement

Security Engineer

• Define priority reporting and analytics use cases (360 participant view, pension calculations, compliance analytics, inactive population communications) and map them to data, security, and tooling requirements
• Establish the Data Hub governance framework: data classification, stewardship roles, approval workflows, retention rules, and incident/breach support aligned with OEB and Federal Reserve policies
• Map regulatory obligations (HIPAA, applicable state benefits laws) to concrete controls, policies, monitoring processes, and evidence expectations within the Data Hub operating model
• Recommend and oversee cataloging, lineage, and access-control approaches (Unity Catalog, AWS Glue Data Catalog, RBAC/ABAC) to support discoverability, traceability, and least-privilege access
• Define fine-grained security patterns: RBAC/ABAC, encryption, key management, logging, and monitoring for highly sensitive data
• Produce audit-ready evaluation reports summarizing compliance posture, risks, mitigations, and supporting evidence for internal audits and external reviews
• Partner with Architecture/Ingestion lead and IV&V lead to ensure governance and security requirements are built into ingestion patterns, data models, and testing from the outset.

Data Lead – Analytics, Governance, Security

Analyst

• Elicit, document, and prioritize reporting and analytics use cases (participant 360 views, pension calculations, survivor inquiries, state compliance analyses, inactive population communications) across benefits and HRIS domains
• Capture detailed functional and data requirements including data elements, derivation rules, transformations, and validation logic tied to plan rules and operational processes
• Define and maintain IV&V strategy, test plans, and test scenarios covering data ingestion, transformations, reconciliations, controls, and performance — aligned with project artifacts (requirements, risk register, test plans)
• Develop and execute structured test cases and data-validation checks for PoC and incremental deliverables, independently assessing data accuracy, integration quality, and adherence to HRIS and benefits requirements
• Document defects, gaps, and issues in a clear, traceable manner including impact analysis and remediation recommendations — maintaining independence from implementation vendors
• Collaborate with Data Architects and Governance/Security leads to ensure requirements and test cases incorporate data-quality, privacy, and compliance expectations for benefits and HRIS data
• Prepare go-live readiness assessments and IV&V validation reports summarizing test coverage, findings, simplification opportunities, residual risks, and decision options for OEB leadership

Data Lead – Architecture, Ingestion, Platform Enablement

Data Lead – Analytics, Governance, Security

IV&V Analyst – Benefits, HRIS