ANALYST II

Job Description and Duties Under direction, the Analyst II independently researches, analyzes, and makes recommendations on complex financial and performance reports. The incumbent leads collaborative efforts to close data gaps, update tracking matrices, and improve collection methods to ensure compliance with program requirements. Additionally, they take the lead on multi-disciplinary projects and managerial issues to enhance the quality of final authority documentation. Conducts rigorous analytical studies to formulate actionable procedures, program alternatives, and operational policies. Validates data integrity, performs comprehensive program evaluations, and diagnoses complex issues. Additionally, the incumbent will prepare, review, and monitor Finance and Audit Committee reports, monthly and ad hoc reports, and coordinate materials for meetings with Executive Management, the Authority Board, staff, and stakeholders. You will find additional information about the job in the Duty Statement. Special Requirements A Statement of Qualifications (SOQ) is required for this position. An SOQ is a narrative that describes your qualifications for this position. The SOQ must be no more than two (2) pages and organized and numbered as reflected below. You must respond to all the following items. Applicants who do not follow these requirements may be disqualified from the hiring process. 1. Describe your level of proficiency with complex formulas, pivot tables, charts, graphs, macros, and data queries in Microsoft Excel. Please include examples of how you have applied these skills in prior roles and explain how your work improved outcomes or solved a problem. 2. Provide examples of your experience conducting contract billing reviews, expenditure and budget tracking, and financial data analysis. What metrics did you use to evaluate invoices, and how did you ensure adherence to internal controls and organizational standards. Applications received without the SOQ may be considered. Resumes, letters, and other materials will not be considered in the place of the SOQ. Artificial intelligence (AI) tools such as ChatGPT, website searches, and third-party reviewers can be helpful in researching responses to the SOQ; however, by submitting your application for this position, you understand and acknowledge the SOQ you submit is your own work, in your own words, and accurately reflects your knowledge, skills, abilities, and experiences. Submitting an SOQ that is not your own may be cause for disqualification from the hiring process. For assistance in completing the SOQ, please reach out to the Human Resources contact below. Desirable Qualifications In addition to evaluating each candidate's relative ability, as demonstrated by quality and breadth of experience, the following factors will provide the basis for competitively evaluating each candidate: • Experience with financial and/or performance reporting.• Experience presenting analytical information verbally and in writing to a variety of audiences. • Skilled in performing accurate data entry, conducting analytical reviews, and validating data integrity.• Experience creating and analyzing data sets and dashboards utilizing Power BI, Power Query or similar tools and/or software.• Experience evaluating and conducting research regarding invoices and expenditure data.• Experience reviewing contract billing, conducting expenditure data analysis, expenditure and budget tracking, and comprehensive research.• Experience identifying data gaps, suggesting process improvements, developing analytical tools, and refining reporting methods.• Proficient with the Microsoft Office suite. (Word, Outlook, PowerPoint, Visio, etc.)• High level of proficiency with complex formulas, pivot tables, charts, graphs, and queries in MS Excel.• Experience working cooperatively and collaboratively in a team setting, with stakeholders, governmental agencies, and the public.• Excellent attendance.• Excellent written and verbal communication skills