Address
Form of workSalary: $34.67 - $46.32 Hourly
Location : Eugene, OR
Job Type: Regular
Job Number: 202400137
Department: Technology Services
Division: Office of Data & Analytics
Opening Date: 03/22/2024
Closing Date: 4/8/2024 11:59 PM Pacific
FLSA: Exempt
DESCRIPTION
About the Position
Lane County is seeking a Programmer Analyst II to directly support the Public Works department in leveraging complex organizational data to enhancing key performance indicators and driving business process improvements. This role requires expertise in data engineering, encompassing extraction, transformation, loading, integration, and consolidation of structured and unstructured data systems to build analytics solutions. Reporting to the Office of Data & Analytics, the Programmer Analyst II collaborates closely with analysts to support data access for dashboard development and KPIs for with Public Works divisions including Engineering and Construction Services, Land Management, Parks, and Road Maintenance.
Responsibilities:
About the Department
Mission Statement: Solutions, Service, Value
Lane County Technology Services is a regional leader in delivering innovation and infrastructure to our customers and partners that maximizes the value from every technology dollar spent. In addition to serving internal customer needs, for over 50 years Lane County has hosted Regional Information Services as well serving local cities and other partners with shared datacenter, networking and application services. We are dedicated to helping our customers meet their business needs through excellent customer service and integrated solutions.
Technology Services Environment:
Schedule: Monday - Friday 7:00 am - 4:00 pm or 8:00 am - 5:00 pm.
*This is an AFSCME represented position*
QUALIFICATIONS
Training:
Experience:
An equivalent combination of experience and training that will demonstrate the required knowledge and abilities is qualifying. An example would be 6 years of programming experience that demonstrates an increasing level of software systems expertise.
Special Requirements:
Ideal candidate will have the following skills & experience:
Notes:
As a condition of employment, these positions require a criminal background investigation and a security clearance as required by State or Federal regulatory requirements.
Studies have shown that women and BIPOC individuals are less likely to apply for jobs unless they believe they are able to perform every task in the job description. We are most interested in finding the best candidate for the job, and that candidate may be one who comes from a less traditional background. The county will consider any equivalent combination of knowledge, skills, education, and experience to meet minimum qualifications. If you are interested in applying, we encourage you to think broadly about your background and skill set for the role.
CLASSIFICATION DETAILS
Programmer Analyst 2 Classification Details
Selection Process
SUPPLEMENTAL INFORMATION
Equal Employment Opportunity
Lane 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.
Strategic Plan
In alignment with Lane County's Strategic Plan, incumbent(s) will be expected to demonstrate the following core behaviors: Passion to Serve, Driven to Connect, and Focused on Solutions.
The 2022 -2024 Strategic Plan focuses on the areas that Lane County will pursue as a way to deliver on our vision for the residents of Lane County. To meet these challenges, we know that the basis of our efforts lies in leveraging our people and partnerships to achieve our Strategic Priorities. We also recognize that the quality and commitment of our staff is essential to a shared future where Lane County is the best place in which to live, work, and play.
Veteran Preference Information
Careers with Lane County Offer Extraordinary Benefits
At Lane County, we value our employees and we show it with our extraordinary benefits. We know that you chose public service for more than a paycheck, and our outstanding benefits are designed to help you Live Well, Live Lane - throughout your career. Read on to learn what great benefits await you in a career with Lane County.
Introducing , Lane County's benefit advisor! ALEX is an interactive tool that will help you understand the benefits being offered, out of pocket expenses and coverage available. You will need the Collective Bargaining Unit found in your job posting and when asked for your date of hire, please put in today's date.
*The below information describes typical benefits available for Regular Full-time Employees. Actual benefits received may differ by position, employment status (regular, temporary, or extra help) and/or bargaining group.
Collective Bargaining Units:
Admin-Pro
AFSCME
AFSCME Nurses
AFSCME Physicians
FOPPO
LCPOA
Local 626
Prosecuting Attorney's
Benefits to keep you & your family well - Physically
Health insurance coverage becomes effective the first of the month following your first 30 days as an eligible employee.
Medical/Rx/Vision - Lane County offers medical, prescription and vision exam coverage for you and your eligible dependents. The plan options and costs per month for 2018 are outlined below:
If you enroll in the HDHP the County will contribute to your HSA: $1,500 (individual) or $3,000 (family) annually. This amount is prorated based on date of hire.
Eligible employees who complete a Health History Risk Assessment (HHRA), Biometric Screening, and Comprehensive Health Review (CHR) at the Live Well Center receive a $20 per month credit.
Wellness Clinic - The Live Well Center is for Lane County benefits-eligible employees, spouses and dependents (ages 2 and up) who are enrolled in the Lane County health plan. Marathon Health manages the Live Well Center and their clinical team provides confidential, affordable care for your acute and preventive healthcare needs. The Live Well Center also provides health coaching, chronic disease counseling, comprehensive primary care services, and much more.
Dental - Lane County provides dental coverage for employees and their eligible dependents.
Employee Assistance Program (EAP) - Lane County provides this counseling and concierge service to employees and members of their immediate households.
Fitness Center Membership - Lane County provides employees with a free membership to a local fitness center. Employees may add their families at a discounted rate.
Benefits to keep you & your family well - Financially
Retirement - Lane County pays for, and enrolls employees in the Oregon Public Service Retirement Plan (OPSRP) and the Individual Account Program (IAP) following six full months of employment. (Current members are eligible upon hire.)
Disability - Lane County pays a portion of wages for eligible employees through Short-Term Disability, and provides Long-Term Disability coverage. Lane County complies with all State and Federal disability laws for employee, family, parental and pregnancy leaves regulations.
Time Management - Lane County provides employees with a generous bank of hours to be used for sick, vacation, family emergencies and personal days.
Holidays - Lane County provides 10 paid holidays per year:
New Year's Day Independence Day
Martin Luther King Jr's Birthday Labor Day
Presidents' Day Veterans' Day
Memorial Day Thanksgiving Day
Juneteenth Christmas Day
Life Insurance - Lane County pays for employee group term life insurance.
County-paid Training & Development to keep your career well
On-site Classes - Lane County offers a variety of on-site classes to develop employees' soft and technical skills.
Online Training - Lane County offers a variety of online classes through LEAP to help employees continually improve their skills.
Conferences & Seminars - Lane County will consider reimbursement for employees to attend professional conferences, dependent upon budget, to encourage continuous learning and professional development.
Lane County offers these other valuable benefits
Deferred Compensation Retirement Savings - Employees may enroll in a deferred compensation program 457(b) to save for retirement.
Vision - Eligible employees may purchase supplemental vision insurance.
Supplemental Life Insurance - Employees may purchase supplemental life insurance for themselves and their dependents/spouse.
Aflac - Optional employee-paid voluntary group coverage is available through Aflac.
Group Discounts - Group discounts may include homeowners and auto insurance, pet health insurance, credit union membership.
Paid medical, dental and vision coverage for dependents is determined by labor agreement or APM, as applicable. Physicians should contact their supervisor for health plan options and rates. Please note that Temporary and Extra Help positions are not typically eligible for benefits. This is only brief summary of benefits available to eligible Lane County employees. In all cases, plan documents govern.
For additional information about these extraordinary benefits contact the Benefit Resource Center at 1-866-468-7272, or Lane County HR at (541) 682-3124.
01
IMPORTANT: Please ensure you have included all RELEVANT education, employment and experience in your application. To ensure compliance with Oregon Equal Pay laws, Human Resources will conduct a wage analysis based on the information you have provided in your application to determine the appropriate starting wage if you are selected.
02
What is your highest level of education?
03
How many years of programming experience do you have that demonstrates an increasing level of software systems expertise?
04
Lane County staff are required to demonstrate competency in three areas: Passion to Serve, Driven to Connect and Focused on Solutions. Please tell us how these three traits apply to you and the work you have done in the past. (34 pts.)
05
How have you worked with data scientists and analysts to ensure that data is accurate and accessible? (33 pts.)
06
What do you think are the most important qualities for a data engineer to possess, and how do you embody these qualities in your work? (33 pts.)
Required Question
Location : Eugene, OR
Job Type: Regular
Job Number: 202400137
Department: Technology Services
Division: Office of Data & Analytics
Opening Date: 03/22/2024
Closing Date: 4/8/2024 11:59 PM Pacific
FLSA: Exempt
DESCRIPTION
About the Position
Lane County is seeking a Programmer Analyst II to directly support the Public Works department in leveraging complex organizational data to enhancing key performance indicators and driving business process improvements. This role requires expertise in data engineering, encompassing extraction, transformation, loading, integration, and consolidation of structured and unstructured data systems to build analytics solutions. Reporting to the Office of Data & Analytics, the Programmer Analyst II collaborates closely with analysts to support data access for dashboard development and KPIs for with Public Works divisions including Engineering and Construction Services, Land Management, Parks, and Road Maintenance.
Responsibilities:
- Work with stakeholders to identify data needs and develop solutions to meet functional and non-functional business requirements.
- Design and implement data pipelines for optimal extraction, transformation, and loading of data from a wide variety of data sources using Microsoft SQL Server, .NET, Power BI, Dataflows, Azure and other technologies.
- Work with stakeholders and data stewards on data-related technical issues and ensure data is accurate, consistent, and accessible.
- Develop and maintain data models and database schemas to ensure efficient data storage and retrieval.
- Build and support data cleansing, enrichment and quality improvements.
- Develop and maintain documentation for data infrastructure and processes.
- Effectively communicate with stakeholders of varying levels and technical abilities
- Other duties and projects as assigned.
About the Department
Mission Statement: Solutions, Service, Value
Lane County Technology Services is a regional leader in delivering innovation and infrastructure to our customers and partners that maximizes the value from every technology dollar spent. In addition to serving internal customer needs, for over 50 years Lane County has hosted Regional Information Services as well serving local cities and other partners with shared datacenter, networking and application services. We are dedicated to helping our customers meet their business needs through excellent customer service and integrated solutions.
Technology Services Environment:
- Fun, innovative, and collaborative culture
- New, state-of-the-art regional data center with over 200 virtual and physical servers
- Microsoft, ESRI, and PeopleSoft platforms
- Mobile and virtual first strategies
- Support and integrate with vendor and cloud products
- Build custom applications and integrated solutions
- A strong emphasis on work-life balance
- Limited overtime and travel requirements
- Career development and growth opportunities
- Technical training and mentoring
- Fitness center membership
- Competitive retirement and medical benefits
- Wellness Clinic and Programs
Schedule: Monday - Friday 7:00 am - 4:00 pm or 8:00 am - 5:00 pm.
*This is an AFSCME represented position*
QUALIFICATIONS
Training:
- Equivalent to a Bachelor's degree from an accredited college or university with major coursework in computer science or a related field.
Experience:
- Two years of programming experience that demonstrates an increasing level of software systems expertise.
An equivalent combination of experience and training that will demonstrate the required knowledge and abilities is qualifying. An example would be 6 years of programming experience that demonstrates an increasing level of software systems expertise.
Special Requirements:
Ideal candidate will have the following skills & experience:
- Experience in data engineering, with a focus on writing and maintaining ETL/ELT code, building data pipelines, and data warehouses.
- Proficiency in Python or another scripting language.
- Strong understanding of relational databases with advanced working knowledge and programing proficiency in SQL. Experience working with SQL and NoSQL databases, such as PostgreSQL, MySQL, MongoDB, or Cassandra.
- Experience with cloud-based data storage and processing platforms such as Microsoft Azure.
Notes:
As a condition of employment, these positions require a criminal background investigation and a security clearance as required by State or Federal regulatory requirements.
Studies have shown that women and BIPOC individuals are less likely to apply for jobs unless they believe they are able to perform every task in the job description. We are most interested in finding the best candidate for the job, and that candidate may be one who comes from a less traditional background. The county will consider any equivalent combination of knowledge, skills, education, and experience to meet minimum qualifications. If you are interested in applying, we encourage you to think broadly about your background and skill set for the role.
CLASSIFICATION DETAILS
Programmer Analyst 2 Classification Details
Selection Process
SUPPLEMENTAL INFORMATION
Equal Employment Opportunity
Lane 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.
Strategic Plan
In alignment with Lane County's Strategic Plan, incumbent(s) will be expected to demonstrate the following core behaviors: Passion to Serve, Driven to Connect, and Focused on Solutions.
The 2022 -2024 Strategic Plan focuses on the areas that Lane County will pursue as a way to deliver on our vision for the residents of Lane County. To meet these challenges, we know that the basis of our efforts lies in leveraging our people and partnerships to achieve our Strategic Priorities. We also recognize that the quality and commitment of our staff is essential to a shared future where Lane County is the best place in which to live, work, and play.
Veteran Preference Information
Careers with Lane County Offer Extraordinary Benefits
At Lane County, we value our employees and we show it with our extraordinary benefits. We know that you chose public service for more than a paycheck, and our outstanding benefits are designed to help you Live Well, Live Lane - throughout your career. Read on to learn what great benefits await you in a career with Lane County.
Introducing , Lane County's benefit advisor! ALEX is an interactive tool that will help you understand the benefits being offered, out of pocket expenses and coverage available. You will need the Collective Bargaining Unit found in your job posting and when asked for your date of hire, please put in today's date.
*The below information describes typical benefits available for Regular Full-time Employees. Actual benefits received may differ by position, employment status (regular, temporary, or extra help) and/or bargaining group.
Collective Bargaining Units:
Admin-Pro
AFSCME
AFSCME Nurses
AFSCME Physicians
FOPPO
LCPOA
Local 626
Prosecuting Attorney's
Benefits to keep you & your family well - Physically
Health insurance coverage becomes effective the first of the month following your first 30 days as an eligible employee.
Medical/Rx/Vision - Lane County offers medical, prescription and vision exam coverage for you and your eligible dependents. The plan options and costs per month for 2018 are outlined below:
If you enroll in the HDHP the County will contribute to your HSA: $1,500 (individual) or $3,000 (family) annually. This amount is prorated based on date of hire.
Eligible employees who complete a Health History Risk Assessment (HHRA), Biometric Screening, and Comprehensive Health Review (CHR) at the Live Well Center receive a $20 per month credit.
Wellness Clinic - The Live Well Center is for Lane County benefits-eligible employees, spouses and dependents (ages 2 and up) who are enrolled in the Lane County health plan. Marathon Health manages the Live Well Center and their clinical team provides confidential, affordable care for your acute and preventive healthcare needs. The Live Well Center also provides health coaching, chronic disease counseling, comprehensive primary care services, and much more.
Dental - Lane County provides dental coverage for employees and their eligible dependents.
Employee Assistance Program (EAP) - Lane County provides this counseling and concierge service to employees and members of their immediate households.
Fitness Center Membership - Lane County provides employees with a free membership to a local fitness center. Employees may add their families at a discounted rate.
Benefits to keep you & your family well - Financially
Retirement - Lane County pays for, and enrolls employees in the Oregon Public Service Retirement Plan (OPSRP) and the Individual Account Program (IAP) following six full months of employment. (Current members are eligible upon hire.)
Disability - Lane County pays a portion of wages for eligible employees through Short-Term Disability, and provides Long-Term Disability coverage. Lane County complies with all State and Federal disability laws for employee, family, parental and pregnancy leaves regulations.
Time Management - Lane County provides employees with a generous bank of hours to be used for sick, vacation, family emergencies and personal days.
Holidays - Lane County provides 10 paid holidays per year:
New Year's Day Independence Day
Martin Luther King Jr's Birthday Labor Day
Presidents' Day Veterans' Day
Memorial Day Thanksgiving Day
Juneteenth Christmas Day
Life Insurance - Lane County pays for employee group term life insurance.
County-paid Training & Development to keep your career well
On-site Classes - Lane County offers a variety of on-site classes to develop employees' soft and technical skills.
Online Training - Lane County offers a variety of online classes through LEAP to help employees continually improve their skills.
Conferences & Seminars - Lane County will consider reimbursement for employees to attend professional conferences, dependent upon budget, to encourage continuous learning and professional development.
Lane County offers these other valuable benefits
Deferred Compensation Retirement Savings - Employees may enroll in a deferred compensation program 457(b) to save for retirement.
Vision - Eligible employees may purchase supplemental vision insurance.
Supplemental Life Insurance - Employees may purchase supplemental life insurance for themselves and their dependents/spouse.
Aflac - Optional employee-paid voluntary group coverage is available through Aflac.
Group Discounts - Group discounts may include homeowners and auto insurance, pet health insurance, credit union membership.
Paid medical, dental and vision coverage for dependents is determined by labor agreement or APM, as applicable. Physicians should contact their supervisor for health plan options and rates. Please note that Temporary and Extra Help positions are not typically eligible for benefits. This is only brief summary of benefits available to eligible Lane County employees. In all cases, plan documents govern.
For additional information about these extraordinary benefits contact the Benefit Resource Center at 1-866-468-7272, or Lane County HR at (541) 682-3124.
01
IMPORTANT: Please ensure you have included all RELEVANT education, employment and experience in your application. To ensure compliance with Oregon Equal Pay laws, Human Resources will conduct a wage analysis based on the information you have provided in your application to determine the appropriate starting wage if you are selected.
- I acknowledge I have provided all relevant education and employment history.
02
What is your highest level of education?
- High School diploma or equivalent.
- Associate's degree.
- Two-year technical certificate or coursework.
- Bachelor's degree.
- Master's degree or higher.
03
How many years of programming experience do you have that demonstrates an increasing level of software systems expertise?
- No experiences or less than 2 years
- 2 - 3 years
- 3 - 4 years
- 4 - 5 years
- 5 - 6 years
- At least 6 or more years
04
Lane County staff are required to demonstrate competency in three areas: Passion to Serve, Driven to Connect and Focused on Solutions. Please tell us how these three traits apply to you and the work you have done in the past. (34 pts.)
05
How have you worked with data scientists and analysts to ensure that data is accurate and accessible? (33 pts.)
06
What do you think are the most important qualities for a data engineer to possess, and how do you embody these qualities in your work? (33 pts.)
Required Question
