Data Analyst with Advanced Excel (Macros) and Power BI skillset - MUMBAI BASED FREELANCERS ONLY
Budget: ₹12,500 – ₹37,500 INR
DATA ANALYST
1. Essential Job Functions
A. Collate data (manually in MS-Excel format) from various departments/ agencies in offline mode.
B. Create a database with data points from the knowledge repository of previous editions/ years.
C. Online integration of various geographically dispersed nodes (presently in stand-alone mode) to ensure seamless connectivity and flow of information/ data on a real-time basis, with a good user interface.
D. Create dashboards using Power BI tools for analysis of current and historic data points and visual representation of key statistics and analyses per client requirements.
E. Create customizable codes using advanced Excel macros for further and continuous refinement/ improvement of the model structure in the future as well.
F. Accomplish and present fortnightly performance of projects/processes, project plans, vital factors, and goals to the reporting manager.
G. Ensure client deadlines are communicated and met.
H. Work closely with clients to ensure their needs and expectations are met.
I. Respond to client concerns, issues, and complaints, and proactively solicit their feedback.
J. To adhere to the organization’s Information security policies and procedures, such as the Acceptable Use Policy.
2. Qualifications/ Requirements
A. Any graduate, diploma, or postgraduate in Data Science.
B. Prior experience as a Data Analyst and above (Min 2+ years in handling real-world data and analysis).
C. Proficient in Power BI, Advanced MS-Excel (including Macros), and MS-Outlook functions.
D. Ability to assess, modify, and create new processes, procedures, and controls.
E. Ability to gather, research, compare, and analyze complex data and develop a clear, logical interpretation and application.
F. Superior verbal communication skills for client-facing interactions.
G. Self-motivated with the initiative to research, question, and apply information.
H. Independently organizes, tracks, and prioritizes assigned work, including managing client requests effectively and within acceptable timelines.
3. Location – Mumbai
4. Job Type – On-Site (2 months contract convertible to long term, basis the quality of service delivery)
5. The remuneration range quoted is per month.
1. Essential Job Functions
A. Collate data (manually in MS-Excel format) from various departments/ agencies in offline mode.
B. Create a database with data points from the knowledge repository of previous editions/ years.
C. Online integration of various geographically dispersed nodes (presently in stand-alone mode) to ensure seamless connectivity and flow of information/ data on a real-time basis, with a good user interface.
D. Create dashboards using Power BI tools for analysis of current and historic data points and visual representation of key statistics and analyses per client requirements.
E. Create customizable codes using advanced Excel macros for further and continuous refinement/ improvement of the model structure in the future as well.
F. Accomplish and present fortnightly performance of projects/processes, project plans, vital factors, and goals to the reporting manager.
G. Ensure client deadlines are communicated and met.
H. Work closely with clients to ensure their needs and expectations are met.
I. Respond to client concerns, issues, and complaints, and proactively solicit their feedback.
J. To adhere to the organization’s Information security policies and procedures, such as the Acceptable Use Policy.
2. Qualifications/ Requirements
A. Any graduate, diploma, or postgraduate in Data Science.
B. Prior experience as a Data Analyst and above (Min 2+ years in handling real-world data and analysis).
C. Proficient in Power BI, Advanced MS-Excel (including Macros), and MS-Outlook functions.
D. Ability to assess, modify, and create new processes, procedures, and controls.
E. Ability to gather, research, compare, and analyze complex data and develop a clear, logical interpretation and application.
F. Superior verbal communication skills for client-facing interactions.
G. Self-motivated with the initiative to research, question, and apply information.
H. Independently organizes, tracks, and prioritizes assigned work, including managing client requests effectively and within acceptable timelines.
3. Location – Mumbai
4. Job Type – On-Site (2 months contract convertible to long term, basis the quality of service delivery)
5. The remuneration range quoted is per month.