You are viewing a preview of this job. Log in or register to view more details about this job.

Data Warehouse Developer

Clackamas County

Job ID: 107122

Location: Oregon City, Oregon

Full/Part Time: Full Time

Regular/Temporary:Regular

CLACKAMAS COUNTY CORE VALUES

Clackamas County employees work to serve the public and enrich our community. In that spirit, we pledge to hold ourselves to these standards at all times in our interactions with customers and one another:

• Service
• Professionalism
• Integrity
• Respect
• Individual accountability
• Trust

By incorporating these values into our daily routines, we can better serve our customers, ourselves and our projects. We're always looking to improve. That's the Clackamas County SPIRIT. https://www.clackamas.us/countyadmin/spirit

Clackamas County is committed to building a community where people thrive, have a sense of safety, connection, and belonging, so that everyone is honored and celebrated for the richness in diversity they bring. We encourage applicants of diverse backgrounds and lived experience to apply.

WHO MAY APPLY

Clackamas County does not offer visa sponsorships. Once a job applicant has accepted a position, they will be required to complete an I-9 and confirm authorization to work in the United States prior to their first day.

CLOSE DATE

This position will remain open until filled. The first application review will be Monday, October 9, 2023. We reserve the right to close this recruitment at any time on or after that date.

PAY AND BENEFITS

Annual Pay Range: $96,124.29 - $121,907.79

Hourly Pay Range: $46.213599 - $58.609516

Salary offers will be made within the posted pay range and will be based on a candidate's experience (paid or unpaid) that is directly relevant to the position. This position is classified as a Systems Project Analyst, Senior.

Clackamas County proudly offers an attractive compensation and benefits package, including competitive wages, cost-of-living adjustments, merit increases (for eligible employees), and a robust sick and vacation plan for regular status employees.

We encourage and support employee health and wellness by offering, health and wellness classes and events, and alternative care benefits, so you can customize your wellness needs to fit your lifestyle.

Employee benefits become effective the first of the month following an employee's date of hire.

Attractive benefits package and incentives for employees in regular status positions are detailed below.

Generous paid time off package, including:

• 12 hours of vacation accrued per month

• Eligible newly hired employees will have the one-time option to frontload their first year of vacation accruals in compliance with https://dochub.clackamas.us/documents/drupal/a51ff5d3-d243-49ba-aa11-15324f4c0bf8! This means you have access to vacation time at time of hire.

• 8 hours of sick accrued per month
• 10 paid holidays and 1 personal day per year

Other Benefits:

