CareOregon
IS Database Developer II
CareOregon, Boise, Idaho, United States, 83708
Career Opportunities: IS Database Developer II (24565)
Requisition ID
24565
- Posted
09/09/2024
-
CareOregon
-
Full Time - Permanent
-
Portland
- Multi Location (9)
Job Description Print Preview
Candidates hired for remote positions must reside in Oregon, Washington, Utah, Idaho, Arizona, Nevada, Texas, Montana, or Wisconsin.Job TitleIS Database Developer IIExemption StatusExemptDepartmentInfrastructureManager TitleIS Development SupervisorDirect ReportsN/ARequisition #24565Pay & BenefitsEstimated hiring range $109,500 - $133,840 / year, 5% bonus target, Full benefits. www.careoregon.org/about-us/careersPosting NotesThis is a remote role, but you must reside in one of the listed 9 states.Job SummaryThe IS Database Developer II is responsible for developing and maintaining database and ETL processes, as well as recommending and partnering in the design and development of effective solutions in support of business strategies. This role is essential toward maturing CareOregon's database and ETL development model. This position spends substantial time evaluating, architecting, and implementing IS priorities (plan, design, install, and maintain).Essential ResponsibilitiesDatabase DevelopmentActively 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.
ETL DevelopmentDevelop 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.
Standards and Policy AdministrationPropose 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.
Vendor Coordination and RelationsConduct 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.
Essential Department and Organizational FunctionsPropose and implement process improvements.Meet deadlines for completion of job tasks.Maintain agreed upon work schedule.Demonstrate cooperation and teamwork.Provide cross-training on specific job responsibilities.Meet identified business goals that contribute to departmental goals.Perform other related duties as needed.
Required Knowledge, Skills, and AbilitiesWorking knowledge/skills with the following:Microsoft SQL ServerETL tools, such as SSIS or InformaticaVisual StudioUnit and integration testing
Note: For data warehouse focused roles, advanced knowledge/skills of the dimensional model required in lieu of knowledge/skill requirements aboveGeneral knowledge of BizTalk (preferred)
Advanced abilities in troubleshooting system performance issues and root causeEffective communication skills, including listening, verbal, written, and customer serviceAbility to clearly articulate policies and instructionsDemonstrated progress in conveying appropriate level of detail effectively to all levels of the organization including non-technical staffAbility to recommend policies, document risks, and propose solutions to information technology management and senior leadershipPossess a high degree of initiative and motivationAbility to effectively collaborate with coworkers, staff, and leaders across all departments
Lifting/Carrying up to 10 PoundsPushing/Pulling up to 0 PoundsPinching/Retrieving Small ObjectsCrouching/CrawlingReachingClimbing StairsRepetitive Finger/Wrist/Elbow/Shoulder/Neck Movement0 hours/day0 hours/day0 hours/day0 hours/day0 hours/day0 hours/dayMore than 6 hours/dayStandingWalkingSittingBendingSeeingReadingHearingSpeaking Clearly0 hours/day0 hours/day0 hours/day0 hours/dayMore than 6 hours/dayMore than 6 hours/day3-6 hours/day3-6 hours/dayCognitive and Other Skills and AbilitiesAbility 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 ExperienceRequired:Minimum 3 years of database and ETL development required. Experience should include some or all of the following:Database development and maintenanceETL development and maintenanceSystems analysis and designAgile/Scrum methodology
Note: 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 2016Preferred:QNXT experienceHealthcare experienceBachelor's degree in Computer Science, Information Systems, or a related field preferredAdditional experience in related technology support and/or operational positions preferred
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 homesOther_________________________________________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 equipmentHazards: n/a
#MULTICandidates 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.Email this job to a friend
The job has been sent to
Please provide the information below
Job title:
*Your friend's email address:
Message:Maximum character limit: 1000
*Confirm you are not a robot:
Requisition ID
24565
- Posted
09/09/2024
-
CareOregon
-
Full Time - Permanent
-
Portland
- Multi Location (9)
Job Description Print Preview
Candidates hired for remote positions must reside in Oregon, Washington, Utah, Idaho, Arizona, Nevada, Texas, Montana, or Wisconsin.Job TitleIS Database Developer IIExemption StatusExemptDepartmentInfrastructureManager TitleIS Development SupervisorDirect ReportsN/ARequisition #24565Pay & BenefitsEstimated hiring range $109,500 - $133,840 / year, 5% bonus target, Full benefits. www.careoregon.org/about-us/careersPosting NotesThis is a remote role, but you must reside in one of the listed 9 states.Job SummaryThe IS Database Developer II is responsible for developing and maintaining database and ETL processes, as well as recommending and partnering in the design and development of effective solutions in support of business strategies. This role is essential toward maturing CareOregon's database and ETL development model. This position spends substantial time evaluating, architecting, and implementing IS priorities (plan, design, install, and maintain).Essential ResponsibilitiesDatabase DevelopmentActively 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.
ETL DevelopmentDevelop 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.
Standards and Policy AdministrationPropose 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.
Vendor Coordination and RelationsConduct 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.
Essential Department and Organizational FunctionsPropose and implement process improvements.Meet deadlines for completion of job tasks.Maintain agreed upon work schedule.Demonstrate cooperation and teamwork.Provide cross-training on specific job responsibilities.Meet identified business goals that contribute to departmental goals.Perform other related duties as needed.
Required Knowledge, Skills, and AbilitiesWorking knowledge/skills with the following:Microsoft SQL ServerETL tools, such as SSIS or InformaticaVisual StudioUnit and integration testing
Note: For data warehouse focused roles, advanced knowledge/skills of the dimensional model required in lieu of knowledge/skill requirements aboveGeneral knowledge of BizTalk (preferred)
Advanced abilities in troubleshooting system performance issues and root causeEffective communication skills, including listening, verbal, written, and customer serviceAbility to clearly articulate policies and instructionsDemonstrated progress in conveying appropriate level of detail effectively to all levels of the organization including non-technical staffAbility to recommend policies, document risks, and propose solutions to information technology management and senior leadershipPossess a high degree of initiative and motivationAbility to effectively collaborate with coworkers, staff, and leaders across all departments
Lifting/Carrying up to 10 PoundsPushing/Pulling up to 0 PoundsPinching/Retrieving Small ObjectsCrouching/CrawlingReachingClimbing StairsRepetitive Finger/Wrist/Elbow/Shoulder/Neck Movement0 hours/day0 hours/day0 hours/day0 hours/day0 hours/day0 hours/dayMore than 6 hours/dayStandingWalkingSittingBendingSeeingReadingHearingSpeaking Clearly0 hours/day0 hours/day0 hours/day0 hours/dayMore than 6 hours/dayMore than 6 hours/day3-6 hours/day3-6 hours/dayCognitive and Other Skills and AbilitiesAbility 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 ExperienceRequired:Minimum 3 years of database and ETL development required. Experience should include some or all of the following:Database development and maintenanceETL development and maintenanceSystems analysis and designAgile/Scrum methodology
Note: 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 2016Preferred:QNXT experienceHealthcare experienceBachelor's degree in Computer Science, Information Systems, or a related field preferredAdditional experience in related technology support and/or operational positions preferred
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 homesOther_________________________________________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 equipmentHazards: n/a
#MULTICandidates 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.Email this job to a friend
The job has been sent to
Please provide the information below
Job title:
*Your friend's email address:
Message:Maximum character limit: 1000
*Confirm you are not a robot: