Description:
Data analyst prepares financial reports that serve as summary information for managers. The financial data analyst is responsible for identifying relevant insights and compiling analytical reports that enable other employees in the company to make sound decisions.
Responsibilities:
- Consolidation of data from different data sources using Microsoft Excel power query and Excel VBA.
- Creating new dashboards in Tableau as per the Business requirement.
- Maintenance of existing dashboards in Tableau.
- Recon of data and delivering 100% accurate reporting.
- Validation and data accuracy check on all the financial reports.
- Liaise with multiple departments on Automation of reporting and elimination of manual work.
- Follow-up with the multiple teams in data procurement via email and calls
Technical knowledge required:
- Expert knowledge in Microsoft Excel
- Text functions - upper, lower, proper, concatenate, trim, left, right, mid, Find, value, char, exact, len, replace, search, substitute
- Math functions - ABS, Sum, Average, Max, Min, Count, CountA, Countblank, countif, countifs, round, round down, roundup, sumif, sumifs, sumproduct, Subtotal
- Date Functions - Date, Datevalue, Day, Days360, Edate, Eomonth, Hour, Minute, Month, Networkdays, Now, Second, Time, Timevalue, Today, Weekday, Weeknum, Workday, Year, Yearfrac
- Lookup Functions – Xlookup, Vlookup, Hlookup, Column, Columns, Hyperlink, Index, Indirect, Match, Offset, Row, Rows
- Information Functions - Cell, Error.Type, Info, Isblank, Iserr, Iserror, Iseven, Islogical, Isna, Isnontext, Isnumber, Isodd, Isref, Istext, N, Na, Type
- Logical Functions -And, False, If, Iferror, Not, Or, True
- Charts
- Clustered Column, Stacked column, 100% Stacked column
- Combined Column and Line Charts
- Pie Charts – Exploded Pie, Pie of Pie, Bar of Pie
- Area charts – Stacked Area, 100% Stacked Area
- Gantt chart
- Bubble chart
- Waterfall chart
- Power Query and Power Pivot
- Data validation, what if analysis (Goal seek)
- Conditional formatting
- Expert knowledge in Microsoft Excel VBA
- Consolidation of worksheets
- If...End If Decision Structures
- For...To...Next Structure
- For Each...Next Structure
- Declaring and Using Object Variables
- Filesystem Object
- Expert knowledge in Tableau
- Tableau prep builder
- SQL
- Creation of worksheets, dashboard, storyline
Qualifications:
- Minimum Bachelor’s Degree graduate in specialization in Finance area is preferred
- 3 years + related experience, with significant time spent in healthcare would be advantageous.