Sql data analyst Jobs in Salem, OR

Financial Analyst Position

This is a Salem Housing Authority position, which is a separate employer from the City of Salem. Make an impact: The Housing Authority of the City of Salem has an excellent opportunity for an experienced Financial Analyst to be part of the Salem Housing Authority (SHA) accounting team. The Financial Analyst is responsible for applying accounting principles and procedures. If you are a dedicated and efficient and proficient with accounting responsibility and are looking to work for an agency that makes a difference in the community, then we encourage you to apply! Learn and grown: The Housing Authority of the City of Salem values employees and their professional development and we pride ourselves on providing a great work-life balance. We are committed to growing the capabilities of our people, where you can work with diverse individuals, explore new ways of thinking, and expand your capabilities. We invite you to apply and join our team!

What you will do: The successful candidate must be detail-oriented, self-motivated, and capable of analyzing codes and regulations to make financial decisions. The Financial Analyst performs high-level accounting services in property accounting, grant management, financial reporting, and internal controls, reconciling the general ledger, maintaining federal fixed asset inventory control records, and fund-based accounting system setup.

• Review financial data for trends and variances. Analyze results to evaluate effectiveness of operations and identify potential improvements.
• Possesses strong data analysis skills with the ability to organize, summarize and communicate findings and results.
• Reconcile client data across sources and systems to ensure accurate balances.
• Assist with preparing and reviewing annual budgets for a variety of programs and developments
• Attention to detail in performing calculations to ensure accuracy of ledgers and reports.
• Setting up financial reports and designing them for accuracy and sustainability.
• Demonstrates proficiency in learning systems and applying skills for streamlining processes. Prior experience in Power BI, Excel, SQL, and Access preferred.
• Highly motivated and takes initiative for improvements. Interest in learning processes and working with team members to enhance process flows.

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. Position schedule is Monday through Friday between the hours of 7:30 a.m. - 4:30 p.m. 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 reliable transportation (e.g., carpool, rideshare, public transit, walking, biking) to report to and from work sites, events, trainings, and meetings. Bachelor's degree from an accredited college or university in public administration, business administration, or a related field, and five years of experience in an accounting, finance, audits, or related field, or any combination of experience and training that demonstrate possession of the knowledge, skill and abilities as listed, and ability to perform the examples of work. 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.

• Experience using Power BI or Tableau for business data analysis or reporting
• Advanced Excel skills
• Experience analyzing or presenting financial reports
• Experience building, maintaining or querying relational databases using SQL
• Chartered Financial Analyst (CFA), Certified Management Accountant (CMA), or degree in business analytics

What you will bring along: Experience demonstrating self-motivation and leadership, exercising considerable initiative and making independent judgements; Knowledge of analyzing, researching, organizing, and compiling data into meaningful reports; Experience working independently while effectively managing assigned responsibilities; Knowledge of fostering a diverse and inclusive workplace by respecting, seeking to understand, and valuing individual differences.

About us: Our mission is to assist low- and moderate-income families to achieve self-sufficiency through stable housing, economic opportunity, community investment, and coordination with social service providers. This is a great opportunity to help positively impact your community. Come work in a positive and supportive work environment that enforces a safe workplace, has a culture of teamwork and communication, promotes the organizational values of workplace diversity, equity and inclusion (DEI), and actively promotes an environment respectful of living and working in multicultural society. The City of Salem is the second largest City in the State of Oregon, located in the heart of Willamette Valley, and is the capital city of Oregon with a population over 170,000. Centrally located, Salem is 47 miles south of Portland and an hour from the Cascade Mountains to the east and an hour from the ocean beaches to the west. Salem is an exceptional community for living and working with exciting new and comfortable well-established neighborhoods and carefully preserved historic buildings. A full-service City, Salem has eight primary departments: Community Services, Finance, Fire, Enterprise Services, Legal, Police, Public Works, Community and Urban Development Department. Several departments also have functional divisions within their department. The City has five labor unions and employs roughly 1,350 talented and dedicated staff members. The Urban Renewal Agency and the Salem Housing Authority are separate municipal corporations. The Agency contracts with the City for services and the Authority is led by the Housing Administrator within the Urban Development department.

Where can I find out more about the position? Go to the menu option for Class Specifications and search for Management Analyst HA, II. If you would like to learn more about the Salem Housing Authority, please visit our website at

How can I apply? The City of Salem and Salem Housing Authority 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. Hiring managers do not have access to view resumes as part of the application review process. Please ensure that the details of your application, including work history, demonstrate how you meet the qualifications for the position. Click here to fill out the Section 3 Employment Preference Form (Download PDF reader) and submit with your employment 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.