Enrollment Data Analyst

American Fidelity; Oklahoma City (OK); On-site; USD 65,000 - 90,000; Full time

Job summary

American Fidelity is seeking a data-focused professional in the OKC metro area to support Enrollment Solutions. You will query data from Oracle, MS SQL Server and other databases, and design and operate Enrollment EDI processes.

The role requires 3-5 years of database development experience, a Bachelor's in CS or related field, and the ability to work independently or in a team, communicating technical and non-technical details clearly.

Qualifications

• Bachelor's degree in Computer Science or related area; 4+ years experience in database development in lieu of degree.
• 3-5 years experience in database development and enrollment/payroll systems.
• Skilled in developing ETL and SQL processes that are efficient and meet department expectations.
• Strong knowledge of EDI technology, tactics and processes.
• Capable of working independently or in a team to deliver solutions and adapt to new environments and tools.
• Excellent communication of ideas, specifications and status updates to technical and non-technical professionals.
• Knowledgeable of department databases (Access, SQL Server, etc.).
• Excellent organizational skills, attention to detail, and motivation.
• Skilled in developing queries and stored procedures via SQL scripts.
• Familiar with Agile/Scrum and Waterfall project management methodologies.

Responsibilities

• Query data from database systems such as Oracle, MS SQL Server or other DBMS.
• Provide support for Enrollment EDI processing, including design and operations.
• Responsible for daily EDI operations for the Enrollment Solutions department.

Skills

ETL development

SQL scripting

EDI technology

Agile/Scrum

Communication

Database knowledge

Team work

Project deadlines

Education

Bachelor's degree in Computer Science

Tools

Oracle

MS SQL Server

Access

Job description

Location

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.

Education and Certifications

Bachelor's degree from a four‑year college or university in Computer Science or related area; 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 adapt 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.