Umpqua Health · 1 month ago
Solutions Engineer (Data Solutions)
Umpqua Health is a mission-driven, community-focused healthcare organization proudly serving Douglas County, Oregon. 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.
Health CareHospitalTraining
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
Qualification
Required
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
Preferred
Experience considering the impacts of the work on multiple communities, including communities of color, in technical analysis
Experience with Tableau, Arcadia, and eClinicalWorks
Experience working on a diverse team with different communication styles
Bi-lingual translation or translation capabilities a plus
Company
Umpqua Health
Umpqua Health helps improve the health and well-being of the community by delivering easily accessible and quality healthcare.