• Membership in the Public Employees Retirement System (PERS)/Oregon Public Service Retirement Plan (OPSRP):
• Employer paid 6% PERS retirement contribution (The county currently pays the employee's share of the retirement contribution.)
• OPSRP members get vested after five years of contributions or when they reach age 65

• A Choice of Medical Plans that include chiropractic coverage, alternative care, vision, and prescription drug coverage
• A Choice of Dental Plans
• Robust EAP and wellness programs, including gym discounts and wellness education classes
• Longevity pay
• Other retirement Savings Options that allow for additional retirement funds savings, including an option to contribute a portion of employee earnings on a pre or post-tax basis to a 457b Deferred Compensation Plan
• A variety of additional optional benefits (see links below for additional information)

This is a full time County position represented by the Employees' Association.

https://dochub.clackamas.us/documents/drupal/1e311321-f9ff-4daa-8753-bbdfb4e8d1b4

http://www.clackamas.us/des/benefits.html

JOB DETAILS AND QUALIFICATIONS

Clackamas County's Department of Technology Services (TS) is seeking a dedicated and experienced Data Warehouse Developer to play a pivotal role in building a robust data warehouse system and custom solutions to provide insights that improve operational efficiency.

As a part of our team, the ideal candidate will collaborate with consultants, vendors, and internal departments to streamline reporting, improve data accessibility, and contribute to overall healthcare excellence. This position will lead the design and implementation of a data warehouse system that extracts, transforms, and loads data from County's electronic health record system for streamlined reporting. The selected candidate will assign tasks to the internal support teams and collaborate closely with TS applications team to build and maintain the database effectively. Working closely with the Clackamas County Health Centers' Quality Improvement team, the Data Warehouse Developer will identify business requirements and build data extraction and reporting applications that align with regulatory and strategic funding compliance.

Key responsibilities of this role include:

• Leading complex projects, developing policies and guidelines, and providing advanced technical expertise in data warehouse development, design and architecture;
• Implement and maintain security measures to protect sensitive data, and manage user access to the data warehouse.
• Create and optimize complex ETL workflows to ensure data accuracy, completeness, and reliability.
• Develop and maintain scripts, queries, and routines for data cleansing, transformation, and loading.
• Consulting with various departments to determine business requirements and to design, build, and maintain reports and data extracts for clinic monitoring, internal reporting, and regulatory compliance;
• Collaborate with external entities (e.g., CareOregon, Crossroads, PreManage) to determine tools, design, and build system components to extract, process and integrate data from multiple sources, ensuring automated processing where possible;
• Utilizing software tools for systems analysis, logic design, applications programming, database management, troubleshooting, and ensuring operational integrity;
• Managing contracted relationships with OCHIN's Professional Services Group for report development, coordinating requirements, validation, and results verification;
• Providing technical leadership for Health Centers projects, including system design, building, testing, and implementation of various components; and
• Develop, support, and maintain data extraction and transmission tools to external entities for grants, security, and business needs.

Required Minimum Qualifications/ Transferrable Skills:*

• A minimum of seven (7) years of experience in data warehouse development, ETL processes, and database design.
• Demonstrated proficiency in ETL tools and languages such as SQL or other scripting languages.
• Demonstrated knowledge of database management principles and techniques (SQL coding, writing TSQL queries, data warehouse schema design)
• Strong project management and leadership skills
• Strong problem-solving abilities and analytical thinking
• Effective communication skills to collaborate with internal and external partners
• Must pass a criminal history check which may include national or state fingerprint records check
• Driving may be necessary for County business. For position(s) with occasional/incidental driving, incumbents must possess a valid driver's license. Accommodation requests for an acceptable alternative method of transportation will be reviewed on an individual basis in compliance with State and Federal legislation. For position(s) with regular driving, incumbent(s) must also possess and maintain an acceptable driving record throughout the course of employment. http://dochub.clackamas.us/documents/drupal/828106a0-265a-47cc-a3a6-0a2c8b028673

Preferred Special Qualifications/ Transferrable Skills:*

These are preferred but not required qualifications. No experience in any or all of the following will not necessarily disqualify you from consideration.

• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).
• Experience with data visualization and reporting tools (e.g., Tableau, Power BI)
• Experience working with EPIC or other EHR systems
• Demonstrated proficiency in programming languages such as C# or other .NET development languages
• Knowledge of healthcare regulations and compliance

*For Veterans qualified for Veteran's Preference: If you believe you have skills that would transfer well to this position and/or special qualifications that relate to this position, please list those skills and/or qualifications in the open-ended question at the end of the application and explain how those skills and/or qualifications relate to this position.

TYPICAL TASKS

Duties may include but are not limited to the following:

• Consult with personnel across various departments; e.g. QI, Financial, health care clinic management, to determine business requirements, then analyze, design, build, and maintain reports and data extracts needed for the monitoring and operation of the health care clinics as well as reporting to various internal departments and regulatory bodies.
• Work with OCHIN EPIC and Clackamas Network personnel to implement a facility to automatically run reports in EPIC and deliver the output to a Clackamas file share for consumption by Health Centers leadership and staff.
• Work with outside entities, e.g. CareOregon, Crossroads, PreManage, determine the tools to be used, design, and build the multiple components of the system to extract/ import data from multiple sources, perform complex processing, and produce the required output. Where possible, the system retrieves/ sends the input/output data electronically on a scheduled basis without manual intervention.
• Utilize appropriate software tools and techniques for systems analysis, logic design, applications programming and coding, data base management, computer operations, troubleshooting equipment problems, and maintaining operational integrity of the computer system. Determine business requirements, design, build, document, and maintain C# application and MS-SOL database, to extract, transform, and load data from enterprise applications.
• Participate in meetings, forums, webinars, etc. with internal departments and outside entities to advise on the impacts of upcoming changes and identify opportunities for improvement and efficiencies.
• Manage the contracted relationship with OCHIN's Professional Services Group to build business objects reports for Health Centers. Develop the business requirements, coordinate between end users and OCHIN developers, and validate the results.
• Provide technical leadership and expertise to Health Centers projects in determining technology needs, purchasing or building systems to meet those needs. Overall systems design, building, testing, and implementing the various components.
• Develop support and maintain tools to extract and import data from multiple sources, then process and transmit data for Health Center to outside entities for grants, security, and other business needs (OHA, SAM/OIG exclusion screening, 340B partners, UDS, etc.).
• Develop detailed design specifications, definitions, flow charts, diagrams, performance criteria, and testing methods; writes; develops, and documents operational procedures for data elements and sources; coordinates systems maintenance, testing, and production runs; devises schedules for implementation; provides training and technical guidance to users and staff in the use of new or modified systems and procedures.

