Solution Architect

Capio Group; Sacramento (CA); On-site; USD 140,000 - 150,000; Full time

Benefits offered by this job

Flexible workplace

Great work-life balance

Job summary

Capio Group, a California-based IT consulting firm, seeks an experienced Solution Architect to drive data and AI/ML initiatives in the IDW architecture. You will accelerate GenBI, AI/ML deployments, and analytics across Snowflake, AWS, and related platforms, while aligning with governance and security policies.

The role is full-time in Sacramento, with a focus on UI/UX for dashboards, automated testing, and end-to-end cloud-based solutions.

Qualifications

• Minimum of 15 years in IT with senior technical/lead experience.
• 10+ years SDLC leadership across solution deployments and stakeholder collaboration.
• 7+ years AI/ML use case design and implementation.
• 5+ years cloud architecture experience (AWS/Azure/GCP) in large environments.
• 2+ years in AI infrastructure, GenAI patterns, and security governance.

Responsibilities

• Design analytics dashboards using UI/UX best practices with React, Streamlit, and Chainlit.
• Leverage Snowflake Cortex, AWS Bedrock, and other OOB APIs to accelerate use cases.
• Develop automated tests for Text-to-SQL accuracy and model reliability.
• Lead prompt engineering and model tuning for AI/GenBI platforms.
• Prototype AI/ML models with TensorFlow, PyTorch, and scikit-learn.
• Apply dbt, dimensional modeling, and cloud ML platforms for scalable pipelines.
• Implement containers, orchestration, CI/CD for ML/data workflows.
• Monitor, tune, and log AI/ML/GenBI solutions and ETL/ELT pipelines.
• Ensure cost, security, and governance across IDW ecosystem; mentor teams.

Skills

UI/UX design

React

SQL

GenAI / AI/ML

Cloud architecture

Docker / Kubernetes

Data warehousing

Education

Bachelor's degree in Computer Science or related field

Tools

Snowflake

Airflow

Matillion

Terraform

Ansible

AWS SageMaker

Azure ML

GCP Vertex AI

Chainlit

Streamlit

Kubernetes

SQL-based BI tooling

Job description

Capio Group is looking for an experienced Solution Architect!

Full-time employee - Sacramento

Salary: $140,000 - $150,000

About Us:

Capio Group is a California-based Information Technology Consulting firm serving the public sector since 2010. We assist the Government in delivering large, complex systems and solutions. Capio Group is a small, but quickly growing firm that mixes good ideas, with great people, to achieve extraordinary results for our clients. We offer the salary and benefits of the bigger companies, with the added bonus of a flexible workplace and a great work-life balance.

Scope of Work:

Capio Group is looking for an experienced Solution Architect with a detailed knowledge and expertise to work as part of a team in assisting with maintaining, enhancing, and advancing client Investment Data Warehouse (IDW) architecture/platform, which is capable of Generative Business Intelligence (GenBI), and Artificial Intelligence, Machine Learning (AI/ML) for providing deeper insights, predictive analytics, and automated decision-making capabilities. Furthermore, it is expected to drastically accelerate the development and deployment of Investment-related BI or GenBI, AI/ML, or agentic AI use cases that are to be deployed onto the IDW residing within the AWS and Snowflake ecosystems. All work must adhere to client AI policies, technology governance, standards, and guidelines.

The scope of key responsibilities and activities for the Solution Architect includes, but is not limited to, the following:

• Effectively apply User Interface (UI)/ User Experience (UX) design principles for designing and building analytics dashboards with technologies such as Chainlit, Streamlit, and React. Create interactive reporting and storytelling based on data visualization best practices, and human-centered design.
• Leverage Out-of-Box (OOB) services/functions/APIs (e.g., calling SNOWFLAKE.CORTEX functions via SQL or configuring AWS Bedrock Knowledge Bases) to accelerate the design and
  implementation of use cases.
• Build automated tests to ensure the platform's Text-to-SQL engine isn't hallucinating incorrect numbers.
• Perform continuous prompt engineering to guide and finetune the platform's system behavior.
• Execute statistical analysis, predictive analytics, optimization; conduct AI/ML model prototyping with ML frameworks such as TensorFlow, PyTorch, scikit-learn.
• Apply expertise in platform-specific semantic layers or dbt (Data Build Tool), advanced SQL and dimensional modeling (Star Schema), and cloud ML platforms (e.g., AWS SageMaker, Azure ML, GCP Vertex AI).
• Implement containerization and orchestration (Docker, Kubernetes).
  Operate CI/CD pipelines for ML and data workflows, data integration, cleaning, and transformation processes.
