Solution Architect – Data Platforms & Solution Delivery

Req number:

Employment type:

Worksite flexibility:

CAI is a global technology services firm with over 8,500 associates worldwide and a yearly revenue of $1 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right—whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.

Job Summary

Job Description

What You’ll Do

• Work with stakeholders to gather and analyze business, data, and technical requirements for new and evolving data solutions.
• Develop conceptual, logical, and physical solution architectures for data platforms, data products, analytics, and AI/ML projects.
• Guide projects through the entire solution lifecycle, from requirements and design to build, testing, and deployment.
• Integrate data from multiple sources (SAP and non-SAP), ensuring interoperability and seamless data flow.
• Define solution-level security, access controls, and compliance requirements in partnership with data governance and security teams.
• Lead efforts in performance optimization, cost management, and solution scalability.
• Produce clear technical documentation and solution architecture diagrams to support implementation and knowledge transfer.
• Stay up-to-date with advances in cloud, data engineering, and analytics technologies and recommend improvements.
• Collaborate across teams—including data engineers, data scientists, DevOps, and business stakeholders—to ensure effective delivery and adoption of solutions.

What You'll Need

Technical Proficiency:

• Solution Architecture & Data Platforms: Designing data platforms and architecture (conceptual, logical, physical). Cloud-native and hybrid data solutions (Databricks Lakehouse, AWS), Integration of SAP and non-SAP data sources.
• Databricks Lakehouse Platform: Medallion Architecture, Delta Lake & DLT Pipelines, PySpark Workbooks, Spark SQL & SQL Warehouse, Unity Catalog (data governance, lineage), Genie (query performance, indexing), Security & Role-Based Access Control.
• Programming: Python, SQL, PySpark, Spark, Scala.
• AWS Cloud Services: IAM, S3, Lambda, EMR, Redshift, Bedrock.
• Solution Delivery: Familiarity with DevOps and CI/CD processes, Solution documentation and architecture diagramming, Performance tuning and cost optimization, Experience with data modeling (ER, dimensional), Knowledge of data security and compliance frameworks.
• Strong communication, presentation, and stakeholder management skills.
• Bachelor’s or Master’s degree in Computer Science, Information Systems, Engineering, or a related field.
• Certifications in Databricks, AWS, or Solution Architecture
• Experience with SAP ERP, S/4HANA, DataSphere, ABAP, and CDS views
• Exposure to data mesh or data product management concepts
• Background in manufacturing or enterprise analytics environments

Physical Demands

• This role involves mostly sedentary work, with occasional movement around the office to attend meetings, etc.
• Ability to perform repetitive tasks on a computer, using a mouse, keyboard, and monitor.

Reasonable accommodation statement

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodations@cai.io or (888) 824 – 8111.