Sql data analyst Jobs in Salem, OR

Franchise Administrator And Fiscal Analyst

Make an impact: Do you have expertise in municipal franchise management? Do you want to use your proven financial analysis, contract administration, and customer service skills to make a difference in the City of Salem? Come join our team in the Budget Office division of the Finance Department as our next Franchise Administrator and Fiscal Analyst. This position uses their knowledge of Oregon utility providers and regulations to manage right-of-way use contracts, interact with stakeholders and public officials, and perform high-level, complex financial analyses to make professional recommendations. Work is completed in a collaborative, team environment. If you are detail oriented, flexible, willing to learn, have a high level of financial and analytical proficiency, proven customer service skills, and excellent oral and written communication, then this position may be the right fit for you! Learn and grow: The Finance Department values employees and their professional development. The department offers opportunities to attend professional conferences, as well as supporting ongoing education and certifications.

What you will do: The Budget Office provides a full range of budget and financial analysis services to the City, Urban Renewal Agency and external customers with professionalism and integrity. The Franchise Administrator and Fiscal Analyst role performs advanced analysis of programs, procedures, financial activities, and other associated business issues that have a division, department or citywide impact. This position responds to an array of inquiries from the public, City staff, and elected officials related to solid waste, telecommunications, and other utilities authorized to use the City right-of-way. This position manages the solid waste rate setting process including validating rate models and staffs a public committee related to solid waste. This position also uses their analytical skills to support the citywide budget process by reviewing department budgets and performing reconciliations. We're looking for a professional who will build key relationships with regulatory agencies, service providers, local businesses, and community organizations. A successful candidate will be self-motivated and results-oriented with strong organizational, communication, and analytical skills.

• Provide excellent customer service and support to stakeholders
• Contract development, administration, and compliance activities
• Validate and develop rate structures
• Analyze, review, and audit sources of revenue and expenditures
• Develop and interpret financial reports
• Occasional attendance at meetings or activities outside normal working hours.

What can we offer you for all your hard work?

• Medical, dental, and vision coverage for you and your family.
• Paid vacation and sick time in accordance with City policies.
• Competitive pay.
• Employer-paid PERS contribution of 6%.
• Opportunity for voluntary pre-tax contributions to a 457b account.
• Health care and dependent care flexible spending accounts.
• Voluntary long-term care.
• Employee wellness program.
• Employee assistance program.
• Employee health clinic.
• Position schedule is typically Monday through Friday, 8:00 a.m. 5:00 p.m.
• Our team follows a hybrid work structure where employees can work remotely or from the office 440 Church St Se, Salem, OR 97301, as needed, based on demands of specific tasks, upon completion of on-boarding and position specific training, and manager approval. This is subject to change based on business needs.
• The City of Salem offers a comprehensive and equitable base salary within the listed range based on your experience, skills, and education. We encourage you to clearly describe how you meet the minimum qualifications and essential attributes in your application materials. Learn more about Equal Pay.

What are the minimum qualifications?

• Must pass the pre-employment background check.
• Must have an Oregon driver license and a driving record that meets the City of Salem's driving standards.
• Bachelor's degree from an accredited college or university in public administration, business administration, finance, or a closely related field, and five to seven years of experience in a related field, including various facets of municipal government operations, finance, statistical analysis, or policy development, or any combination of experience and training that demonstrate possession of the knowledge, skills, and abilities as listed, and ability to perform the essential job functions.
• Hiring managers do not have access to view resumes as part of the application review process, please make sure to give detailed information in your application that includes your experience, knowledge, skills, and abilities as requested in the supplemental questions and job advertisement.

What you will bring along:

• Knowledge of principles and methods of organization and management analysis, operations management, fiscal administration and the use of electronic spreadsheets, PC databases and word processing in analysis and report preparation;
• Knowledge of local, state, and federal issues and regulations concerning telecommunications, solid waste, cable, and utility industry standards;
• Experience with municipal management of the public right-of-way;
• Experience speaking and presenting effectively at public meetings;
• Experience reviewing and interpreting contract agreements and evaluating contract compliance;
• Experience exercising proficiency, tact, and leadership when preparing and explaining recommendations and assisting with their implementation;
• Experience establishing and maintaining strong working relationships and effective communication with all levels of City staff, public bodies or agencies, and community members;
• Experience assisting with the preparation and development of city or departmental budgets, as well as financial reports and analyses;
• Experience drafting or reviewing reports and other written communications presented to City Council or other public bodies;
• Experience thinking critically and employing complex problem solving skills to evaluate options, draw conclusions, and implement solutions;
• Experience working independently and making appropriate decisions regarding work methods and priorities;
• Knowledge of and commitment to respecting, seeking to understand, and valuing individual differences to foster a diverse and inclusive workplace;
• Experience communicating effectively in writing in a manner appropriate to the needs of the audience.

About us: Salem is the second largest city in Oregon and the capital city. Centrally located in the Willamette Valley, Salem is 49 square miles in size and extends across two counties, Marion and Polk. The community has well-established neighborhoods and carefully preserved historic buildings with wide diversity and a family-friendly ambiance. The city is home to nearly 180,000 residents. For a full community profile detailing demographics and housing statistics, visit the City of Salem website.

The City of Salem organization has eight primary departments: Community Services, Finance, Fire, Enterprise Services, Legal, Police, Public Works, and Community Planning and Development. Several departments also have functional divisions within their department. The City of Salem employs roughly 1,350 talented and dedicated staff members and works collaboratively with five labor unions.

Where can I find out more about the position? Go to the menu option for Class Specifications and search for Fiscal Analyst, Senior.

How can I apply? The City of Salem invites individuals of all diverse communities and backgrounds to apply for our available job opportunities as we strive to provide the best service to everyone. The City of Salem is committed to providing equal employment opportunities to all and has a culture that values diversity, equity, and inclusion. We believe that by welcoming differences, encouraging new ideas and views, listening to, and learning from each other, we are better able to serve the community. To apply, click on the green "Apply" button to complete your application and supplemental questionnaire, and include three references and resume. Make sure that you specify how you meet the qualifications outlined in the class specification and complete the application. Applicants that meet the minimum qualifications as outlined above but not selected for this position may be placed on an eligibility list, and candidates may be hired from the list. Eligibility lists are valid for six months. The City will send email notifications to eligible candidates about potential hiring opportunities so please ensure your email settings accept our system generated email notifications. You may subscribe for automatic notification of job openings at the City through the Job Interest Cards sign up today! For more information about employment at the City of Salem, please visit our website at

This announcement is not an implied contract and may be modified or revoked without notice.