Amazon Redshift Jobs in Virginia (NOW HIRING)

As an employee, you Turn Change Into Value - for our clients, for our company, for your professional growth, and for the consumers. We hire the best and brightest, who are driven to create lasting value. At xScion, you aren't just another team member, you're impactful. You're empowered. You're driven. You're an xScioneer.

xScion is seeking an Data Lead: Architecture, Ingestion & Platform to work on an xScion project team with one of our clients. The candidate leads the end-to-end Data Hub solution architecture and ingestion strategy, translating OEB's goals (resilience, analytics, vendor independence) into a scalable, performant, and testable cloud data platform across AWS, Amazon Redshift, and Databricks.

As a Data Lead, You Will:

• 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.

To Be Successful, You Need:

• Permanent Residency or US Citizenship
• 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
• Proficiency designing RBAC and ABAC security models for sensitive or regulated data environments
• 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
• Ability to produce architecture documentation and standards that can be reviewed and validated by an independent IV&V team.

Nice to Have:

• 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.

Why xScion?

• We have an amazing culture- We were namedBest Places to Work in Virginia7 times, including 2025.
• We are poised for rapid growth- We are on the cutting edge of digital transformation in Financial Services, Healthcare, Nonprofit and Public Sector and continuously welcome new clients to the xScion family.
• We believe in your continuous development- We invest in our teams' development, including our Communities of Practice, technology partnerships, sandbox and paying for certifications and trainings to improve their skills because we are committed to collectively being the best at what we do.
• We want you to make an impact in whatever you do- Our people are given the opportunity to provide impactful change to our clients and team.
• We believe in equality
  - As a woman-owned organization, we believe in an inclusive and diverse culture where everyone's uniqueness makes us stronger.
• Great Benefits: Medical, dental, 401(k) match, flexible spending and more, but we also have unique perks such as up to 27 days off a year (including your birthday!), remote work opportunities, parental leave, wellness benefits and many other things that inspire balance and flexibility.

We're Transforming RegTech Organizations:

At xScion, we Turn Change Into Value. We help clients in highly regulated industries start or accelerate their digital transformation initiatives by shifting their mindset and goals into smaller, actionable steps that create lasting value. With more than 20 years of experience supporting Regulatory Technology (RegTech), xScion provides both domain experts and tailored solutions to help organizations navigate complex compliance and technology requirements. We specialize in Business Agility, Cloud Transformation, and Organizational Change Management solutions for clients in Financial Services, Public Sector, Nonprofits, and Healthcare. Our experts help prepare and create change to clients' processes, technology and culture in order to improve operational efficiencies and the customer experience. As a certified Woman-Owned Small Business, we are proud to be the most trusted solutions partner that business and technology leaders count on to deliver lasting, impactful value.

All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or protected veteran status. xScion takes affirmative action in support of its policy to employ and advance in employment individuals who are minorities, women, protected veterans and individuals with disabilities.

You will be added to our talent community when you apply for this job. You may opt-out at any time.

Want to Learn More about xScion?

Check us out onwww.xscion.comor socially atLinkedIn,Twitter, andGlassdoor.