[Remote] IS Database Developer II

Note: The job is a remote job and is open to candidates in USA. CareOregon is seeking an IS Database Developer II to develop and maintain database and ETL processes. This role is essential for maturing CareOregon’s database and ETL development model by evaluating, architecting, and implementing IS priorities. Responsibilities • Actively participate in the design of custom databases and processes • Provide advanced database design support to the organization; lead small projects with assistance from Supervisor or Lead and participate and consult on other projects • Collaborate with other IS teams on best practices of database design and development • Develop ETL processes for moderate to advanced activities • Develop moderate to advanced databases to meet application and web needs • Analyze business requirements; research and recommend solutions which include potential risks and mitigation • Develop and maintain appropriate technology documentation, including current design and operation • Propose requirements, standards and best practices for database and ETL development • Participate in the ongoing review of existing systems to ensure they are designed to comply with established standards and to empower business operations • Conduct product and vendor research, and present recommendations to more advanced database developers and/or management • Establish and maintain effective working relationships with vendors and related equipment suppliers, including installation and repair of services • 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 of the organization’s strategic goals • Adhere to the organization’s policies, procedures and other relevant compliance needs • Perform other duties as needed Skills • Minimum 3 years of database and ETL development required. Experience should include some 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 3 years' experience developing ETL for loading a dimensional model using a combination of T-SQL and SSIS 2012, 2014, or 2016 • Working 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, advanced knowledge/skills of the dimensional model required in lieu of knowledge/skill requirements above • Advanced abilities in troubleshooting system performance issues and root cause • Effective communication skills, including listening, verbal, written, and customer service • Ability to clearly articulate policies and instructions • Demonstrated progress in conveying appropriate level of detail effectively to all levels of the organization including non-technical staff • Ability to recommend 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, and leaders across all departments • Ability to work effectively with diverse individuals and groups • Ability to learn, focus, understand, and evaluate information and determine appropriate actions • Ability to accept direction and feedback, as well as tolerate and manage stress • Ability to see, read, and perform repetitive finger and wrist movement for at least 6 hours/day • Ability to hear and speak clearly for at least 3-6 hours/day • Bachelor's degree in Computer Science, Information Systems, or a related field • Additional experience in related technology support and/or operational positions Benefits • Medical • Dental • Vision • Life • AD&D • Disability insurance • Health savings account • Flexible spending account(s) • Lifestyle spending account • Employee assistance program • Wellness program • Discounts • Multiple supplemental benefits (e.g., voluntary life, critical illness, accident, hospital indemnity, identity theft protection, pre-tax parking, pet insurance, 529 College Savings, etc.) • Strong retirement plan with employer contributions • PTO • Paid State Sick Time • Paid holidays • Volunteer time • Jury duty • Bereavement leave Company Overview • Everyone deserves great health care. It was founded in 1994, and is headquartered in Portland, Oregon, USA, with a workforce of 501-1000 employees. Its website is Company H1B Sponsorship • CareOregon has a track record of offering H1B sponsorships, with 1 in 2025, 10 in 2024, 3 in 2023, 6 in 2022, 3 in 2021, 2 in 2020. Please note that this does not guarantee sponsorship for this specific role. Apply tot his job