Senior Data Financial Management Analyst

Senior Data Financial Management Analyst

Location

Planning and Development Services

Work Status

Full Time

THIS POSITION WILL BE OPEN UNTIL FILLED.

SALARY: $62,620.00 - 77,900.00 Salary USD

JOB SUMMARY:

Under general supervision, assist with developing, implementing and monitoring performance driven management, accountability, and resource allocation for the Planning & Development Department. Analyzes financial and operational data, creates insightful visualizations, and develops budget to support organizational goals.

ESSENTIAL JOB FUNCTIONS:

• Lead and formulate the annual operating budget, planning and forecasting processes, including variance analysis and budget reconciliation for expenditures and fee-based revenues.

• Prepare financial reports, forecasts (end-of year and five-year), and budgets to support strategic planning initiatives.

• Develop and maintain financial models and perform ad-hoc scenario analyses to support objective decision-making and recommendations to upper management.

• Fee-based, construction industry related revenue forecast modeling, and comparisons

• Workload analysis, full vs. part-time staffing, third party contract comparisons, and cost recovery

• Collaborate with cross-functional teams to gather data requirements, understand data needs, and ensure alignment with organizational objectives to develop and publish reports internally to executive management and to the public.

• Use of the permitting data in relation to performance metrics for turnaround times, permit issuance, inspections across multiple workgroups within department.

• Researching data to provide explanations in meeting stated milestones.

• Monitor key departmental performance indicators (KPIs) and provide regular updates on published performance goals.

• Design and implement data models to support departmental data visualization reporting and analysis to describe the department's performance, productivity, financial and business plan goals internally to executive management and the public.

• Automate data extraction, transformation, and loading processes from various software sources into report-ready formats to effectively structure a story through data analysis.

• Analyze unrelated complex financial, economic, and workload data sets from various sources to derive actionable insights, identify trends, patterns, and recommendations as it relates to the services provided by Planning and Development Services, e.g. construction related costs and trends, tourism, inflationary trends that could impact permitting and revenue collections.

• Experience in developing and maintaining interactive dashboard visualizations using Power BI, or similar systems.

OTHER JOB FUNCTIONS:

• Process refunds related to permit fees collected and maintain accurate documentation.

• Process daily revenue receipt balancing between various systems.

• Experience in providing recommendations for process improvements, efficiency gains, and data-driven decision-making to upper management.

• Stay updated on industry trends and best practices in data visualization, reporting, financial analysis, and budgeting.

• Ability to assist with monitoring of department's federal funding and financial awards or reimbursements.

• Perform data validation and quality assurance to ensure accuracy and reliability.

• Other duties as assigned.

MINIMUM QUALIFICATIONS:

Knowledge, Skills and Abilities Required:

• Strong proficiency in Microsoft Office 365, primarily Excel and Power BI, Adobe InDesign or similar desktop publishing application.

• Skill in creation of data visualizations or dashboards utilizing multiple customer service software application tools, e.g., live chat, permitting, and survey.

• Proven skill in research and analysis methods, survey techniques, statistical, and financial analysis.

• Skill in planning, designing, preparing professional reports utilizing data visualization software and complex analysis for management, executive city leadership, and the public.

• Skill in research, collection, and analyzing large complex data sets, formulating trend analysis, and reporting, to develop data driven decision recommendations to management.

• Skill in principles and practices of administration, organization, management, forecasting, and budgeting.

• Skill in effectively communicating conceptual or informative ideas to others verbally and in written form, and influencing opinions, attitudes, and judgment.

• Skill in communicating professionally and tactfully with other city employees and the public verbally and in written means.

• Skill in managing multiple priorities, deadlines, and tasks.

• Preferred skill in development tracking software, enterprise resource planning tool ERP (Workday),

• Skill in data extraction, automation, and development of data models to formulate analysis and reports from various software applications.

• Skill in process re-engineering studies; conducts interviews with personnel to identify functional areas; analyze data; plot trends; prepare profile of area being studied; maps process and workflows; and identifies problem/opportunity areas.

• Skill in identifying opportunities for improving service delivery methods and procedures.

• Knowledge of government expenditure and revenue accounting, financial controls, and audit techniques.

• Knowledge of relational database and querying software.

• Preferred knowledge of development services functions.

• Ability to think creatively and develop solutions.

• Ability to have high attention to detail.

• Ability to evaluate, study survey findings, identify program alternatives, and recommend feasible actions.

• Ability to exercise discretion and independent judgment utilizing knowledge of the organization's policies.

• Ability to work independently under general instructions.

• Ability to plan, organize, monitor, and collaborate with internal and external stakeholders to accomplish unit objectives.

• Ability to develop training for City personnel on computer-based applications and data.

• Ability to establish and maintain effective working relationships with other City employees and the public.

Qualifying Education and Experience:

• Bachelor's degree in business administration, Public Administration, Economics, Business Analytics, Accounting or related field

• Three (3) years of similar experience

• Or master's degree with one (1) year of similar experience

• Or any equivalent combination of education and experience. Minimum experience of 2-3 years in data visualization analysis, reporting, and financial management.

Employment Screenings Required:

• Criminal background check