> Markdown version of [/jobs/ext/2155434-lead-developer-genai-data-warehouse-business-intelligence](https://www.wearedevelopers.com/jobs/ext/2155434-lead-developer-genai-data-warehouse-business-intelligence). 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, Data Warehouse & Business Intelligence - **Company:** Propertyvalue R Systems, Inc. - **Location:** West Sacramento, CA, United States - **Experience:** Expert - **Contract:** Temporary contract - **Skills:** Application Programming Interfaces (APIs), Artificial Intelligence, Airflow, Amazon Web Services, Business Analytics Applications, Data Analysis, Big Data, Information Systems, Computer Engineering, Data Architecture, Information Engineering, Extract Transform Load (ETL), Data Warehousing, Decision-Making Software, Machine Learning, Power BI, Software Engineering, SQL Databases, Tableau (Software), Workflow Management Systems, Cloud Platform System, Large Language Models, Snowflake, Prompt Engineering, Generative AI, Information Technology, Data Analytics, Star Schema, AWS Data Analytics, Data Management, Looker Analytics, Data Pipelines, Sql Tuning, Amazon Redshift - **Published:** August 20, 2026 - **Apply:** https://www.dice.com/job-detail/f3bf249e-0088-4855-a0c2-8c0b01a6c5d3 ## About the Role * Minimum 10 years of experience in Data Engineering, Business Intelligence, Analytics, or Data Warehousing. * Minimum 5 years of experience leading teams of at least three members in delivering enterprise-level BI or large-scale Data Warehouse projects. * Minimum 5 years of experience working with AI, Machine Learning, or Generative AI technologies. * Proven delivery of at least two production-grade BI or Data products, including dashboards, APIs, semantic models, or analytics solutions. * Minimum 2 years of experience with: * ETL/ELT pipelines * Snowflake, Amazon Redshift, or similar cloud data warehouse platforms * Airflow, dbt, or similar orchestration tools Minimum 2 years of hands-on experience with: * OpenAI APIs or similar LLM platforms * Prompt engineering * Natural Language to SQL/query systems * AI-powered analytics solutions Strong expertise in: * SQL performance tuning * Advanced joins and window functions * Data modeling (Star Schema and Snowflake Schema) * Semantic layer design * BI platforms such as Power BI, Tableau, or Looker Experience leading stakeholders through requirements gathering, analysis, solution design, and implementation. Preferred Qualifications * Bachelor''s degree in Computer Science, Computer Engineering, Information Systems, or related discipline. * Industry certifications such as: * AWS Certified Solutions Architect * AWS Data Analytics Certifications * Snowflake Certifications * Microsoft Power BI Certifications * Tableau Certifications * AI/ML or Generative AI Certifications Experience developing GenBI (Generative Business Intelligence) solutions. Experience working within financial services, investment management, pension funds, or highly regulated environments. Experience with cloud architectures and data platforms. ## Description We are seeking an experienced Lead Developer to lead the design, development, enhancement, and support of enterprise-scale Investment Data Warehouse (IDW) solutions with advanced Generative AI (GenAI), Artificial Intelligence (AI), Machine Learning (ML), and Business Intelligence (BI) capabilities. The successful candidate will provide technical leadership for the development of data-driven solutions that enable advanced analytics, natural language querying, predictive insights, and automated decision-making., * Lead the design, development, and implementation of enterprise Business Intelligence and Data Warehouse solutions. * Architect and develop AI/ML and Generative AI-powered analytics solutions. * Build and maintain data pipelines using ETL/ELT technologies. * Design and develop semantic data models, dashboards, APIs, and analytics products. * Implement and optimize natural language to SQL/query solutions using Large Language Models (LLMs). * Lead prompt engineering initiatives to improve GenAI solution performance and reliability. * Collaborate with business stakeholders, analysts, architects, and development teams to define requirements and deliver business solutions. * Provide technical leadership and mentorship to developers and analysts. * Ensure scalability, performance, security, and maintainability of BI and AI solutions. * Support cloud-based data platforms and orchestration tools including Snowflake, Redshift, Airflow, and dbt. * Drive best practices in data architecture, AI governance, analytics, and software development lifecycle processes. ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [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) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Beyond GPT: Building Unified GenAI Platforms for the Enterprise of Tomorrow](https://www.wearedevelopers.com/videos/1525-beyond-gpt-building-unified-genai-platforms-for-the-enterprise-of-tomorrow) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) ## Related Articles - [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) - [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [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) - [MLOps And AI Driven Development](https://www.wearedevelopers.com/magazine/82-mlops-and-ai-driven-development)