Enrollment Data Analyst

American Public Life Insurance Company; Oklahoma City (OK); On-site; USD 60,000 - 75,000; Full time

Job summary

American Public Life Insurance Company in Oklahoma City is seeking an Enrollment Data Analyst to query data from Oracle and MS SQL Server, and to support daily Enrollment Solutions EDI processing and operations.

The role requires a Bachelor's degree in Computer Science or related field (or 4+ years in database development) and 3–5 years of experience with enrollment or payroll systems, ETL, SQL scripts, and clear communication with technical and non-technical teams.

Qualifications

• Bachelor's degree in Computer Science or related field, or 4+ years in database development in lieu of degree.
• 3-5 years of experience in enrollment or payroll systems is preferred.
• Strong SQL/ETL skills and experience with EDI technologies are essential.

Responsibilities

• Query data from database systems such as Oracle and MS SQL Server.
• Support Enrollment EDI processing and design/operations.
• Manage daily EDI operations for Enrollment Solutions department.

Skills

ETL development

SQL processes

EDI processing

Oracle

MS SQL Server

Data querying

Communication

Education

Bachelor's degree in Computer Science or related field

Tools

SQL scripts

Access

Job description

## Enrollment Data AnalystApplylocations: Oklahoma City, Oklahomatime type: Full timeposted on: Posted 2 Days Agojob requisition id: JR893**Must currently reside in OKC metro area****Job Description:*** Query data from database systems such as Oracle, MS SQL Server or other database management systems.* Provides support for Enrollment EDI processing as well as design and operations.* Responsible for daily electronic data interchange (EDI) operations for Enrollment Solutions department.**Educations/Certifications:*** Bachelor's degree from four-year college or university in Computer Science or related area of study; 4+ years experience in database development type work in lieu of degree**Requirements:*** 3-5 years experience* Must have enrollment or payroll systems experience* Skilled in developing ETL and SQL processes that are efficient and meet the expectations of the department.* Strong knowledge of EDI technology, tactics and processes.* Efficient working independently or as part of a team to deliver solutions and easily adjust to new environments and tool sets.* Good at communicating ideas, specifications and status updates to both technical and non-technical professionals.* Knowledgeable of department-level databases (Access, SQL Server, etc.).* Excellent organizational skills, attention to detail, and highly motivated.* Skilled in the development of queries and stored procedures through SQL scripts.* Efficiently work and produce results within the structure of project management methodologies (e.g. Agile/Scrum, Waterfall).* Demonstrate commitment to meeting organizational, department and team goals and objectives.* Knowledge of software development practices.* Strong focus on deadlines and deliverables.