Data and AI Solutions Engineer

This an onsite role in Sacramento, CA. Candidate must be local to the Greater Sacramento Area. There is no referral fees for this position, please no 3rd party vendors.

Candidates must be able to work W2 through Ledgent Technology.

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.

Desired Skills and Experience

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.

All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, and Los Angeles County Fair Chance Ordinance. For unincorporated Los Angeles county , to the extent our customers require a background check for certain positions, the Company faces a significant risk to its business operations and business reputation unless a review of criminal history is conducted for those specific job positions.