Senior Data Analyst
Summary
Office-based Senior Data Analyst in Knoxville, TN who aggregates and analyzes business data, builds and maintains databases, and prepares reports and dashboards for leadership, including financial reporting alongside the accounting team. Core tools include Excel (pivot tables, conditional formulas), SQL, Business Objects, and ETL/programming such as XML and JavaScript.
The Data Analyst is responsible for aggregating and analyzing data, building and maintaining databases, as well as preparing reports supporting the current business needs.
Responsibilities Include:
- Create and maintain reports supporting current business needs
- Acquire data from primary or secondary data sources and build and maintain databases/data systems
- Analyze data using Microsoft Excel functionality such as Pivot Tables, Conditional Formulas and Data Tables
- Report on financial performance and prepare for regular leadership reviews
- Identify, analyze, and interpret trends or patterns in complex data sets
- Work closely with the accounting team to ensure accurate financial reporting
- Identify and drive process improvements, including the creation of standard and ad-hoc reports, tools, and dashboards
- Develop a working knowledge of existing sources of business data
- Maintain computer databases in accordance with vendor specifications and industry standards
- Assist with migration of data between computer databases
Requirements:
- Bachelor’s degree in Finance, Information Management, Mathematics, Economics, or related field required
- Proven working experience as a Data Analyst or Business Data Analyst
- Ability to clearly express oneself verbally and in writing
- Strong knowledge of and experience with reporting packages (Business Objects etc), databases (SQL etc), programming (XML, Javascript, or ETL frameworks)
- Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
- Self-starter with a strong desire to drive business value
- High intellectual curiosity
- Experience working with Microsoft Excel to aggregate and analyze large datasets
- Experience structuring and executing analysis regarding business and financial issues using tools such as variance analysis, trend analysis and regression analysis
Work Conditions:
The work conditions described here are representative of those that must be met by and employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the job.
- Ability to talk and hear
- The position is office-based and requires sitting, typing and talking face to face and by phone.
- Ability to reach and extend hand(s) and arm(s) in different directions.
- Ability to view, prepare and analyze data and information on a computer screen
- Ability to work on repetitive task
- The position requires the employee to communicate regularly by speaking and listening
- Use of hands to finger, handle or feel, reach with hands and arms.
- Frequently bend to file and maintain files
- Occasionally lifting and or moving items up to 5 - 10 pounds