Business Intelligence Developer

BACKGROUND

CalSTRS is currently pursuing multiple initiatives and efforts in support of its strategic goal of Digital Transformation. These efforts include the implementation of Business Intelligence and Data Warehouse capabilities. CalSTRS Business Intelligence and Data Warehouse Project needs a Business Intelligence (BI) Developer who has the functional and technical knowledge, skills, and experience in Business Intelligence and Data Warehouse (BI&DW) tools, frameworks, standards, processes, and architectures. The role will work closely with business subject matter experts, and BI&DW project team. As an integral part of the team, the role is to help CalSTRS build better products with faster and better data and insights.

Minimum Technical Qualifications

 

• At least 5 years of experience of developing data model and data reports in PowerBI.
• At least 5 years of experience of creating SQL queries, optimizing SQL query performance, and modifying SQL elements such as procedure, functions, and views with a solid understanding of database principles.
• At least 5 years of experience of designing and developing data analytic reports, dashboards, Business Intelligence reports, and data warehouses.
• At least 5 years of experience of developing solutions within Snowflake, AWS Redshift, Microsoft Azure BI platform in the cloud, or similar technologies.
• At least 3 years of experience of programming skills especially for data exploration and presentation to management and other users of data within data warehouses.
• At least 3 years of experience with Advanced Data Analytics or Machine Learning technologies.
• Bachelors degree or equivalent experience in Computer Science, Information Technology, or similar field of study. CalSTRS reserves the right to request a copy of the degree.
  
   

Desirable Technical Qualifications

It is desirable for the proposed project person to have the following listed experience, knowledge, skills and

abilities as evidenced by Attachment II, Proposed Project Person Skill Summary Sheet and resume:

 

• Certifications of Business Intelligence, or Advanced Data Analytics, or Machine Learning. CalSTRS reserves the right to ask for a copy of the certificates.
• Experience with Agile methodologies and Software Development life cycle.
• Experience in State agency or Financials or Investment portfolios or other regulated industry highly preferred.
• Ability to use business knowledge and expertise to build analytical data models and reports that can serve to business users.
• Experience with MS Power BI DAX to create tabular models.
• Strong understanding of SQL Scripting & Stored Procedures (SQL Development).
• Exceptional ability to multi-task while maintaining tight schedules.
• Excellent writing skills and documentation skills.