Data Analyst (Finance) Career

Planning and Analysis

 
Planning and Analysis Careers | Data Analyst (Finance)

Data Analyst (Finance)

Career Area: Planning and Analysis

Occupation Group: Data Analysis and Mathematics

Salary

Percentile wages tell how much a certain percentage of an overall population in a geographic area or within a given industry or field makes. The percentile wage estimate is the value of a wage below which a certain percent of workers fall.

An example would be the 25th percentile, 25 percent of workers employed in that occupation earn less and 75 percent earn more than the estimated wage value. At the 75th percentile, 75 percent of workers employed in that occupation earn less and 25 percent earn more than the estimated wage value.

A typical Data Analyst (Finance) earns the following wages (national and state):

State

The average salary in North Carolina for those pursuing this career is $85,620

*The salaries depicted here are representative of the range of salaries posted in job listings over the past year. Living wage in North Carolina is $30,000.

National

The average salary in the United States for those pursuing this career is $81,237

*The salaries depicted here are representative of the range of salaries posted in job listings over the past year. Living wage in North Carolina is $30,000.

What Does a Professional in this Career Do?

Analyzes financial data and prepares financial reports for management. Responsible for identifying relevant insights and compiling analytical reports that enable other employees in the organization to make sound decisions. May include analysis of prices of key financial instruments, or forecasts based upon financial trends.

Employment Trends

The job demand and job growth statistics shown here were derived from job posts over the past year. Expected job growth projections are extrapolated from year-over-year job post listing history.

Job demand and job growth is expected at the following rates:

Growth
North Carolina649+11.4%
Nationwide7829+9.3%

Skills

A professional in this position typically utilizes the following skills in the course of everyday work in this exciting and challenging field:

Baseline Skills

The following are baseline skills every Data Analyst (Finance) is expected to have in order to experience success in this field:

  • Communication Skills: The ability to convey information to another effectively and efficiently.
  • Microsoft Excel: Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
  • Research: Experience performing creative and systematic work to understand a product, market, or customer, either before building a new solution, or to troubleshoot an existing issue
  • Problem Solving: Problem solving consists of using generic or ad hoc methods, in an orderly manner, for finding solutions to problems.
  • Teamwork / Collaboration: Experience working in collaborative efforts with a team to achieve a common goal or to complete a task in the most effective and efficient way.

Specialized Skills

These skills are specific to working in this career:

  • Data Analysis: Data analysis, also known as analysis of data or data analytics, is a process of inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information, suggesting conclusions, and supporting decision-making.
  • SQL: SQL ( ESS-kew-EL or SEE-kwl, Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).
  • Python: Python is a widely used high-level programming language for general-purpose programming, created by Guido van Rossum and first released in 1991.
  • Financial Analysis: Financial statement analysis (or financial analysis) is the process of reviewing and analyzing a company's financial statements to make better economic decisions.
  • Tableau: Tableau Software ( tab-LOH) is a software company headquartered in Seattle, Washington, United States which produces interactive data visualization products focused on business intelligence.

Distinguishing Skills

Any Data Analyst (Finance) that possesses the following skills will stand out against the competition:

  • Data Governance: Working experience of Data Governance, which is the data management of all the data which an organization has to ensure that high data quality exists throughout the complete lifecycle of the data. The key focus areas of data governance include availability, usability, consistency, data integrity and data security and includes establishing processes to ensure effective data management throughout the enterprise such as accountability for the adverse effects of poor data quality and ensuring that the data which an enterprise has can be used by the entire organization.
  • Visual Basic for Applications (VBA): Visual Basic for Applications (VBA) is an implementation of Microsoft's event-driven programming language Visual Basic 6, which was discontinued in 2008, and its associated integrated development environment (IDE).
  • Database Design: Working experience organizing data according to specific database models. Determining what data must be stored and how the data elements interrelate.
  • Fixed Income: Working experience of Fixed Income, which is a type of investment in which real return rates or periodic income is received at regular intervals and at reasonably predictable levels. Fixed-income investments can be used to diversify one's portfolio, as they pose less risk than equities and derivative investments.
  • Predictive Models: Predictive modeling uses statistics to predict outcomes.

Education

This career typically requires the following level of education. The numbers presented in the pie charts below were derived from actual job posts over the past year. Not all job postings list education requirements.

.
Education Level%
Bachelor's Degree58%
Master's Degree41%
Doctoral Degree1%

Experience

This position typically requires the following level of experience. The numbers presented in the pie charts below were derived from actual job posts over the past year. Not all job postings list experience requirements.

Experience Required%
0 to 2 years27%
3 to 5 years48%
6 to 8 years19%

Many of the programs offered through NC State are designed for working professionals who need additional credentials to enhance existing work experience.

Students who do not have the expected level of experience may wish to look into internship and employment opportunities.

Common Job Titles

It is possible to find work in this field in positions commonly listed as the following job titles:

  • Data Analyst
  • Senior Data Analyst
  • Quantitative Analyst
  • Database Analyst
  • Analytics Consultant

Similar Occupations

If you are interested in exploring similar occupations, you may want to research the following job titles:

Not sure where to start?

Get personalized program recommendations with Career Insight.

Go to Career Insight