City of Atlanta, GA
Airport Financial Analyst, Sr. - Financial Planning & Analysis
City of Atlanta, GA, College Park, Georgia, United States,
Job Description
Salary range: $72,682-$90,839
Posting expires: December 4, 2024
The Financial Analyst, Sr. - Financial Planning & Analysis will assist with the maintenance and development of the Airport's Long Range Financial Planning model, annual trending, benchmarking and metrics reporting, financial analysis, operational analysis, financial modeling, data collection and maintenance and other ad-hoc analysis and reporting projects.
The person in this role will be a meticulous, results-oriented professional with the ability to acclimate to a fast paced, changing environment, while performing a variety of complex tasks requiring advanced analytic skills and attention to detail. They will be a key player in providing comprehensive, insightful, and accurate financial analysis and reporting useful in informed decision-making.
Supervision Received
Works under general supervision. Depending on organization structure, may work independently with responsibility for an assigned function or program.
Responsibilities
Essential Duties & Responsibilities
These are typical responsibilities for this position and should not be construed as exclusive or all inclusive. May perform other duties as assigned.
• Prepare trending and benchmarking reports and analysis for the Airport.
• Prepare ad-hoc management and analysis reports.
• Perform cash flow reporting, analysis, and projections as necessary.
• Participates in ad-hoc planning and analysis projects.
• Assist with the preparation of financial models used to forecast and report the Airports revenue, expenses, capital expenditures and other key aviation metrics.
• Assist with the maintenance and development of the Airport's long range financial plan (LRFP).
• Assist in the development of a data visualization system.
• Prepare ad-hoc multi-year analysis related to:
o Budgets
o Financial performance
- Budget to actual
- Year over year performance
- Deeper financial trends
- Spend analysis
- Personnel analysis
o Operational performance
Leadership Provided
• This person will not directly supervise employees. However, they may provide work group leadership, guidance, and/or training to peers and/or less experienced staff and serve as a technical resource or mentor to other employees.
Knowledge, Skills & Abilities
Formal Knowledge
• Advanced knowledge of Excel including extensive use of Pivot Tables, data collection and management, Visual Basic, etc.
• Familiarity with a variety of financial reporting, budgeting and forecasting applications.
Skills
The preferred candidate will demonstrate:
• The ability to develop complex financial analysis reports and projects.
• The ability to focus on attention to detail in complex financial models.
• The ability to work successfully and effectively on cross-functional teams and team/collaborative projects.
• Strong problem-solving skills
• Passion for improvement.
• Strong analytical skills.
• Strong reporting skills.
• Logical decision-making processes.
• A high level of organization skills.
• Focus on deadlines.
• Excellent written and verbal communication skills.
Qualifications
Minimum Qualifications
Bachelor's degree in accounting, finance, or related field.
Preferred Education and Experience
• 5 years of work experience with 3+ years of relevant financial analysis and modeling experience
• Advanced analytical and financial model building skills.
• Tableau or Microsoft Power BI experience is preferred.
• Comfortable with large volumes of complex data and presenting their findings to senior management.
• 3+ years of experience in business-decision support, analysis and data-visualization, preferably within a government, aviation or other related industry
Licensures and Certifications
None required
Essential Capabilities and Work Environment
Required physical, lifting, and sensory capabilities are requirements to perform the job successfully. Typical environmental conditions associated with job.
It is the policy of the City of Atlanta ("COA") that qualified individuals with disabilities are not discriminated against because of their disabilities regarding job application procedures, hiring, and other terms and conditions of employment. It is further the policy of the COA to provide reasonable accommodations to qualified individuals with disabilities in all aspects of the employment process. The COA is prepared to modify or adjust the job application process or the job or work environment to make reasonable accommodations to the known physical or mental limitations of the applicant or employee to enable the applicant or employee to be considered for the position he or she desires, to perform the essential functions of the position in question, or to enjoy equal benefits and privileges of employment as are enjoyed by other similarly situated employees without disabilities, unless the accommodation will impose an undue hardship. If reasonable accommodation is needed, please contact the Human Resources Director for your department.
The City of Atlanta is an Equal Opportunity Employer and does not unlawfully discriminate on the basis of race, color, religion, age, disability, sex, sexual orientation, ender identity, marital status, veteran's status or national origin, or any other basis prohibited by federal, state, or local law. We value and encourage diversity in our workforce.
Salary range: $72,682-$90,839
Posting expires: December 4, 2024
The Financial Analyst, Sr. - Financial Planning & Analysis will assist with the maintenance and development of the Airport's Long Range Financial Planning model, annual trending, benchmarking and metrics reporting, financial analysis, operational analysis, financial modeling, data collection and maintenance and other ad-hoc analysis and reporting projects.
The person in this role will be a meticulous, results-oriented professional with the ability to acclimate to a fast paced, changing environment, while performing a variety of complex tasks requiring advanced analytic skills and attention to detail. They will be a key player in providing comprehensive, insightful, and accurate financial analysis and reporting useful in informed decision-making.
Supervision Received
Works under general supervision. Depending on organization structure, may work independently with responsibility for an assigned function or program.
Responsibilities
Essential Duties & Responsibilities
These are typical responsibilities for this position and should not be construed as exclusive or all inclusive. May perform other duties as assigned.
• Prepare trending and benchmarking reports and analysis for the Airport.
• Prepare ad-hoc management and analysis reports.
• Perform cash flow reporting, analysis, and projections as necessary.
• Participates in ad-hoc planning and analysis projects.
• Assist with the preparation of financial models used to forecast and report the Airports revenue, expenses, capital expenditures and other key aviation metrics.
• Assist with the maintenance and development of the Airport's long range financial plan (LRFP).
• Assist in the development of a data visualization system.
• Prepare ad-hoc multi-year analysis related to:
o Budgets
o Financial performance
- Budget to actual
- Year over year performance
- Deeper financial trends
- Spend analysis
- Personnel analysis
o Operational performance
Leadership Provided
• This person will not directly supervise employees. However, they may provide work group leadership, guidance, and/or training to peers and/or less experienced staff and serve as a technical resource or mentor to other employees.
Knowledge, Skills & Abilities
Formal Knowledge
• Advanced knowledge of Excel including extensive use of Pivot Tables, data collection and management, Visual Basic, etc.
• Familiarity with a variety of financial reporting, budgeting and forecasting applications.
Skills
The preferred candidate will demonstrate:
• The ability to develop complex financial analysis reports and projects.
• The ability to focus on attention to detail in complex financial models.
• The ability to work successfully and effectively on cross-functional teams and team/collaborative projects.
• Strong problem-solving skills
• Passion for improvement.
• Strong analytical skills.
• Strong reporting skills.
• Logical decision-making processes.
• A high level of organization skills.
• Focus on deadlines.
• Excellent written and verbal communication skills.
Qualifications
Minimum Qualifications
Bachelor's degree in accounting, finance, or related field.
Preferred Education and Experience
• 5 years of work experience with 3+ years of relevant financial analysis and modeling experience
• Advanced analytical and financial model building skills.
• Tableau or Microsoft Power BI experience is preferred.
• Comfortable with large volumes of complex data and presenting their findings to senior management.
• 3+ years of experience in business-decision support, analysis and data-visualization, preferably within a government, aviation or other related industry
Licensures and Certifications
None required
Essential Capabilities and Work Environment
Required physical, lifting, and sensory capabilities are requirements to perform the job successfully. Typical environmental conditions associated with job.
It is the policy of the City of Atlanta ("COA") that qualified individuals with disabilities are not discriminated against because of their disabilities regarding job application procedures, hiring, and other terms and conditions of employment. It is further the policy of the COA to provide reasonable accommodations to qualified individuals with disabilities in all aspects of the employment process. The COA is prepared to modify or adjust the job application process or the job or work environment to make reasonable accommodations to the known physical or mental limitations of the applicant or employee to enable the applicant or employee to be considered for the position he or she desires, to perform the essential functions of the position in question, or to enjoy equal benefits and privileges of employment as are enjoyed by other similarly situated employees without disabilities, unless the accommodation will impose an undue hardship. If reasonable accommodation is needed, please contact the Human Resources Director for your department.
The City of Atlanta is an Equal Opportunity Employer and does not unlawfully discriminate on the basis of race, color, religion, age, disability, sex, sexual orientation, ender identity, marital status, veteran's status or national origin, or any other basis prohibited by federal, state, or local law. We value and encourage diversity in our workforce.