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

Zeektek; United States; Remote; Full time

Job summary

A leading technology company seeks an Application Development Engineer I for a 12-month contract, focusing on data engineering. The role involves building data transformations and optimizing workflows, along with collaboration across teams to ensure accurate payment of claims. Candidates must have 3-5 years of relevant experience and technical skills in Oracle SQL, Python, and ETL processes.

Qualifications

• Requires 3-5 years of data engineering experience.
• Relevant certifications in data engineering and cloud platforms are recommended.
• Bachelor's degree in a quantitative or business field.

Responsibilities

• Build stable and scalable data transformations from multiple sources.
• Monitor and optimize API connections and SQL queries.
• Collaborate with team members and manage project documentation.

Skills

Data Engineering

Oracle SQL/PLSQL

Python

Unix Shell Scripting

ETL

Healthcare Claims Experience

Continuous Improvement

Education

Bachelor's degree in Computer Science or related field

Tools

Kafka

Databricks

Job description

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 bachelor's 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 team's mission is to create positive outcomes by preventing and recovering improper payments. Here are some key aspects of the FWA team's 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 Bachelor's 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.