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 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. #J-18808-Ljbffr Zeektek