Database and Systems Admin - Management Analyst 2

Working Title: Database and Systems Admin

Job Class: Management Analyst 2

Agency: Housing Finance Agency

• Job ID : 76391

• Location : St. Paul

• Telework Eligible : Yes, with intermittent trips to the office and other work locations

• Full/Part Time : Full-Time

• Regular/Temporary : Unlimited

• Who May Apply : Open to all qualified job seekers

• Date Posted : 05/02/2024

• Closing Date : 05/15/2024

• Hiring Agency/Seniority Unit : Housing Finance Agency / Housing Finance-MAPE

• Division/Unit : Human Resources Processing / MF-Business Operations

• Work Shift/Work Hours : Day Shift

• Days of Work : Monday - Friday

• Travel Required : No

• Salary Range: $24.20 - $35.13 / hourly; $50,529 - $73,351 / annually

• Classified Status : Classified

• Bargaining Unit/Union : 214 - MN Assoc of Professional Empl/MAPE

• FLSA Status : Nonexempt

• Designated in Connect 700 Program for Applicants with Disabilities (~~~/) : Yes

Teleworking employees are required to live in Minnesota or in a state bordering Minnesota.

The work you'll do is more than just a job.

At the State of Minnesota, employees play a critical role in developing policies, providing essential services, and working to improve the well-being and quality of life for all Minnesotans. The State of Minnesota is committed to equity and inclusion, and invests in employees by providing benefits, support resources, and training and development opportunities.

Minnesota Housing is hiring! We're a mission-focused financial institution looking for a Database and Systems Admin with the Minnesota Housing Multifamily division. This position serves as an expert on database and systems administration. This role supports the mission through ensuring accuracy in data systems while providing exceptional support to our users and acting as a primary point of contact for all things Salesforce. This is an exciting opportunity for a detail-oriented and motivated individual.

Essential Job Duties

• Responsible for maintaining the accuracy of data in Housing Development Software (HDS), Property Online Reporting Tool (PORT) and Portal databases by either entering data, verifying data or cleaning existing data. Maintenance includes property ownership or management contact updates and testing of new software updates to ensure field and report accuracy. Coordination with both external partners and internal partners required for support, updates, and solutions.

• Salesforce System Administration. Tasks include external user set-up (account and contact management) and change requests, funding round configuration, and reporting support. First point of contact for internal and external customers to help troubleshoot and problem solve when issues arise.Main tester for the Scoring System used to evaluate funding requests submitted in the competitive request for proposals to find and report any bugs when updates are required.

• Support application creation in HDS system and provide manual entry support. Creation of budget and funding modifications in system, as well as workbooks and scoresheet for testing of databases. In coordination with accounting, set up and ensure all grant funding draws are completed and accurate.

• Pull reports on an as needed and frequent basis in response to both internal and external requests. Analyze data and verify its accuracy, including making sure the information is the actual data being requested. Create reports and track process for development of report, purpose of report, and report functionality. Work with staff across the agency - accounting, senior leadership, managers, programs, production, closing, legal, BTS (the Agency's IT department), etc.

• Technology subject matter expert (SME) for the following programs: Adobe Acrobat; Bi-query; ~~~; Dymo Label Maker; FileMaker Pro; HDS Funds Management; HDS Multifamily; IDIS; Microsoft Outlook; Microsoft Word; Oracle; PORT; Salesforce; Secure Uploads LeapFILE; Visio; Web page. Support staff throughout the Multifamily Division with named program troubleshooting and training.

• Backup for Operations Department analyst by running monthly reports, quarterly reports, updating the Multifamily Management of Funds spreadsheet, and gathering data for National Council of State Housing Agencies (NCSHA) and Moody's reports.

• Perform other duties as assigned.

Minimum Qualifications

To be qualified for and considered for this position, applicants must meet all of the minimum qualifications listed below. Ensure that your resume contains descriptions of your work experiences sufficient for comparison against the requirements stated below and indicate the beginning and ending month and year for each job held.

Only applicants whose resumes clearly demonstrate fulfillment of each of these minimum qualifications will be considered for this position.

• One (1) year of experience in data entry, customer service or in an administrative role performing database concepts including data entry and data verification. An associate's degree in Business, Accounting or Finance can substitute for six (6) months of experience.

• Proficiency in Microsoft Office Suite (Word, Excel, PowerPoint).

• Experience identifying and troubleshooting basic computer software issues.

• Excellent organizational skills with the ability to manage multiple tasks simultaneously and meet deadlines.

• Attention to detail and a commitment to accuracy.

• Demonstrated communication skills, including ability to comprehend and communicate complex information in plain language.

Preferred Qualifications

• Our employees are dedicated to ensuring cultural responsiveness. Preferred candidates will have a variety of experiences working effectively with others from different backgrounds and cultures.

• Basic understanding of Structured Query Language.

• Experience with the Salesforce platform.

• Understanding of affordable rental housing financing, such as the low-income housing tax credit, federal and state appropriations used for deferred loans, and amortizing first mortgages.

Physical Requirements

Requires moving office items such as file folders and small office tools.

Additional Requirements

This position requires successful completion of the following

• Reference Checks.

• Job related background checks.

• Conflict of Interest Disclosure.

AN EQUAL OPPORTUNITY EMPLOYER

Minnesota State Colleges and Universities is an Equal Opportunity employer/educator committed to the principles of diversity. We prohibit discrimination against qualified individuals based on their race, sex, color, creed, religion, age, national origin, disability, protected veteran status, marital status, status with regard to public assistance, sexual orientation, gender identity, gender expression, or membership in a local commission as defined by law. As an affirmative action employer, we actively seek and encourage applications from women, minorities, persons with disabilities, and individuals with protected veteran status.

Reasonable accommodations will be made to all qualified applicants with disabilities. If you are an individual with a disability who needs assistance or cannot access the online job application system, please contact the job information line at ~~~ or email ~~~ . Please indicate what assistance is needed.