Application Development Engineer- Oracle SQL/PL/SQL- Python/Unix Shell Scripting-ETL-AWS/Azure

1 week ago Be among the first 25 applicants
Get AI-powered advice on this job and more exclusive features.
This range is provided by Zeektek. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.
Base pay range

$40.00/hr - $45.00/hr
We have a 12 month contract to hire for an Application Development Engineer I. Must have 3-5 years of experience in a data engineering field, Oracle SQL/PLSQL, Python/Unix Shell Scripting and ETL experience. 100% Remote.
Must Haves:

3-5 years of experience in data engineering or a related field
Oracle SQL/PLSQL
Python/Unix Shell Scripting
ETL
Relevant certifications in data engineering, cloud platforms (such as AWS or Azure), and specific technologies (like SQL, Python, and ETL tools) are highly recommended
Nice to haves:

Healthcare Claims Experience
A bachelors degree in Computer Science, Information Technology, Data Science, or a related field
Referrals supporting our pillars:
Go Above and Beyond for Our Customers And One Another, Do What Is Right Not What Is Easy, Break Down Silos to Find Solutions, Listen And Ask Questions to Create Shared Understanding, Have Candid Conversations with Care, Lead With Authenticity & Vulnerability, Try New Things, Measure Success in The Trust We Build, Celebrate Winning Together and Grow Our Technology
Disqualifiers:

Lack of relevant experience, Inadequate Technical Skills, Lack of Soft Skills
Responsibilities:
Day to Day Responsibilities:Responsible for building highly stable and scalable data transformations. Source data from one primary system Amisys Oracle but source in a few different ways like direct connections and SOA APIs. Understanding Adjudication systems, and management of data transfers to and from external claim editing vendors
A significant part of the day involves monitoring and optimizing API connections and SQL queries. Explore tools to proactively catch performance issues in either stream or batch workflows and ensure that flows and queries run efficiently in both test and production environments with a focus of shifting left
Frequently collaborate with other team members and business partners. Contribute in weekly meetings to review system performance, discuss ongoing
Work with a variety of technologies, including Python, SQL, Kafka, Kubernetes, Oracle Scripting, ... Involved in enhancing design to ensure stability and scalability
Involved in project management tasks, such as documenting design changes and integration points, and ensuring that all necessary information is available for team members in a common location. They might work on designing robust ETL and reporting solutions or moving from batch to streaming
The FWA team values continuous improvement, so it is encouraged to upskill in areas like data engineering, AI, and cloud technologies. They might participate in training sessions or collaborate with other teams to enhance their skills and knowledge
Additionally:Backend development for Vended system policy updates (edits and exclusions)
Completing backend development for self service capabilities for Vended systems
Completing any backend changes to support claim status visibility in Splunk
Completing any system enhancements to continue to stabilize our batch processes
Rolling out new end to end data flow enhancements
About this role:
The Fraud, Waste, and Abuse (FWA) team is dedicated to ensuring the accurate payment of claims, which directly impacts both members and providers. The teams mission is to create positive outcomes by preventing and recovering improper payments. Here are some key aspects of the FWA teams purpose: Accurate Payment of Claims : The FWA team is responsible for leading complex pre-claim payment edits and post-claim payment recovery systems. This ensures that claims are paid accurately according to the latest policy guidelines
Collaboration : The team works closely with various partners, including Payment Integrity, Coding Analytics, and Claims partners, to enhance the accuracy of services billed and paid
Pre-Pay and Post-Pay Systems :
Pre-Pay Systems : These systems process millions of claims through scheduled batch jobs, using technologies like Oracle, SQL, Unix Scripting, Cobol, and Control-M. The goal is to identify and process as many edits as possible in-house to reduce costs associated with external vendors
Post-Pay Systems : The team also manages data transfers to and from external recovery vendors and creates custom reports for various business partners
Technology and Innovation : The FWA team is beginning to explore new technologies such as APIs, Python, and Cloud Streaming solutions to improve their processes
Impact on Business : Accurate payment of claims is crucial as it reduces costs for the organization and minimizes provider abrasion. The more accurate the billing and payment processes, the better the outcomes for members and providers
Team culture/pillars to share:
Go Above and Beyond for Our Customers And One Another, Do What Is Right Not What Is Easy, Break Down Silos to Find Solutions, Listen And Ask Questions to Create Shared Understanding, Have Candid Conversations with Care, Lead With Authenticity & Vulnerability, Try New Things, Measure Success in The Trust We Build, Celebrate Winning Together and Grow Our Technology
Job Description:
Job Profile Summary
Position Purpose:
Designs, develops, and implements complex enterprise software solutions. Collaborates closely with technical and non-technical roles such as data modelers, architects, business analysts, data stewards, and subject matter experts (SMEs) to provide design, technical analysis, development/configuration, testing, implementation, and support expertise representing the interest of the business across the enterprise.
Develops and operationalizes data pipelines to make data available for consumption (reports and advanced analytics), including data ingestion, data transformation, data validation / quality, data pipeline optimization, and orchestration. Engages with the DevSecOps Engineer during continuous integration and continuous deployment
Education/Experience:
A Bachelors degree in a quantitative or business field (e.g., statistics, mathematics, engineering, computer science).
Requires 2 – 4 years of related experience.
Or equivalent experience acquired through accomplishments of applicable knowledge, duties, scope and skill reflective of the level of this position.
Technical Skills:
One or more of the following skills are desired.
Experience with Claims/Healthcare; Big Data; Data Processing
Experience with Other: diagnosing system issues, engaging in data validation, and providing quality assurance testing
Experience with Data Manipulation; Data Mining
Experience with Other: • Experience working in a production cloud infrastructure
Experience with one or more of the following:Data Engineering/ETL
Generative AI Tools
Programming Languages: Python/Unix Shell Scripting/Oracle SQL/PLSQL/ETL/Control-M/MFT
Databases: MongoDB, Oracle, SQL Server, SQL Lite
Development Tools: Jira, Confluence, Git, JuypterHub, Databricks.
Additional Skills: Migration from direct database connections to Oracle APIs, designing backend systems to enable self service UI capabilities, proven best in class quality delivery (techniques to ensure no bugs released to production)
Soft Skills:
Intermediate - Seeks to acquire knowledge in area of specialty
Intermediate - Ability to identify basic problems and procedural irregularities, collect data, establish facts, and draw valid conclusions
Intermediate - Ability to work independently
Seniority level

Seniority level Associate
Employment type

Employment type Contract
Job function

Job function Other
Industries IT Services and IT Consulting
Referrals increase your chances of interviewing at Zeektek by 2x
Get notified about new Application Development Engineer jobs in

United States .
Software Engineer – Multiple Technology Tracks

Atlanta, GA $160,000.00-$180,000.00 2 days ago
Site Reliability Engineer L4, Netflix Technology Services

Developer Technologies Engineer, Robotics Reinforcement Learning

California, United States $184,000.00-$356,500.00 6 days ago
United States $130,000.00-$180,000.00 12 hours ago
United States $110,000.00-$120,000.00 8 hours ago
California, United States $100,000.00-$140,000.00 1 day ago
Pittsburgh, PA $110,000.00-$165,000.00 6 months ago
Senior Software Engineer – Application Development (India-Remote)

Alabama, United States $90,000.00-$115,000.00 1 week ago
San Francisco, CA $150,000.00-$205,000.00 5 months ago
Chicago, IL $80,000.00-$90,000.00 4 days ago
United States $85,000.00-$125,000.00 2 days ago
San Francisco, CA $150,000.00-$207,000.00 4 months ago
Washington, DC $175,000.00-$190,000.00 1 month ago
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr