Data & AI Solutions Engineer

Zeektek; Sacramento (CA); On-site; USD 90,000 - 110,000; Full time

Job summary

A technology services company is seeking a Data & AI Solutions Engineer to modernize and manage data systems. Responsibilities include developing data lakes, supporting business intelligence through dashboards, and implementing AI solutions. The ideal candidate has a strong background in data engineering and ETL processes, with proficiency in Power BI. A bachelor's degree in computer science or a related field is preferred. This full-time role offers competitive pay ranging from $90,000 to $110,000 annually.

Qualifications

• Hands on experience with data engineering and ETL (SQL, Python).
• Proficient in Power BI and Microsoft 365 Applications.
• Excellent communicator, able to bridge technical and non-technical audiences.

Responsibilities

• Design, build, and maintain the data lake environment.
• Develop dashboards and reports using Power BI.
• Collaborate with IT and support claims system enhancements.

Skills

Data engineering

ETL

Power BI

SQL

Python

Education

Bachelor's degree in computer science or related field

Tools

Microsoft 365

Azure Data services

Docker

Job description

This range is provided by Zeektek. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$90,000.00/yr - $110,000.00/yr

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 and use 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.

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.

Assist with Data Lake Development & Maintenance:

• Design, build, and maintain the data lake environment.
• Implement medallion architecture (Bronze/Silver/Gold layers) for claims, finance, and risk datasets.
• Establish governance, quality checks, and documentation for ingested data.

Assist with Data Integration and Extract, Transform, Load (ETL):

• Build and manage robust Extract, Load, Transform (ELT) pipelines for multiple internal and external data sources (claims systems, finance, risk management, prevention services).
• Automate data refresh processes and ensure accuracy, timeliness, and security.

Support Business Intelligence Reporting and Analytics:

• 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.
• Assist Claim Management, Finance, Risk, Prevention, and IT leadership to deliver insights on claims trends, costs, prevention activities, and other performance metrics.
• Train and support staff in using reports, dashboards, and other self‑service BI tools.

Claims System Support:

• Collaborate with IT and vendors to support and enhance the next generation claims system.
• Assist with data migrations, integrations, and system testing.
• Troubleshoot and resolve system/data issues in partnership with IT and business units.

Support AI and Automation Improvement Efforts:

• Build and deploy AI/automation solutions that improve efficiency, reduce risk, and support compliance.
• Support governance and responsible AI use in alignment with organizational policies.

Custom Applications and Scripting:

• 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).
• Manage source control, versioning, and documentation of scripts/tools.
• Work with staff to identify opportunities where lightweight applications or scripts can fill operational gaps quickly and effectively.

Participate in special projects as needed.

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

Education/Training

A bachelor’s degree from an accredited college or university with major coursework 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.

Seniority level

Associate

Employment type

Full‑time

Job function

Other

Industries

IT Services and IT Consulting