REQUIRED KNOWLEDGE AND SKILLS

Thorough knowledge of: Principles and practices of applications programming, data communications and systems analysis and design; computer hardware and systems software in supporting application systems; data base management principles and techniques; techniques of supervision and project management; business systems design and analysis; Systems and Database administration including server and workstation hardware, operating systems, security protocols and best practices, web services, database design and related support services.

Working knowledge of: Basic principles and techniques cost/benefit analysis, research methods and report preparation. Network administration including internet services, security protocols, network design and performance tuning.

Skill to: Communicate effectively both orally and in writing; convey technical and complex information to users, technical staff and management; design and analyze advanced systems; collect, analyze, evaluate, and prepare recommendations regarding system design and
performance, user needs and requirements; establish controls and security measures; develop and manage projects within established timelines and budget requirements; plan and coordinate assigned staff to achieve project requirements and objectives; establish and maintain effective working relationships with system users, vendors, co-workers, other County personnel and outside agencies.

WORK SCHEDULE

This position is included in the County's alternate workweek program, working 40 hours during a standard workweek of Monday through Thursday (Fridays off). Specific hours of work will be discussed with the candidate selected for this position at the time an offer of employment is extended. This position is eligible for hybrid on-site/telework subject to the https://dochub.clackamas.us/documents/drupal/9065b5fb-2237-47ce-9534-e7c8c40fc2bc and based on the Department's business needs. The exact amount of on-site/telework and schedule will be discussed with the hiring manager during time of offer. Telework locations cannot be located outside of Oregon or Washington. Washington residents must perform 50% of their time on-site at Clackamas County.

EXPLORE CLACKAMAS COUNTY

Clackamas County is in a prime location in the Portland, Oregon metropolitan area and is recognized nationally as one of the most livable areas in the United States. Located on the southern edge of the City of Portland and extending to the top of Mt. Hood, Clackamas County is part of a thriving region in the Northwest. It has a population of about 420,000 residents.

• http://www.clackamas.us/
• http://www.clackamas.us/onboarding/
• https://www.mthoodterritory.com/
• http://www.clackamas.us/diversity/

ABOUT THE DEPARTMENT

While it is not possible to know with certainty all of the challenges that the future will bring, one assumption seems certain; today's practices will not be adequate to meet tomorrows needs.

Along with this, we know that technology is constantly changing. Therefore as Clackamas County is committed to providing high quality public service, we must continually strive to improve. We can accomplish this by providing the necessary on-going training; improve and upgrade our computer systems, both software and hardware, whenever feasible; and implement county-wide technical standards to ensure compliance. The Technology Services staff is committed to meeting these goals and look forward to the challenges and opportunities of the future.

The mission of the Technology Services Department is to provide high quality, cost-effective technology for, citizens, county departments, and county commissioners.

http://www.clackamas.us/ts/

APPLICATION PROCESS

Clackamas County only accepts online applications.

Help With Your Application:

• https://dochub.clackamas.us/documents/drupal/6b3147a3-bf84-4f52-8238-64a37e936b4f
• https://www.clackamas.us/jobs#helpwiththeapplication

If you have any questions or issues you may contact the Department of Human Resources at 503-655-8459 or mailto:jobs@co.clackamas.or.us?subject=Application%20Materials%20Question. Our office hours are Monday - Thursday 7:00 a.m. - 6:00 p.m. Pacific Time (closed on Fridays).

HOW TO CLAIM VETERAN'S PREFERENCE

• https://www.clackamas.us/des/jobs.html
• https://dochub.clackamas.us/documents/drupal/a67ee11c-861c-4126-aa5a-4dec6174f6eb

VISA SPONSORSHIP

EQUAL EMPLOYMENT OPPORTUNITY

Clackamas County is an Equal Opportunity Employer. We value diversity, equity, and inclusion as essential elements that create and foster a welcoming workplace. All qualified persons will be considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, political affiliation, disability or any other factor unrelated to the essential functions of the job.

If you wish to identify yourself as a qualified person with a disability under the Americans with Disabilities Act and would like to request an accommodation, please address the request to the Department of Human Resources prior to the recruitment close date. You may request an accommodation during the online application process.

RECRUITING QUESTIONS?

James Callahan, Recruiter
mailto:JCallahan@clackamas.us?subject=RECRUITMENT%20QUESTIONS

To apply, visit https://apptrkr.com/4608772

https://www.jobelephant.com/

jeid-a06757547f583241b7b11aa2f5890b4e