Solutions Architect 4 (Data Architect)

Edgewater Technical Associates

$120K — $150K *
Information Technology
11 - 15 years of experience
Job Overview by Ladders

Qualifications

  • Master's degree with 15+ years experience or equivalent in lieu of formal education.
  • 7+ years of experience designing, building, and operating Databricks workloads using medallion architecture.
  • Certifications in Oracle ERP Cloud and SAP required.
  • Hands-on experience with various Databricks components including Delta Lake and Unity Catalog.
  • Strong cloud architecture experience, particularly with security and data storage solutions.
  • Proven track record of migrating enterprise data from legacy systems to Databricks.
  • Deep understanding of data security governance practices.

Responsibilities

  • Advise on and implement Databricks reference architecture and SQL solutions.
  • Provide hands-on design guidance for Databricks full-stack solutions.
  • Design and recommend data movement and integration strategies for cloud platforms.
  • Lead migrations from legacy systems to new cloud architectures.
  • Establish data governance frameworks and security standards.
  • Mentor technical teams on data architecture best practices.
  • Collaborate with security teams to ensure policy compliance.

Benefits

  • Flexible schedule options (9/80 or 5/8s available).
  • Per diem available for qualifying individuals.
  • Remote work opportunity with occasional travel for onboarding and meetings.
Full Job Description
Solutions Architect 4 (Data Architect) opportunity in Los Alamos, NM, to support the Los Alamos National Laboratory.

Per diem available for those who qualify.

Location: Remote, Travel to the site for onboarding and potential meetings.

Group/Organization: ADS-BADS

Schedule: 9/80 A schedule, 5/8s available (flexible)

Summary:

The Data Architect will be using agile methodologies to design, build, and transform business solutions through an ERP Modernization effort and beyond to stabilization. As a member of the Business Applications and Data Services group (ADS-BADS), you will focus on executing an enterprise-wide data strategy to modernize our core operational data store and transition to a cutting-edge, scalable data platform.

Los Alamos National Laboratory has selected SAP for our next-generation Cloud ERP solution. In parallel, we will require a future state data strategy to take advantage of new tools and technology to help us modernize our current on-prem operational data store. This work plays a critical role in supporting key institutional initiatives such as enabling real-time analytics, AI/ML capabilities, and enhanced operational efficiency.

The Data Architect will be critical in the transformation of our legacy data environment into a modern, cloud-native architecture. In concert with institutional knowledge experts and ERP implementation planner and integrators, you will define the data strategy, standards, and blueprints for migrating and integrating high-volume operational data into a new platform, ensuring data integrity, security, and accessibility across the enterprise.

Key responsibilities include:

• Advise on the Databricks reference architecture covering Lakeflow, Delta Lake, Unity Catalog Mosaic AI, Databricks SQL, and Databricks Apps

• Provide hands-on guidance on Databricks full-stack solution design

• Advise on design of both data movement (e.g. batch, real-time streaming) and zero-copy patterns

• Guide platform migrations from legacy SQL and document stores onto Databricks and related cloud data platforms

• Recommend security, governance, and compliance-as-code: Unity Catalog ABAC, governed tags, row filters/column masks, key management, networking security and compliance security profiles.

• Advise on design of segregated/tiered data pool architectures aligned to the organization's data classification policy and applicable regulatory requirements, including cross-tier data movement

• Recommend FinOps and performance standards, workload and cost management

• Mentor data engineers, analysts, and AI/ML teams participate in architecture reviews and contribute to standards

• Work with information & cyber security, and other teams as needed for compliance to policies and standards

• Evaluate emerging Databricks capabilities and recommend adoption strategies, including endpoint integrations with third parties as they evolve

Required Qualifications:

• Masters/15+ years of experience; additional experience may be considered in lieu of experience.

• 7+ years designing, building, and operating Databricks workloads with medallion layer architecture

• Certifications: Oracle ERP Cloud and SAP.

• Hands-on experience with Delta Lake, Unity Catalog, Spark Structured Streaming, Lakeflow (or DLT/Live Tables), Databricks SQL, MLflow, and Mosaic AI Model Serving

• Strong experience in cloud architecture supporting the platform (VPC/VNet, Security, S3/ADLS, KMS, etc.)

• Proven experience migrating enterprise data workloads from legacy/on prem data warehouse/lake to Databricks

• Production streaming and CDC experience

• Depth in security and governance: Unity Catalog policies (ABAC), classification, encryption, access auditing, compliance-to-control translation

• Hands-on experience designing multi-tier Databricks architectures driven by data classification requirements

• Strong Python and SQL, Spark, Notebooks

• Excellent verbal and written communication skills

Desired Qualifications:

• Previous government experience

• Active Databricks certifications

• GenAI and agent systems on Databricks experience

• Delta Sharing and Databricks Clean Rooms for controlled, governed data exchange across organizational/cross-tier/system boundaries

• Familiarity with Oracle EBS and SAP enterprise data

• Experience with SAP BDC/DataSphere and Databricks integration to SAP BDC, with zero-copy patterns

• Lakeflow Designer, Databricks Apps, Genie, Databricks One

• CI/CD, Infrastructure-as-Code (e.g. Terraform) for data platforms

• Experience in designing, building, and supporting BI reporting layers

• Data Quality and Data Governance experience

• Prior experience in regulated industries (e.g. utilities, life sciences, government services) and exposure to related frameworks (e.g. FERC/NERC, HIPAA, GxP, GDPR, FedRAMP, ITAR, etc.)

Other Job Requirements:
  • United States Citizenship
  • Must be able to obtain and maintain DOE Q Security Clearance.


If you are interested in being considered for this position and your resume clearly outlines your relevant experience for this position, please follow the application steps via our website: www.edgewatertech.net/careers

Edgewater will not submit your resume without first having detailed discussions with you and obtaining your permission to do so. We look forward to hearing from you!

Similar Jobs

More Jobs at Edgewater Technical Associates

More Information Technology Jobs

Find similar Solutions Architect 4 (Data Architect) jobs: