Solution Architect

**Req number**: R5967
**Employment type**: Full time
**Worksite flexibility**: Remote Who we are
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 We are seeking an experienced Solution Architect to drive the design and delivery of enterprise data and analytics solutions. You will work closely with business and technical teams to understand project requirements, develop conceptual and logical architectures, and oversee full lifecycle implementations— ensuring that solutions are scalable, secure, and aligned to business objectives. This role requires strong expertise in modern data platforms, cloud architectures, and end-to-end solution delivery in complex environments. This is a Full-time and Remote position.
**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