At XiFin, a culture of inclusivity is in our very fabric. We believe that this culture not only creates a more equitable and functional workplace, but also enhances our team members' work experiences by promoting creativity, innovation, and collaboration.
Who are we looking for?
PL/SQL Developer – Financial Data Integrity & EOM Processing
We are looking for a PL/SQL Developer to ensure financial data integrity and accuracy within our RPM system, particularly from an End-of-Month (EOM) perspective. This role will focus on maintaining and optimizing the EOM 2.0 SQL processes that generate EOM data, ensuring the system remains balanced and reliable.
What will you do?
- PL/SQL Development: Design, develop, and maintain PL/SQL code, including stored procedures, functions, and scripts to support EOM processing.
- Financial Data Integrity: Ensure data is properly balanced at the end of each month, identifying and resolving discrepancies.
- EOM 2.0 SQL Maintenance: Optimize and maintain the EOM 2.0 SQL used for EOM data creation, ensuring efficiency and accuracy.
- Pre-Balancing Maintenance: Support and maintain Pre-Balancing scripts that run as part of the corrective data process on a weekly basis.
- Query Optimization: Tune complex queries for performance and scalability, minimizing processing time for large datasets.
- Data Validation & Troubleshooting: Investigate data integrity issues, troubleshoot anomalies, and ensure consistent reporting.
- Collaboration: Work closely with finance, data engineering, and application teams to align database processes with business needs.
This is an onsite position at our office in San Diego, CA.
What education and experience do you need?
- Strong experience in PL/SQL development, particularly for financial or EOM processing.
- Expertise in SQL performance tuning, indexing, and query optimization.
- Understanding of financial data structures and balancing methodologies.
- Ability to troubleshoot data inconsistencies and improve data validation processes.
This role is critical in ensuring accurate financial reporting and maintaining system integrity for end-of-month processes.
What education and experience do you need?
A combination of the following education and experience factors will be considered:
- Education: Bachelor’s degree in Computer Science, Information Technology, or related field, or equivalent work experience.
- Experience: At least 3-5 years of experience as a Software Engineer or PL/SQL Developer, with a strong focus on Oracle databases and PL/SQL development. Experience with performance tuning and database query optimization is essential.
- Technical Expertise: Proficiency in PL/SQL and Oracle database technologies. Familiarity with SQL*Loader, Oracle Data Pump, and other Oracle utilities is a plus.
- Industry Experience: Experience in industries such as finance, healthcare, or e-commerce, where database-driven applications are mission-critical, is preferred.
Preferred Skills:
- Experience with cloud database technologies (e.g., AWS RDS, Oracle Cloud).
- Experience in Agile or Scrum methodologies.
- Familiarity with other programming languages (e.g., Java, Python) for application integration.
- Knowledge of database security best practices and compliance standards (e.g., HIPAA, PCI-DSS).
What’s in it for me?
We don't just offer benefits; we offer a comprehensive and flexible benefits package tailored for you!
- Dive into a world of cutting-edge healthcare with our comprehensive medical, dental and vision benefits, including telehealth services. Say goodbye to the hassle of prescriptions with our convenient mail-order program for 90-day maintenance medications.
- Our Health Savings Account (HSA) featuring pre-tax deductions and quarterly company contributions (HSA only) puts more money in your pockets!
- Plan for your golden years with confidence through our 401k retirement plan, complete with a company match.
- Fuel your ambition with our Tuition Assistance program, empowering you to reach new heights in your professional journey.
- Finally, experience true well-being with XiFin's BeWell Program, where we champion physical, mental, financial, and social wellness, because your success and happiness are our ultimate priorities
Why XiFin?
XiFin is a healthcare information technology company that empowers healthcare organizations to navigate an increasingly complex and evolving healthcare landscape. Through innovative AI-enabled technologies and services, we deliver operational efficiency, interoperability, and simplicity. The company’s revenue cycle management, clinical workflow enablement, laboratory information system, and patient engagement solutions enable organizations to achieve stronger finances, streamline operations, and develop industry-leading business strategies.
Helping healthcare providers achieve financial strength empowers them to do more good for more people. That’s THE POWER TO DO GOOD.
What does the position pay:
Compensation is determined by several factors which may include skillset, experience level, and geographic location.
The expected range for this role is $33.65-$45.67 hourly compensation. Please note this range is an estimate and actual may vary based on qualifications and experience.
If you are an individual with a disability and would like to request a reasonable accommodation as part of the application or recruiting process, please contact us at 858-436-2901
EEO Statement
XiFin is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, gender, gender identity, sexual orientation, age, status as a protected veteran, among other things, or status as a qualified individual with disability.
