Back-End/Full-Stack Developer

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

Benefits offered by this job

Flexible workplace

Great work-life balance

Job summary

Capio Group in California seeks an experienced Back-End/Full-Stack Developer to maintain and advance the IDW architecture with GenBI/AI/ML capabilities. You will work with SQL, data warehousing, and cloud services in a fast-paced environment, ensuring scalable analytics solutions.

The role emphasizes designing dashboards, applying UI/UX principles, and leveraging AWS/Snowflake ecosystems, with a flexible workplace and a strong work-life balance. On-site in Sacramento is expected.

Qualifications

• At least seven (7) years of experience in IT with data analysis or database querying.
• At least five (5) years in data engineering, data warehousing, or BI analytics.
• At least two (2) years with ETL/ELT pipelines and cloud data warehouses such as Snowflake, Redshift, or Azure Synapse; and orchestration tools like Airflow/dbt.
• At least two (2) years of advanced SQL, data modeling (star/snowflake), and hands-on BI tools (Power BI, Tableau, Looker).
• At least two (2) years of containerization and orchestration (Docker, Kubernetes), CI/CD for ML/data workflows, and cloud automation (Terraform, Ansible).
• Must provide client references; minimum of three references; ready to submit reference forms on request.

Responsibilities

• Design and build analytics dashboards using UI/UX principles with Chainlit, Streamlit, and React.
• Create interactive reporting and storytelling based on data visualization best practices.
• Leverage cloud services/APIs (e.g., Snowflake Cortex, AWS Bedrock KG) to accelerate use-case implementation.
• Build automated tests to ensure Text-to-SQL accuracy; perform prompt engineering for system behavior.
• Conduct AI/ML model prototyping with TensorFlow, PyTorch, scikit-learn; apply semantic layers and data modeling.

Skills

Front-end UX/UI design

React development

Prompt engineering

OpenAI APIs experience

Education

Bachelor's degree in computer science / computer engineering or related fields

Tools

Chainlit

Streamlit

Docker

Kubernetes

dbt

Airflow

Snowflake

Redshift

BigQuery

Job description

Capio Group is looking for an experienced Back-End/Full-Stack Developer!

Full-time employee - Sacramento
Salary: $130,000 - $140,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 Back-End/Full-Stack Developer 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 Back-End/Full-Stack Developer 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 seven (7) years of experience in the Information Technology (IT) field with extensive experience in report writing, data analysis, or database querying.
2. At least five (5) years of experience in data engineering, data warehousing, or BI analytics.
3. At least two (2) years of experience with ETL/ELT pipelines, cloud data warehouses such as Snowflake, Amazon Redshift, Azure Synapse, and orchestration tools (Airflow, dbt, etc.).
4. At least two (2) years of experience in SQL (advanced joins, window functions, performance tuning), data modeling (star/snowflake schemas, semantic layers), and hands-on experience with at least one major BI tool such as Power BI, Tableau, Looker.
5. At least two (2) years of hands-on experience in containerization and orchestration (Docker, Kubernetes), CI/CD pipelines for ML and data workflows, monitoring and logging for ML and BI systems, cloud infrastructure automation (Terraform, Ansible).
6. 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. Holding technical certifications in the areas of: A copy of the certification must be provided upon request. Certification is required and cannot be substituted with an experience.

   AWS certifications

   Snowflake certifications

   BI certifications (Power BI, Tableau)

   AI/ML or GenAI-related coursework or credentials

2. At least five (5) years of experience in front-end UX/UI design for analytics dashboards and highly interactive reporting.

3. At least four (4) years of experience in development with React for or building scalable, highly customized production-grade user interfaces.

4. At least two (2) years of experience in front-end development with Chainlit or Streamlit for AI/ML or GenAI solutions with complex state management & data handling (e.g., real-time updates; UI states for loading, retries, and partial responses).

5. Experience and understanding in latency handling and async UX patterns, explainable AI interfaces (confidence, sources, DISCLAIMERS), and prompt design basics.

6. Hands-on experience and proven ability to build chat interfaces (streaming responses, token handling), and AI-assisted workflows (autocomplete, summarization, recommendations).

7. At least three (3) years of experience working with AI/ML or GenAI technologies.

8. At least one (1) year of hands-on experience using OpenAI APIs or similar LLM platforms, building natural language to SQL/query systems, designing prompt strategies for business insights, and prompt engineering to guide system behavior.

9. At least three (3) years of experience in semantic layer design, data modeling, and delivering enterprise semantic models across multiple teams for large organizations.

10. At least one (1) year of experience in developing semantic models supporting natural language querying and AI-driven analytics (i.e., GenBI); statistical analysis, predictive analytics, and optimization.

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

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