Capio Group is looking for an experienced Data Engineer/Lead Developer!
Full-time employee - Sacramento
Salary: $135,000 - $145,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 Data Engineer/Lead 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 Data Engineer/Lead 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:
- At least ten (10) years of experience in data/BI engineering or analytics.
- At least five (5) years of experience in leading a team (at least 3 members) to implement enterprise-level BI and/or large data warehouse solutions.
- At least five (5) years of experience working with AI/ML or GenAI technologies.
- At least two (2) proven deliveries of production-grade BI or data products (dashboards, data models, APIs).
- At least two (2) years of experience with ETL/ELT pipelines, data warehousing platforms such as Snowflake, Amazon Redshift, and orchestration tools (Airflow, dbt, etc.).
- At least two (2) years of experience using OpenAI APIs or similar LLM platforms, building natural language to SQL/query systems, designing prompt strategies for business insights and analytics, and prompt engineering to guide the platform's system behavior.
- 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.
- At least two (2) years of experience leading a team of analysts and developers, as well as collaborating with stakeholders, to discover, document, and implement requirements and stakeholder requests for data warehouse or business intelligence projects.
- 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.
- 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 - 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 certification must be provided upon request and cannot be substituted with an experience.
- 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.
Skills Required
- At least 10 years of experience in data or BI engineering or analytics
- At least 5 years leading teams of at least 3 members implementing enterprise BI or large data warehouse solutions
- At least 5 years of experience with AI, ML, or GenAI technologies
- At least two production-grade BI or data product deliveries, such as dashboards, data models, or APIs
- At least 2 years of experience with ETL/ELT pipelines, Snowflake, Amazon Redshift, and orchestration tools such as Airflow or dbt
- At least 2 years using OpenAI APIs or similar LLM platforms, natural-language-to-SQL systems, prompt strategies, and prompt engineering
- At least 2 years of advanced SQL, data modeling, semantic layers, and hands-on experience with Power BI, Tableau, or Looker
- At least 2 years leading analysts and developers and collaborating with stakeholders on data warehouse or BI requirements
- Provide at least three client or user management-level references for applicable projects
- AWS, Snowflake, BI, or AI/ML certifications
- Bachelor's degree in computer science, computer engineering, or a related field
- Ability to work onsite 2 to 3 business days per week in West Sacramento, California
What We Do
Since 2010, we have lived our mission by combining good ideas with great people to achieve extraordinary results! Our teams are working with some of the largest government agencies in California, helping them to solve their greatest challenges. We are a small firm dedicated to big ideas and enjoy the rewards that come from hard work and commitment to our client base. We work together to innovate Every decision Capio Group makes is dictated by the needs of our clients and fueled by the passion of our employees. We are who you need us to be and will work by your side throughout the life of your project and beyond to tackle your biggest challenges. Capio Group is your “partner in change” as we grow and innovate together. We embrace education At Capio Group, we are a team of experts who are both teachers and learners. Not only do we listen and learn from you, but we also invest in the continuing education of our team so we can discover the best tools, technologies, and methods to support your business solutions. We are driven by data Relying solely on instinct or best practices to make decisions without performing any data-driven analysis can lead to ineffective budget expenditures and can have serious impacts on the progress and success of a project. Capio Group provides proof of concept design solutions so we can work accurately and efficiently to meet the time and budget requirements of our clients.
