Umpqua Health is a Coordinated Care Organization (CCO) in Roseburg, Oregon that connects over 30,000 Douglas County OHP members to physical, dental, and behavioral health services and benefits through an integrated network of providers. Umpqua Health is currently seeking a Senior Software Developer to join our team.

The Senior Software Developer will be a key contributor to the organization's health plan operations by leading the design, development, and implementation of software solutions that support the organization's goals and objectives. The ideal candidate will be a seasoned software developer with a strong understanding of healthcare data and systems, and a passion for delivering high-quality software solutions. This role will require a creative and forward-thinking mindset, as the successful candidate will be expected to develop innovative solutions that meet the needs of our organization. The individual in this position will work closely with other departments within the organization, including IT, decision support, quality, clinical operations, and finance, to ensure that the health plan systems are operating efficiently and effectively. Reporting directly to the Director, Software Development the Senior Software Developer performs a complete range of information system database analyst assignments including, but not limited to, designing, developing, testing, and implementing database systems. This individual will be looked upon to provide technical support to other team members and evaluate new database solutions and technologies. Provide maintenance, support, and assistance to the team with installation and configuration of clustered database failover, database replication, and database backup solutions.

ESSENTIAL JOB RESPONSIBILITIES

• Lead the design, development, and implementation of software solutions that support the organization's health plan operations using your visionary skills to create innovative solutions that drive the organization forward, leveraging your expertise to guide the development process.
• Support various software platforms from a technical perspective including automation of reporting features.
• Collaborate with cross-functional teams to gather requirements and develop solutions to address operational and business needs.
• Develop and maintain software codebase, ensuring high-quality coding standards and practices that align with the organization's vision and strategy.
• Design and develop database schemas and data models to support software solutions.
• Ensure that software solutions meet security and compliance requirements, such as HIPAA and CMS regulations while still driving innovation and pushing boundaries.
• Conduct unit testing and quality assurance to ensure that software solutions are stable and error-free.
• Stay up to date with emerging technologies and best practices to ensure that software solutions are using the latest tools and solutions, bringing your visionary perspective to evaluate and integrate new technologies.
• Provide technical mentorship and guidance to junior developers on the team.
• Develop and communicate the organization's software development vision, inspiring team members to create solutions that align with the vision and drive the organization forward.

• Work with third party systems to automate validation and reporting into internal IT systems.
• Design backend services to calculate complex member outcomes.
• Efficiently produce SQL queries and C# code, often interfacing .NET with SQL Server.
• Interpret & implement published specifications as SQL and/or C# code.
• Provide detailed analysis, design, tuning, testing, implementation and documentation of the business intelligence system and data warehouse.
• Support various software platforms from a technical perspective including automation of reporting features.
• Maintains, analyzes, troubleshoots, and repair various MS SQL databases.
• Install and upgrade various software applications and database systems as required.
• Maintains a working knowledge of emerging database technologies.
• Documents work time into a helpdesk system.
• Write SQL scripts against third party applications Umpqua Health relies upon for custom validation and reporting purposes.
• Assist other departments to author and investigate various health checks for internal systems and build reporting tools.
• Work with Network Security staff to ensure optimization of database security.
• Automation of database system tasks to import and export data between systems.
• Performance optimization of database systems.
• Diagnose and troubleshoot database errors.
• Create data flow diagrams for data management systems.
• Manage SQL Server Scheduling Agent Jobs for enterprise databases.
• Maintain SQL Server database Disaster Recovery management processes.
• Receive customer feedback, model data, and Design databases from requirements.
• Identify product defects and track to their appropriate resolution.
• Automate repetitive manual processes.
• Analyze and validate reports between systems and isolate discrepancies when they occur.
• Establish and maintain effective relationships with clients and matrix support teams.
• When appropriate, work independently, organizing questions in a way that allows progress to continue without immediate feedback.
• Keep customers and team members informed and respond to customer requests in a timely manner.
• Actively contribute in team meetings and share information
• Maintain a high level of user access and network availability.
• Comply with organization’s internal policies and procedures, Code of Conduct, Compliance Plan, along with applicable Federal, State, and local regulations.
• Occasionally needs to be available to be on call support.

QUALIFICATIONS

Minimum Required:

• Bachelor’s degree in computer science, Information Systems, or related field. 6+ years of experience in software development, with a focus on health plan operations
• Required certifications: MCSE (or equivalent)
• Relational database administration and experience with Microsoft SQL Server database administration. Experience must be current and relevant.
• Microsoft Azure Database Administrator (or equivalent) or obtain within one year.
• No suspension/exclusion/debarment from participation in federal health care programs (eg. Medicare/Medicaid)
• Must be authorized to work in the United States; We are unable to offer sponsorships at this time

Preferred:

• Experience considering the impacts of the work on multiple communities, including communities of color, in technical analysis.
• Experience with SolarWinds, Forcepoint, Tableau, Arcadia, and eClinicalWorks
• Experience working on a diverse team
• Experience working with different communication styles
• Bi-lingual translation or translation capabilities a plus
• Familiar with a variety of the field’s concepts, practices, and procedures.
• Proven experience installing, maintaining, updating and troubleshooting databases.
• Experience with Windows Server and SQL databases.
• Experience with Agile development methodologies.
• Familiarity with healthcare data standards, such as HL7, HIPAA, and CMS regulations
• Extensive knowledge of database technology, networks and server operating systems and hardware.
• Strong analytical and problem-solving skills with the ability to analyze complex data sets and identify insights.
• Excellent communication and interpersonal skills with the ability to work collaboratively with cross-functional teams.
• Demonstrated ability to manage multiple projects and priorities in a fast-paced environment.

For more information or to apply visit our website at www.umpquahealthcareers.com