Position: Operations Analyst: Insurance Operations Automation #9713
Company: Lohika
Category: Other
Experience required: 5y
English level: upper

You will work with internal Oscar technical teams and potentially with technical teams within Oscar’s vendors, working independently day to day on defined work. You will report to one of our leaders on the Insurance Operations team

MAIN TASKS AND RESPONSIBILITIES:
Learn claims and member data sets and databases, plus learn internal tooling
Work from an assigned ticket queue and/or within sprints
Task and bug tickets will be completed within an agreed-upon timeframe
Migrate SQL queries from previous to future state data models
Write SQL queries and file specifications based on written requirements to create and schedule outbound files to partners
Debug standard feeds at the file level using internal tools
Set up SFTP connections with partners based on documented procedures
Report daily work in Slack, proactively raise any access or knowledge gaps that will prevent work delivery in a centralized Slack channel
During your first six weeks, you:
Have onboarded to our internal tools, data, and technical processes
Are operating independently by writing several queries and scripts within a defined weekly sprint or assigned ticket queue
Clearly communicate blockers and issues related to successful execution to your project lead and/or manager

EDUCATION, SKILLS AND EXPERIENCE:
MUST HAVE:
A bachelor’s degree or equivalent work experience
5+ years of professional experience
Experience independently writing SQL
Experience using complex structured data
Experience working within a team using a sprint or ticketing system