Job description For Data Analyst
We are looking for Strong analytical, logic and troubleshooting skilled person. Typical requirements include processing, cleansing, and verifying the integrity of data used for analysis, analyzing large data sets, and delivering insights.
Key responsibilities will include (but not be limited to):
1. Identifying process improvements and automation possibilities in existing projects, both client-facing and internal
2. Use Advanced Excel capabilities, including pivot tables, lookups, complex formulas and graphing to streamline business processes
3. Analyze complex data to develop automated reporting using VBA and Excel
4. Write macros to work with a huge amount of data and for Excel reports
5. Use Power Query to create report from multiple excel sheet.
6. Use Tableau to create report.
Qualifications and credentials:
1. Bachelors degree in computer science, statistics, or related field
2. Advanced Excel skills for managing large datasets with functions such as: IF, SUM, SUMIF, INDEX, INDEXMATCH, MATCH, VLOOKUP
3. Manipulating data with complex Excel and VBA
4. Able to code difficult functions/macros using VBA
5. Task automation and building charts and graphs
6. Must possess problem solving skills and should be proactive in researching solutions
7. Strong analytical, logic and troubleshooting skills
Technical Skills:
1. Excel
2. Power Query
3. VBA
4. Macros
5. Tableau