• Responsible for monitoring, tuning, and logging for AI/ML and GenBI solutions, Extract, Transform, Load (ETL)/ Extract, Load, Transform, (ELT) pipelines (e.g., Airflow, Matillion), cloud data warehouses & lakes (e.g., Snowflake, Redshift, BigQuery, Azure Synapse), and cloud infrastructure automation (e.g., Terraform, Ansible).
• Continuously enhance and verify that the entire IDW ecosystem/solution is cost-effective, secure, and scalable.
• Provide technical leadership, solution guidance to project teams in support of solution design and development, and act as a technical liaison among Investment stakeholders, technical developers, 3rd party vendor teams and tech support.
• Apply vast experience and multidisciplinary expertise in AI Infrastructure & Agentic Workflows/Orchestration, Generative AI Design Patterns, Cloud Strategy & FinOps, and Security & Compliance (AI Governance) to support key Investment’s initiatives.
• Analyze solutions and technologies and make recommendations based on knowledge of client Investment Branch's current and future needs.
• Proactively monitor and assess strategic direction of solution vendors, technology and market trends, and determine their potential impact and value to the IDW; prepare presentations, documents, diagrams, models, and other artifacts as required to communicate analysis, recommendations, or designs
• Transfer of knowledge to appropriate client staff is required, along with any requested materials and content for transfer of knowledge.

Mandatory Experience:

1. At least fifteen (15) years of experience in the Information Technology (IT) field with extensive experience in positions of technical developer/lead, software engineer, application architect, enterprise architect, etc.
2. At least ten (10) years of experience incorporating an industry's open & non-proprietary SDLC methodology to lead and manage various technical aspects of solution/software implementation projects, while facilitating and collaborating closely with organization's IT divisions and business stakeholders to follow all applicable project's implementation standards, processes, procedures, and best practices, etc.
3. At least seven (7) years of experience of architecting, designing & implementing AI/ML use cases or GenAI solutions.
4. At least five (5) years of experience in leading cloud architecture (AWS, Azure, GCP) for large or complex environments (multi-tier apps, enterprise integrations, or migrations), and proven delivery of end-to-end cloud solutions (not just components).
5. At least two (2) years of experience in working with AI infrastructure & agentic workflows/orchestration, Generative AI design patterns, cloud strategy & FinOps, hybrid & multi-cloud systems, security & compliance (AI Governance), etc.
6. At least two (2) years of experience in designing Microservices, distributed systems, event-driven and API-based architecture.
7. For each applicable project meeting the requirements, you must provide client/user reference contact information in the qualification form (a minimum of three(3) references total). Additionally, you must be prepared to submit completed reference forms upon request. Each reference must be a representative of the company for which the project was developed and must have served in a management or supervisory role.

Desirable Experience:

1. 1. Snowflake SnowPro Advanced – Architect
   2. AWS Solutions Architect – Professional
   3. Azure Solutions Architect Expert
2. At least two (2) years of experience providing IT consulting services in technical solution implementations to large public/governmental agencies.
   Experience supervising and guiding the implementation using industry standards and best practices such as Project Management Institute (PMI) Project Management Book of Knowledge (PMBOK), Scaled Agile Framework, IEEE, etc.
3. At least two (2) years of experience in designing Microservices, distributed systems, event-driven and API-based architecture.
4. Have a bachelor’s degree in computer science, computer engineering, or related fields from an accredited or government sanctioned college/university. A copy of the degree must be provided upon request and cannot be substituted with an experience.
5. Must be able to adhere to the hybrid working model by working on-site 2 to 3 business days per week at the client headquarters in West Sacramento, CA.

Equal Opportunity Employer:

At Capio Group, our employees are our greatest asset and diversity, equity, and inclusion are at the core of who we are. Our commitment to these values is unyielding and is central to our mission and to our impact. We know that having diverse perspectives helps to generate better ideas to solve the complex problems of our diverse clients and the communities they serve.