IS Database Developer III

Candidates hired for remote positions must reside in Oregon, Washington, Utah, Idaho, Arizona, Nevada, Texas, Montana, or Wisconsin.

Position Title: IS Database Developer III

Exemption Status: Exempt

Department: Business Intelligence

Title of Manager: IS Development Supervisor

Direct Reports: n/a

Requisition # 24224

Pay & Benefits: Pay & Benefits: Estimated hiring range $120,000 - $145,200 / year, 5% bonus target, full benefits. To learn more about our benefits, please visit

Posting Notes: Posting Notes: This is a fully remote position, but you must reside in one of the listed 9 states.

Job Summary

The IS Database Developer III is responsible for defining the direction of database and ETL development, as well as designing and developing effective solutions in support of business strategies. This role is essential toward maturing CareOregon's database and ETL development model. Responsibilities include standard database development or may include a focus on EDI-specific development. This position spends substantial time partnering with business leaders, architecting, and implementing IS priorities (plan, design, install, and maintain).

Essential Responsibilities

Database Development

• Lead the design and maintenance of custom databases and processes.
• Note for EDI-focused roles: lead the design and maintenance of custom EDI databases and processes.
• Provide database design expertise to the organization; lead small projects independently and participate and consult on other projects.
• Advise other IS teams on best practices of database design and development, including exploration and insights on cloud-based solutions.
• May serve as a resource to junior developers.

ETL Development

• Develop ETL processes for advanced to complex activities and provide escalation support for tickets.
• Develop advanced databases to meet application and web needs.
• Analyze business requirements; partner with leaders across the organization in order to research and recommend solutions which balance business need and risk mitigation.
• Develop and maintain appropriate technology documentation, including current design and operation.

Standards and Policy Administration

• Author and serve as subject matter expert to define requirements, standards and best practices for database and ETL development (as well as EDI software/development for EDI-focused roles).
• Monitor and continually review existing systems to ensure they are designed to comply with established standards and to empower business operations.

Vendor Coordination and Relations

• Conduct product and vendor research, and present recommendations to lead developer and/or management.
• Establish and manage effective relations with vendors and related equipment suppliers, including installation and repair of services.

Organizational Responsibilities

• Perform work in alignment with the organization's mission, vision, and values.
• Support the organization's commitment to equity, diversity, and inclusion by fostering a culture of open mindedness, cultural awareness, compassion, and respect for all individuals.
• Strive to meet annual business goals in support the organization's strategic goals.
• Adhere to the organization's policies, procedures, and other relevant compliance needs.
• Perform other duties as needed.

Required Knowledge, Skills and Abilities

• Advanced knowledge/skills with the following:
  
  
  
  • Microsoft SQL Server
  • ETL tools, such as SSIS or Informatica
  • Visual Studio
  • Unit and integration testing
  
  
  
  
• For data warehouse-focused roles: Strong knowledge/skills of the dimensional model required in lieu of knowledge/skill requirements above
• For EDI-focused roles: Ability to use Biztalk for Healthcare EDI transactions such as 834/835/837/270/271, etc. and ability to troubleshoot Biztalk issues, performance tuning and best practices for Biztalk
• For other roles: General knowledge of BizTalk is preferred
• Advanced abilities in troubleshooting system performance issues and root cause
• Strong communication skills, including listening, verbal, written, customer service, meeting facilitation, and presentations
• Ability to clearly articulate policies, instructions, goals, and objectives
• Able to convey appropriate level of detail effectively to all levels of the organization including non-technical staff
• Ability to author policies, document risks, and propose solutions to information technology management and senior leadership
• Possess a high degree of initiative and motivation
• Ability to effectively collaborate with coworkers, staff, leaders, and executives across all departments

Physical Skills and Abilities Required

Lifting/Carrying up to 10 Pounds Pushing/Pulling up to 0 Pounds Pinching/Retrieving Small Objects Crouching/Crawling Reaching Climbing Stairs Repetitive Finger/Wrist/Elbow/ Shoulder/Neck Movement

0 hours/day 0 hours/day 0 hours/day 0 hours/day 0 hours/day 0 hours/day More than 6 hours/day

Standing Walking Sitting Bending Seeing Reading Hearing Speaking Clearly

0 hours/day 0 hours/day 0 hours/day 0 hours/day More than 6 hours/day More than 6 hours/day 3-6 hours/day 3-6 hours/day

Cognitive and Other Skills and Abilities

Ability to focus on and comprehend information, learn new skills and abilities, assess a situation and seek or determine appropriate resolution, accept managerial direction and feedback, and tolerate and manage stress.

Education and/or Experience

Required:

• Minimum 5 years' experience in database and ETL development that includes most or all of the following:
  
  
  
  • Database development and maintenance
  • ETL development and maintenance
  • Systems analysis and design
  • Agile/Scrum methodology
  
  
  
  
• For data warehouse-focused roles: Minimum 5 years' experience developing ETL for loading a dimensional model using a combination of T-SQL and SSIS 2012, 2014, or 2016
• For EDI-focused roles: experience using Biztalk for Healthcare EDI transactions (e.g., 834/835/837/270/271, etc.) that includes troubleshooting Biztalk issues, performance tuning and best practices for Biztalk

Preferred:

• SQL experience
• SSIS experience
• Snowflake experience
• Experience w/ Database Development for Data Warehouse
• Additional experience in related technology support and/or operational positions

Working Conditions

• Environment: This position's primary responsibilities typically take place in the following environment(s) (check all that apply on a regular basis):

Inside/office Clinics/health facilities Member homes

Other_________________________________________

• Travel: This position may include occasional required or optional travel outside of the workplace, in which the employee's personal vehicle, local transit, or other means of transportation may be used.
• Equipment: General office equipment
• Hazards: n/a

LI-REMOTE

Candidates of color are strongly encouraged to apply. CareOregon is committed to building a linguistically and culturally diverse and inclusive work environment.

Veterans are strongly encouraged to apply.

We are an equal opportunity employer. CareOregon considers all candidates regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, genetic information, disability, or veteran status.

Visa sponsorship is not available at this time.