Solutions Engineer (Data Solutions)

Umpqua Health • Roseburg, OR

1d • Remote

About The Position

The Solutions Engineer 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. Additionally, the solutions engineer troubleshoots, and debugs software programs for databases, applications, tools, networks, and applications to create innovative technology through solid engineering practices. 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 engineer 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 to the Data Solutions Manager, the Solutions Engineer 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.

Requirements

• Bachelor’s degree in computer science, information systems, or related field. 10+ years of experience in software development or solutions engineering, with a focus on health plan solutions
• Extensive knowledge of database technology, networks and server operating systems and hardware.
• Strong background in web development with a background in JavaScript, Typescript, jQuery, Angular, ASP.net, and Node.js
• Familiarity with healthcare data regulations such as HIPAA and CMS regulations
• Solid understanding of RESTful APIs, HL7 standards, and healthcare interoperability.
• Proficiency in programming languages such as Java, Python, or C# for solution development and integration.
• Microsoft Azure Database Administrator (or equivalent) or obtain within one year.
• Experience with health plan management systems, data analytics tools, and cloud platforms
• Relational database administration and experience with Microsoft SQL Server database administration.
• Proven experience installing, maintaining, updating and troubleshooting databases.
• Experience with Windows Server and SQL databases.
• Experience with Agile development methodologies.
• 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.
• No suspension/exclusion/debarment from participation in federal health care programs (e.g. Medicare/Medicaid)
• Proficient computer skills, including MS Office suite.

Nice To Haves

• Experience considering the impacts of the work on multiple communities, including communities of color, in technical analysis.
• Experience with Tableau, Arcadia, and eClinicalWorks
• Experience considering the impacts of the work on multiple communities, including communities of color, in technical analysis.
• Experience working on a diverse team with different communication styles.
• Bi-lingual translation or translation capabilities a plus

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 full stack web applications with a focus on performance and usability best practices.
• Architect 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 and integration testing to verify quality and 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.
• 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.
• Author maintainable JavaScript and TypeScript libraries that interface with backend Web APIs supporting existing jQuery, AngularJS, and Agular based web applications.
• Interpret & implement published specifications as SQL and/or C# code.
• Provide detailed performance 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.
• Diagnoses 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.
• Other duties as assigned

Benefits

• Generous benefit packages including PTO, Health/Vision/Dental Insurance, 401k with a company match, gym membership reimbursement, tuition reimbursement, and more.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level