IS Database Developer III - EDI Specialist

Career Opportunities: IS Database Developer III - EDI Specialist (18287) Requisition ID 18287 - Posted 10/13/2021 - CareOregon - Full Time - Permanent - Portland

To protect the health and well-being of our members, employees and community, CareOregon requires all employees to be fully vaccinated against COVID-19 or have an approved medical or religious exception as a qualification of employment.

Candidates who receive an offer of employment by CareOregon, must provide proof of COVID-19 vaccination or submit a medical or religious exception request, which will be evaluated in accordance with CareOregon's standard accommodation process.

Position Title: IS Database Developer III

Department: Business Intelligence

Title of Manager: IS Development Supervisor

Supervises: Non-supervisory position

Exemption Status: Exempt

Requisition: 18287

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:

  • 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

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.

Equal opportunity employer. This company considers all candidates regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.


Email this job to a friend The job has been sent to





Job title: *Your email address: *Your friend's email address: Message: Maximum character limit: 1000
*Confirm you are not a robot:

Category

Computer Programmers


Experience

5 to 20+ years


Job type

Full time

Company
CareOregon
Posted
10/02/2021
Salary Range
$76,000.00 - 105,000.00
per Year
Salary range estimated by
Location
Happy Valley, OR 97086, US
Apply Now