City of Hillsboro, OR
Salary :
$83,292.00 - $109,607.00 Annually
Location :
OR 97124, OR
Job Type:
Full Time
Job Number:
2025-64
Department:
Library
Division:
LIBRARY
Opening Date:
01/20/2025
Closing Date:
2/2/2025 11:59 PM Pacific
Introduction The Library Department is seeking a highly skilled and detail-oriented Data Analyst to transform complex data into meaningful insights that drive decision-making. This critical role will shape the library's future by making data accessible and understandable for diverse stakeholders, enhancing services for the community we serve.
About the Hillsboro Public Library The Hillsboro Public Library is a cornerstone of the community, offering programs, resources, and services that inspire learning, connection, and growth. As part of our team, you'll work in a supportive, collaborative environment that values data-informed decisions to continuously improve and expand our offerings.
Position Overview In this role, you will manage, analyze, and interpret data for key library and City reports while ensuring the information is understandable for a variety of audiences. From budget analysis to creating impactful data visualizations, your work will support stakeholders, including the Library Board, City leadership, Foundation Friends, and the broader community.
Key Responsibilities
Data Reporting and Analysis:
Collect and convert data into meaningful insights for City, State, and WCCLS reporting. Stakeholder Collaboration:
Present findings to non-technical audiences, ensuring accessibility and clarity for stakeholders, such as the Library Board, City leadership, and the community. Survey Development:
Design and analyze surveys to gather feedback and improve services. Budget Support:
Conduct budget analyses and provide financial insights to support decision-making. Tool Utilization:
Leverage tools like MS Excel, Power BI, Tableau, and SQL to create detailed reports and visualizations. Your Impact This role offers the opportunity to: Ensure data-driven decision-making shapes the library's future. Simplify complex data for public and stakeholder understanding. Contribute to strategic planning and operational efficiency. For the full job classification details, visit:
Acceptable Experience and Training
Education : Bachelor's degree in a related field such as Data Science, Statistics, or Information Management. Experience : Four years of related experience. Licenses/Certifications : A valid, current Driver's License and a safe driving record are required. An equivalent combination of education and experience sufficient to perform essential duties will also be considered. What We're Looking For We're searching for a professional who thrives on solving complex problems and communicating results clearly. The ideal candidate brings:
Strong proficiency in MS Excel (required). Experience with Power BI or Tableau for creating visualizations (required). Proficiency in SQL for managing and analyzing data (required). Knowledge or experience in budget analysis (preferred). Excellent communication skills to convey data insights to non-technical audiences. The ability to design surveys (preferred, but not required). Knowledge of public libraries and experience with data privacy practices are valuable but not required.
Additional Information
Work Schedule This position is in-person, with work hours Monday through Friday, 8:00 AM - 5:00 PM or 9:00 AM - 6:00 PM.
Great Benefits at the City of Hillsboro At the City of Hillsboro, we believe in supporting our employees with a that promotes your health, well-being, and financial security. Here are just some of the excellent benefits we offer:
Retirement Plans : Access to PERS/OPSRP retirement plans and a Deferred Compensation program with up to 2% employer matching contributions. Healthcare Coverage: Employer-sponsored medical, dental, and vision plans for you and your family. Health Reimbursement : VEBA Health Reimbursement Arrangement and Flexible Spending Accounts to help you save on healthcare expenses. Insurance : Life insurance coverage for your financial peace of mind. Wellness Programs : Membership for employee and dependents to both Hillsboro Community Centers (Hidden Creek & SHARC), participation in the Healthy Hillsboro program, and access to the Employee Assistance Program (EAP). Paid Time Off : Generous leave policies, including 11 paid holidays, 2 personal leave days, 18 vacation days (for 0-5 years of service), and 12 sick days per year. Commuter Benefits : TriMet Annual Pass to make your daily commute easier. Additional Incentives : Bilingual Incentive Pay for employees who provide support in multiple languages.
Tentative Recruitment Timeline*
Application Period: January 20, 2025 - February 2, 2025 Application Reviews Complete: February 7, 2025 First Round Interviews (Virtual): February 18 - 20, 2025 Second Round Interviews (Onsite): March 3, 2025 Selection and Offer: March 2025 *This schedule is subject to change based on City of Hillsboro needs.
Why Join Us? Be part of a dynamic library system that thrives on innovation and collaboration. Your contributions will have a direct impact on the community, helping to shape services and programs that matter.
Diversity, Equity, and Inclusion Hiring a workforce that reflects the diverse community we serve is essential to delivering exceptional City services and programs. The City of Hillsboro is committed to creating and supporting an inclusive and welcoming environment for all employees to thrive. We value, respect, and empower employees as unique individuals with authentic voices and diverse ideas.
City of Hillsboro is proud to offer robust benefit packages to employees. Please check out our for benefit guides for our non-represented full-time employees and part-time employees. Benefits may vary for positions identified in Police, Fire, and Library collective bargaining agreements, which can also be found on the Salary and Benefits page.
01
To ensure your application is considered, please provide detailed and specific responses to all supplemental questions. Incomplete applications, including those missing a resume, cover letter, or thorough supplemental responses, will not be reviewed.Do you understand and agree to these requirements?
Yes No
02
Strategic planning is a critical component of this role. Share an example of how you contributed to or supported a strategic planning process, either formally or informally. What steps did you take to gather and analyze data, engage stakeholders, and contribute to actionable outcomes?
03
The mission of the Hillsboro Public Library is "For Everyone/Para Todos." How would you incorporate this philosophy into your work to ensure disparate voices are being heard?
04
How would you rate your proficiency in Microsoft Excel?
No Experience: No prior experience with Microsoft Excel Beginner: Basic knowledge (e.g., data entry, simple calculations, basic formatting) Intermediate: Moderate skills (e.g., using functions and formulas, creating charts, sorting and filtering data) Advanced: High proficiency (e.g., pivot tables, advanced formulas, conditional formatting, complex charting) Expert: Expert-level skills (e.g., data analysis, VBA programming, macros, advanced data visualization)
05
How would you rate your proficiency in Tableau?
No Experience: No prior experience with Tableau Beginner: Basic knowledge (e.g., creating simple dashboards, using basic visualization tools) Intermediate: Moderate skills (e.g., creating calculated fields, filters, and parameters) Advanced: High proficiency (e.g., advanced calculations, integrating multiple data sources, optimizing dashboards) Expert: Expert-level skills (e.g., designing enterprise-grade dashboards, advanced analytics, integrating Tableau with other tools)
06
How would you rate your proficiency in Power BI?
No Experience: No prior experience with Power BI Beginner: Basic knowledge (e.g., creating simple reports and dashboards, using built-in visuals) Intermediate: Moderate skills (e.g., using DAX functions, data modeling, creating custom visuals) Advanced: High proficiency (e.g., advanced DAX, complex data modeling, optimizing dashboards for performance) Expert: Expert-level skills (e.g., integrating Power BI with external databases, embedding dashboards, developing using Power BI API)
07
How would you rate your proficiency in SQL?
No Experience: No prior experience with SQL Beginner: Basic knowledge (e.g., simple SELECT queries, sorting and filtering data) Intermediate: Moderate skills (e.g., JOIN operations, subqueries, basic data manipulation) Advanced: High proficiency (e.g., stored procedures, views, performance tuning) Expert: Expert-level skills (e.g., database optimization, advanced query design, database schema management)
Required Question
$83,292.00 - $109,607.00 Annually
Location :
OR 97124, OR
Job Type:
Full Time
Job Number:
2025-64
Department:
Library
Division:
LIBRARY
Opening Date:
01/20/2025
Closing Date:
2/2/2025 11:59 PM Pacific
Introduction The Library Department is seeking a highly skilled and detail-oriented Data Analyst to transform complex data into meaningful insights that drive decision-making. This critical role will shape the library's future by making data accessible and understandable for diverse stakeholders, enhancing services for the community we serve.
About the Hillsboro Public Library The Hillsboro Public Library is a cornerstone of the community, offering programs, resources, and services that inspire learning, connection, and growth. As part of our team, you'll work in a supportive, collaborative environment that values data-informed decisions to continuously improve and expand our offerings.
Position Overview In this role, you will manage, analyze, and interpret data for key library and City reports while ensuring the information is understandable for a variety of audiences. From budget analysis to creating impactful data visualizations, your work will support stakeholders, including the Library Board, City leadership, Foundation Friends, and the broader community.
Key Responsibilities
Data Reporting and Analysis:
Collect and convert data into meaningful insights for City, State, and WCCLS reporting. Stakeholder Collaboration:
Present findings to non-technical audiences, ensuring accessibility and clarity for stakeholders, such as the Library Board, City leadership, and the community. Survey Development:
Design and analyze surveys to gather feedback and improve services. Budget Support:
Conduct budget analyses and provide financial insights to support decision-making. Tool Utilization:
Leverage tools like MS Excel, Power BI, Tableau, and SQL to create detailed reports and visualizations. Your Impact This role offers the opportunity to: Ensure data-driven decision-making shapes the library's future. Simplify complex data for public and stakeholder understanding. Contribute to strategic planning and operational efficiency. For the full job classification details, visit:
Acceptable Experience and Training
Education : Bachelor's degree in a related field such as Data Science, Statistics, or Information Management. Experience : Four years of related experience. Licenses/Certifications : A valid, current Driver's License and a safe driving record are required. An equivalent combination of education and experience sufficient to perform essential duties will also be considered. What We're Looking For We're searching for a professional who thrives on solving complex problems and communicating results clearly. The ideal candidate brings:
Strong proficiency in MS Excel (required). Experience with Power BI or Tableau for creating visualizations (required). Proficiency in SQL for managing and analyzing data (required). Knowledge or experience in budget analysis (preferred). Excellent communication skills to convey data insights to non-technical audiences. The ability to design surveys (preferred, but not required). Knowledge of public libraries and experience with data privacy practices are valuable but not required.
Additional Information
Work Schedule This position is in-person, with work hours Monday through Friday, 8:00 AM - 5:00 PM or 9:00 AM - 6:00 PM.
Great Benefits at the City of Hillsboro At the City of Hillsboro, we believe in supporting our employees with a that promotes your health, well-being, and financial security. Here are just some of the excellent benefits we offer:
Retirement Plans : Access to PERS/OPSRP retirement plans and a Deferred Compensation program with up to 2% employer matching contributions. Healthcare Coverage: Employer-sponsored medical, dental, and vision plans for you and your family. Health Reimbursement : VEBA Health Reimbursement Arrangement and Flexible Spending Accounts to help you save on healthcare expenses. Insurance : Life insurance coverage for your financial peace of mind. Wellness Programs : Membership for employee and dependents to both Hillsboro Community Centers (Hidden Creek & SHARC), participation in the Healthy Hillsboro program, and access to the Employee Assistance Program (EAP). Paid Time Off : Generous leave policies, including 11 paid holidays, 2 personal leave days, 18 vacation days (for 0-5 years of service), and 12 sick days per year. Commuter Benefits : TriMet Annual Pass to make your daily commute easier. Additional Incentives : Bilingual Incentive Pay for employees who provide support in multiple languages.
Tentative Recruitment Timeline*
Application Period: January 20, 2025 - February 2, 2025 Application Reviews Complete: February 7, 2025 First Round Interviews (Virtual): February 18 - 20, 2025 Second Round Interviews (Onsite): March 3, 2025 Selection and Offer: March 2025 *This schedule is subject to change based on City of Hillsboro needs.
Why Join Us? Be part of a dynamic library system that thrives on innovation and collaboration. Your contributions will have a direct impact on the community, helping to shape services and programs that matter.
Diversity, Equity, and Inclusion Hiring a workforce that reflects the diverse community we serve is essential to delivering exceptional City services and programs. The City of Hillsboro is committed to creating and supporting an inclusive and welcoming environment for all employees to thrive. We value, respect, and empower employees as unique individuals with authentic voices and diverse ideas.
City of Hillsboro is proud to offer robust benefit packages to employees. Please check out our for benefit guides for our non-represented full-time employees and part-time employees. Benefits may vary for positions identified in Police, Fire, and Library collective bargaining agreements, which can also be found on the Salary and Benefits page.
01
To ensure your application is considered, please provide detailed and specific responses to all supplemental questions. Incomplete applications, including those missing a resume, cover letter, or thorough supplemental responses, will not be reviewed.Do you understand and agree to these requirements?
Yes No
02
Strategic planning is a critical component of this role. Share an example of how you contributed to or supported a strategic planning process, either formally or informally. What steps did you take to gather and analyze data, engage stakeholders, and contribute to actionable outcomes?
03
The mission of the Hillsboro Public Library is "For Everyone/Para Todos." How would you incorporate this philosophy into your work to ensure disparate voices are being heard?
04
How would you rate your proficiency in Microsoft Excel?
No Experience: No prior experience with Microsoft Excel Beginner: Basic knowledge (e.g., data entry, simple calculations, basic formatting) Intermediate: Moderate skills (e.g., using functions and formulas, creating charts, sorting and filtering data) Advanced: High proficiency (e.g., pivot tables, advanced formulas, conditional formatting, complex charting) Expert: Expert-level skills (e.g., data analysis, VBA programming, macros, advanced data visualization)
05
How would you rate your proficiency in Tableau?
No Experience: No prior experience with Tableau Beginner: Basic knowledge (e.g., creating simple dashboards, using basic visualization tools) Intermediate: Moderate skills (e.g., creating calculated fields, filters, and parameters) Advanced: High proficiency (e.g., advanced calculations, integrating multiple data sources, optimizing dashboards) Expert: Expert-level skills (e.g., designing enterprise-grade dashboards, advanced analytics, integrating Tableau with other tools)
06
How would you rate your proficiency in Power BI?
No Experience: No prior experience with Power BI Beginner: Basic knowledge (e.g., creating simple reports and dashboards, using built-in visuals) Intermediate: Moderate skills (e.g., using DAX functions, data modeling, creating custom visuals) Advanced: High proficiency (e.g., advanced DAX, complex data modeling, optimizing dashboards for performance) Expert: Expert-level skills (e.g., integrating Power BI with external databases, embedding dashboards, developing using Power BI API)
07
How would you rate your proficiency in SQL?
No Experience: No prior experience with SQL Beginner: Basic knowledge (e.g., simple SELECT queries, sorting and filtering data) Intermediate: Moderate skills (e.g., JOIN operations, subqueries, basic data manipulation) Advanced: High proficiency (e.g., stored procedures, views, performance tuning) Expert: Expert-level skills (e.g., database optimization, advanced query design, database schema management)
Required Question