Data and AI Solutions Engineer

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

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 :
• Identify opportunities for AI driven tools (e.g., document intelligence, natural language
• dashboards, claims triage support).
• 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 - 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.

Vision : See in the normal visual range with or without correction; vision sufficient to read computer screens and printed documents.