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

1 week ago Be among the first 25 applicantsGet 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/hrWe 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 fieldOracle SQL/PLSQLPython/Unix Shell ScriptingETLRelevant certifications in data engineering, cloud platforms (such as AWS or Azure), and specific technologies (like SQL, Python, and ETL tools) are highly recommendedNice to haves:Healthcare Claims ExperienceA bachelor's degree in Computer Science, Information Technology, Data Science, or a related fieldReferrals 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 TechnologyDisqualifiers:Lack of relevant experience, Inadequate Technical Skills, Lack of Soft SkillsResponsibilities: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 vendorsA 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 leftFrequently collaborate with other team members and business partners. Contribute in weekly meetings to review system performance, discuss ongoingWork with a variety of technologies, including Python, SQL, Kafka, Kubernetes, Oracle Scripting, ... Involved in enhancing design to ensure stability and scalabilityInvolved 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 streamingThe 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 knowledgeAdditionally:Backend development for Vended system policy updates (edits and exclusions)Completing backend development for self service capabilities for Vended systemsCompleting any backend changes to support claim status visibility in SplunkCompleting any system enhancements to continue to stabilize our batch processesRolling out new end to end data flow enhancementsAbout 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 guidelinesCollaboration: The team works closely with various partners, including Payment Integrity, Coding Analytics, and Claims partners, to enhance the accuracy of services billed and paidPre-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 vendorsPost-Pay Systems: The team also manages data transfers to and from external recovery vendors and creates custom reports for various business partnersTechnology and Innovation: The FWA team is beginning to explore new technologies such as APIs, Python, and Cloud Streaming solutions to improve their processesImpact 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 providersTeam 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 TechnologyJob Description:Job Profile SummaryPosition 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 deploymentEducation/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 ProcessingExperience with Other: diagnosing system issues, engaging in data validation, and providing quality assurance testingExperience with Data Manipulation; Data MiningExperience with Other: • Experience working in a production cloud infrastructureExperience with one or more of the following:Data Engineering/ETLGenerative AI ToolsProgramming Languages: Python/Unix Shell Scripting/Oracle SQL/PLSQL/ETL/Control-M/MFTDatabases: MongoDB, Oracle, SQL Server, SQL LiteDevelopment 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 specialtyIntermediate - Ability to identify basic problems and procedural irregularities, collect data, establish facts, and draw valid conclusionsIntermediate - Ability to work independentlySeniority levelSeniority levelAssociateEmployment typeEmployment typeContractJob functionJob functionOtherIndustriesIT Services and IT ConsultingReferrals increase your chances of interviewing at Zeektek by 2xGet notified about new Application Development Engineer jobs in United States.Software Engineer – Multiple Technology TracksAtlanta, GA $160,000.00-$180,000.00 2 days agoSite Reliability Engineer L4, Netflix Technology ServicesDeveloper Technologies Engineer, Robotics Reinforcement LearningCalifornia, United States $184,000.00-$356,500.00 6 days agoUnited States $130,000.00-$180,000.00 12 hours agoUnited States $110,000.00-$120,000.00 8 hours agoCalifornia, United States $100,000.00-$140,000.00 1 day agoPittsburgh, PA $110,000.00-$165,000.00 6 months agoSenior Software Engineer – Application Development (India-Remote)Alabama, United States $90,000.00-$115,000.00 1 week agoSan Francisco, CA $150,000.00-$205,000.00 5 months agoChicago, IL $80,000.00-$90,000.00 4 days agoUnited States $85,000.00-$125,000.00 2 days agoSan Francisco, CA $150,000.00-$207,000.00 4 months agoWashington, DC $175,000.00-$190,000.00 1 month agoWe’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr