> Markdown version of [/jobs/ext/2118725-lead-developer-genai](https://www.wearedevelopers.com/jobs/ext/2118725-lead-developer-genai). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Lead Developer - GenAI - **Company:** AVATAR IT SOLUTIONS, LLC - **Location:** West Sacramento, CA, United States - **Experience:** Expert - **Contract:** Temporary contract - **Skills:** Application Programming Interfaces (APIs), Artificial Intelligence, Airflow, Amazon Web Services, Data Analysis, Big Data, Computer Engineering, Extract Transform Load (ETL), Data Systems, Data Warehousing, DevOps, Machine Learning, Performance Tuning, Power BI, SQL Databases, Tableau (Software), Workflow Management Systems, Working Model 2D, Large Language Models, Snowflake, Prompt Engineering, Data Layers, Information Technology, Looker Analytics, Data Pipelines, Amazon Redshift - **Published:** August 19, 2026 - **Apply:** https://www.dice.com/job-detail/35fd14d5-0474-4d84-947e-5c8ca78dbe38 ## About the Role 1. At least ten (10) years of experience in data/BI engineering or analytics. 2. 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. 3. At least five (5) years of experience working with AI/ML or GenAI technologies. 4. At least two (2) proven deliveries of production-grade BI or data products (dashboards, data models, APIs). 5. 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.). 6. 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. 7. 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. 8. 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. Desirable Technical Qualifications 1. Holding technical certifications in the areas of: AWS certifications * Snowflake certificati * BI certifications (Power BI, Tableau) * AI/ML or GenAI-related coursework or credentials 2. Have a bachelor's degree in computer science, computer engineering, or related fields from an accredited or government sanctioned college/university. Client may request a copy of the diploma/degree. 3. The proposed onsite project person will be able to adhere to the hybrid working model by working on-site 2 to 3 business days per week at Client Headquarters, West Sacramento, CA. ## Description Client is seeking an experienced Lead Developer to support its Investment Data Warehouse (IDW) and accelerate the development and deployment of Investment-related BI, GenBI, AI/ML, and agentic AI use cases within AWS and Snowflake ecosystems. The Lead Developer will provide technical leadership for enterprise BI and data warehouse solutions, lead development teams, collaborate with business and technical stakeholders, and support full-stack development and ongoing maintenance and operations of the IDW platform and solutions. Key Responsibilities * Support the Investment Data Warehouse (IDW) ecosystem and Investment-related BI, GenBI, AI/ML, and agentic AI use cases. * Work directly with Client Investment Data Solutions and collaborate with technical developers, Investment stakeholders, third-party vendor teams, and technical support. * Contribute to full-stack development and ongoing maintenance and operations of the IDW platform and deployed use cases. * Apply appropriate cloud, data, AI/ML, DevOps, security, scalability, monitoring, and automation practices relevant to the role. * Prepare technical documentation, designs, diagrams, models, and other artifacts as required. * Support knowledge transfer to appropriate client employees. ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Developer Experience, Platform Engineering and AI powered Apps](https://www.wearedevelopers.com/videos/990-developer-experience-platform-engineering-and-ai-powered-apps) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [AI Model Management Life Circles: ML Ops For Generative AI Models From Research to Deployment](https://www.wearedevelopers.com/videos/1152-ai-model-management-life-circles-ml-ops-for-generative-ai-models-from-research-to-deployment) ## Related Articles - [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer) - [Got AI ideas but no money? Here are 10 free ways to level up your AI skills with Google Cloud](https://www.wearedevelopers.com/magazine/600-got-ai-ideas-but-no-money-here-are-10-free-ways-to-level-up-your-ai-skills-with-google-cloud) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [MLOps And AI Driven Development](https://www.wearedevelopers.com/magazine/82-mlops-and-ai-driven-development) - [Navigating the AI Shift](https://www.wearedevelopers.com/magazine/629-navigating-the-ai-shift) - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering)