Job description

Job Title: 7114 - Business Intelligence (BI) Developer (Must Reside in Sacramento, CA to be Considered) Overview We are seeking a highly skilled Business Intelligence (BI) Developer to design, develop, and maintain enterprise-level data and analytics solutions. This role involves working with BI & Data Warehouse (BI&DW) tools, SQL, Power BI, and cloud platforms, with a strong emphasis on integrating Generative AI and machine learning for advanced analytics. This is a long-term contract position (up to 24 months, with possible extensions). Work is based in Sacramento, CA. Key Responsibilities • Design, develop, and deliver BI solutions including enterprise reports, dashboards, data warehouses, data lakes, and ETL processes. • Collaborate with data architects, ETL developers, analysts, and stakeholders to define requirements and deliver data-driven solutions. • Integrate Generative AI into BI platforms to automate insights and improve decision-making. • Apply machine learning and AI frameworks to deliver predictive analytics and forecasting. • Translate business requirements into functional and technical design documents. • Develop and optimize SQL queries, procedures, functions, and views for performance and scalability. • Create and maintain Power BI dashboards, reports, and data models. • Perform deep-dive analysis of data sets to ensure high-quality reporting and business insights. • Lead and conduct functional testing of BI solutions, ensuring data accuracy and quality before release. • Perform monitoring and optimization of BI systems and solutions. • Provide written documentation, user guides, and weekly/monthly status reports. • Communicate technical risks and issues effectively and recommend solutions. • Support knowledge transfer to staff and stakeholders. Minimum Required Qualifications • 1+ year of hands-on experience using Generative AI in data analytics solutions. • 5+ years of experience designing and developing data analytics and BI dashboards with Microsoft Power BI. • 5+ years of experience creating and optimizing SQL queries, procedures, functions, and views with a solid understanding of database principles. • 3+ years of experience developing solutions with Snowflake or AWS Redshift data warehouses. Desired Qualifications • Bachelor s degree (or equivalent experience) in Computer Science, Information Technology, or related field. • 5+ years of experience working with Agile methodologies and the Software Development Life Cycle (SDLC). • 5+ years of experience using Power BI Data Analysis Expressions (DAX) to create queries, measures, and models. • 3+ years of experience in regulated industries such as government, financial services, or investment portfolios. • Strong ability to leverage business knowledge to design analytical data models and reports that serve business users. • Proven ability to conduct functional testing and validate BI solutions for accuracy and performance. • Experience leading requirements gathering, cross-functional collaboration, and functional design documentation. • Familiarity with additional BI/reporting tools such as Tableau or Looker. • Strong written and verbal communication skills, with the ability to present technical findings to non-technical audiences.

Requirements