Entry Level Excel Data Analyst Jobs in Lexington, KY

As a Data Analyst in the Finance Data Analytics department, you will be responsible for maintaining, improving, and building new reporting capabilities for cross-functional areas of the business. By developing a deep understanding of operational processes and needs, you will be responsible for implementing new reporting capabilities and using technology to deliver impactful reports. You will partner with teams in various functional areas of the business to implement process improvements that will streamline the efficiency and accuracy of the reporting process. You will be responsible to delivering daily, weekly, and monthly reports accurately and on time. You will also be involved in ad hoc analysis of large datasets to quickly provide insight into the business.

Functional Support Area: Procurement/Accounts Payable/Accounts Receivable/Support Services

Core Responsibilities

• Function as an analytics and reporting expert for assigned functions by executing standard reports and, running / maintaining ad hoc queries.
• Participate in the development of reports, metrics, models, scorecards, and dashboards by gathering data and transforming it into stories and insights that drive business recommendations and decision-making.
• Publish daily, weekly, and monthly reports accurately and on time
• Build reports and dashboards in Microsoft Power BI, Analysis for Office, Bex, and other reporting tools
• Participate in hosted training sessions on how to use the various tools and reports created by the department
• Generate load files for various systems, maintaining system accuracy
• Communicate effectively with report stakeholders to ensure strong understanding of the methodology behind all calculations
• Perform ad hoc analysis using data from various systems and explain results of analysis to all levels of management
• Create SOPs and maintain documentation for processes
• Demonstrate continuous efforts to improve processes, increase data integrity, and provide quality customer service to our business partners.
• Provide comprehensive analytical and fact-based reporting to support and/or identify opportunities to impact operational results, make changes to processes, and support strategic initiatives.

The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. May perform other duties as assigned.

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals to perform the essential functions .

• Bachelor's Degree from a regionally accredited four-year college or university in Accounting/Finance, Computer Science/Data Analytics or related field and 2+ years of relevant work experience or equivalent combination of education and/or experience, required.
• Ability to build models using advanced features of Excel.
• Experience with Power BI / Tableau, Power Pivot, SAP, SAP Analysis for Office, BPC, Bex Query Designer.
• Experience in analyzing data within relational database systems such as MS Access, MS SQL Server, and MySQL.
• Experience with ETL Tools such as Alteryx, Paxata, DataGuru or equivalent technologies, preferred.
• Understanding of Windows environment command line tools, .BAT files, and Task Scheduler, preferred.
• Experience with HTML/CSS/Javascript and a backend technology like python-flask, preferred.
• Experience with Data analysis in Python using Pandas/Numpy/Jupyter Notebooks, preferred.
• Ability to quickly learn new technology and business logic.
• Superior analytical and problem-solving skills with superb attention to detail.
• Strong written and verbal communication skills.
• Ability to work independently in a fast-paced and rapidly changing and ambiguous environment.
• Ability to work well with others in fast paced, dynamic environment.
• Ability to be respectful, approachable and team oriented while building strong working relationships and a positive work environment.
• Up to 10% travel required.