Data & AI Solutions Engineer
Schools Insurance Authority
Schools Insurance Authority (SIA) is a Joint Powers Authority dedicated to meeting the risk management and risk financing needs of its membership. We partner with our members to help them be successful in preventing workplace injuries and property loss and maintaining safe and strong school environments for students and employees
We offer a comprehensive benefit package including:
· Medical, dental, and vision coverage
· Vacation and sick time
· Company paid Life, Disability, and ADD benefits
· CalPERS Employee Retirement
Starting Annual Salary Range - $90,000 to $110,000 or negotiable based on experience.
SUMMARY DESCRIPTION
Under the direction of the Digital Intelligence Manager, the Data & AI Solutions Engineer should be a versatile and forward-thinking professional to help modernize how Schools Insurance Authority (SIA) manages and uses data. The Data & AI Solutions Engineer will participate in the development and maintenance of the SIA data lake, delivering actionable insights through dashboards and reports, supporting the next generation claims system, and the implementation of automation and AI solutions across the organization.
This position combines strong technical skills with business acumen, thrives in a collaborative environment, and is motivated by building systems that have real impact for schools, staff, and member districts.
REPRESENTATIVE DUTIES
The following duties are typical for this classification. Incumbents may not perform all of the listed duties and/or may be required to perform additional or different duties from those set forth below to address business needs and changing business practices.
1. Assist with Data Lake Development & Maintenance:
o Design, build, and maintain the data lake environment.
o Implement medallion architecture (Bronze/Silver/Gold layers) for claims, finance, and risk datasets.
o Establish governance, quality checks, and documentation for ingested data.
2. Assist with Data Integration and Extract, Transform, Load (ETL):
o Build and manage robust Extract, Load, Transform (ELT) pipelines for multiple internal and external data sources (claims systems, finance, risk management, prevention services).
o Automate data refresh processes and ensure accuracy, timeliness, and security.
3. Support Business Intelligence Reporting and Analytics:
o Develop dashboards, reports and other business intelligence (BI) delivery methods using Power BI and/or other selected tools or custom programming, tailored for departmental and executive stakeholders.
o Assist Claim Management, Finance, Risk, Prevention, and IT leadership to deliver insights on claims trends, costs, prevention activities, and other performance metrics.
o Train and support staff in using reports, dashboards, and other self-service BI tools.
4. Claims System Support:
o Collaborate with IT and vendors to support and enhance the next generation claims system.
o Assist with data migrations, integrations, and system testing.
o Troubleshoot and resolve system/data issues in partnership with IT and business units.
5. Support AI and Automation Improvement Efforts:
o Identify opportunities for AI driven tools (e.g., document intelligence, natural language dashboards, claims triage support).
o Build and deploy AI/automation solutions that improve efficiency, reduce risk, and support compliance.
o Support governance and responsible AI use in alignment with organizational policies.
6. Custom Applications and Scripting:
o Design, build, and maintain custom in-house applications, scripts, and automation to support business practices (e.g., claims workflows, data exports, system monitoring, IT automation).
o Manage source control, versioning, and documentation of scripts/tools.
o Work with staff to identify opportunities where lightweight applications or scripts can fill operational gaps quickly and effectively.
7. Participate in special projects as needed.
8. Perform related duties as needed.
QUALIFICATIONS
Hands on experience with data engineering and ETL (SQL, Python, or comparable).
Proficiency in Microsoft 365 Applications/Environment
Proficiency in Power BI and familiarity with Microsoft Fabric/Azure Data services preferred.
Strong knowledge of relational databases (SQL Server preferred).
Experience building and supporting reporting and dashboards for senior stakeholders preferred.
Ability to translate business needs into technical solutions.
A “builder’s mindset” – enjoys creating new systems and solutions.
Excellent communicator, able to bridge technical and non-technical audiences.
Self-starter who thrives in a collaborative environment.
Committed to continuous learning in data, AI, and automation.
Familiarity with AI/ML frameworks or LLM-based automation preferred.
Knowledge of API integrations, containerized environments (Docker), or workflow automation (Power Automate) preferred.
Understanding of data governance, privacy, and compliance standards (FERPA, HIPAA, CMS Section 111) preferred.
Education and Experience Guidelines - Any combination of education and experience that would likely provide the required knowledge and abilities is qualifying. A typical way to obtain the knowledge and abilities would be:
Education/Training:
A bachelor’s degree from an accredited college or university with major course work in computer science, information systems, data analytics or related field preferred. Other certifications or experience will be considered.
Experience:
Three years of increasingly responsible data engineering experience.
PHYSICAL DEMANDS AND WORKING ENVIRONMENT
The conditions herein are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions.
Environment: Standard office setting; exposure to computer screens.
Physical: Sufficient physical ability to work in an office setting and operate office equipment; sit or stand for prolonged periods of time; light lifting.
Interested candidates should email a cover letter and resume to Apply4Jobs@sia-jpa.org. The subject line should reference “Data and AI Solutions Engineer Opening”.
Industry
- Insurance
Employment Type
Full-time
Full Time