Sql data analyst Jobs in Roseville, CA

Reserve Analyst

The Management Trust Position Title: Reserve Analyst Location: Sacramento, CA Reporting To: Assistant Director of Central Reserves Status: Exempt, Full-Time Salary: $75,000 - $85,000/Annually DOE

The Management Trust is a community association management company. We believe that building and maintaining a community takes more than just hammers and nails. It takes integrity, trust, experience, and support. Our success is based on the belief that effective management anticipates our clients' needs, not merely reacts to them. We are a company of creative and committed individuals driven by grand aspirations and are proud to be the only 100% employee-owned community management firm in the nation. Our Employee Owners are encouraged to actively participate in growing our business by helping define best practices every day. It is in this spirit that we encourage you to explore this opportunity to join The Management Trust team.

The Reserve Analyst is responsible for creating Reserve Study Reports for homeowner associations (HOAs) and Condominiums (Condos). The reserve study provides the community with a tool to adequately prepare for future expenses specifically by outlining how the Board of Directors can anticipate the repair and/or replacement of major physical assets. This role requires a significant amount of independent judgement and discretion with respect to matters of significance, as it guides core fiscal management of both small and large-scale association budgets. The Analyst position allows someone with strong qualifications, specific to Reserve Studies and related business, to independently execute the processes, software and best practices of our centralized Reserve Team, and to further develop their experience. The Reserve Analyst will be assigned a group of divisions and be responsible for independently coordinate planning, processes and training in preparation for each reserve season. Understanding and driving efficient practices to meet the reserve service needs of the associations managed by each division is critical. When ready, the Reserve Analyst may be eligible to apply and test for the Professional Reserve Analyst (or comparable) certification.

Job Duties and Responsibilities:

• Develop meaningful relationships with internal and external clients including Division leadership, Community Association Managers and Association Board of Directors, as needed
• Provide training for Reserve Specialists or other team members through job shadowing and instruction on department specific best practices, processes and work product, as needed
• Understand the unique history and needs of each community as they factor heavily into each reserve study
• Research historical data regarding previous capital expenses and current deficiencies
• Review current reserve fund balance and contribution rates; forecast future balances and rates based on pricing adjustments and other revenue projections
• Independently conduct site inspections to provide surface observations of common area elements; create inventory of these assets and record condition
• Independently, estimate the cost of general maintenance, repair, and replacement of various physical assets
• Independently, create a timeline for anticipated repairs and related needs (i.e. vendors, permits, etc.)
• Independently, estimate and create a 30-year funding plan for the association; present to the Board of Directors
• Partner with Assistant Director and assigned Division Leadership/Management teams to set pricing, timelines, and education regarding processes in preparation for each reserve season
• Participate in educating management teams to raise understanding of core Reserve Study concepts
• Lead training session(s) for critical path partners (Community Association Managers) on internal reserve study related processes
• Serve as a resource for the Community Association Management team, as well as other internal partners
• Provide direct training and support to Association Boards of Directors and management teams
• Other duties and special projects as assigned

Qualifications:

• Bachelor's degree preferred
• Two (2) year minimum experience in reserve studies preferred
• Ability to be intuitive regarding the financial needs of HOAs
• Strong foundation in accounting and related analysis, project management, and sales
• Comfortability with internal and external client communications, including Division Leadership, Community Association Managers, and association Boards of Directors
• Solid knowledge of Microsoft Outlook, Excel, and Word; intermediate skills a plus
• Proficiency/comfortability in learning other software applications
• Conflict resolution skills
• Ability to meet deadlines and address time-sensitive issues
• Superior multi-tasking skills
• Excellent written and verbal communication
• Ability to provide high-level customer service with astute attention to detail and organization
• Must be a team player
• Ability to manage workflow amid shifting priorities
• Willing to learn Company process and procedures, and learn/use enterprise software systems
• Adaptable and dependable with a solid attendance record
• Professional and respectful demeanor with all internal and external customers at all times
• Strong analytical, organizational, and problem-solving skills
• Work independently, with little direction, and as part of a team
• Ability to exercise considerable judgement, maintain confidentiality, and act with diplomacy and tact at all times

Special Position Requirements:

• Must have and maintain a valid driver's license, vehicle insurance, and driving record in compliance with Company policy

Essential Functions:

• Use standard office equipment, including: computer, phone, copier/scanner, etc.
• Be stationary for periods of time
• Relocate up to (25) pounds
• Travel to and from associations and/or offsite meetings

Supervises Others? If so, list:

• None

Schedule & Travel:

• Monday-Friday from approx. 8:00 am-5:00 pm
• This position may require occasional long hours, including overnight travel to meet business needs
• This position may require travel by motor vehicle or flight to meet position needs
• This position may require travel for multiple days, including overnight stays to meet position needs

The Management Trust is an Equal Opportunity employer. We celebrate and support diversity.

TMT reserves the right to modify this job description at any time based on business need.

Equal Opportunity Employer This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.