Dear Team,
Below attached is the JD for Report Developer for Awesome Analytics.
Interview Process:
- Post CV Screening Ashwini will provide a time slot to connect your candidate for a con call
- Post her short listing, candidate’s profile will be shared with the client
- Feedback TAT – 8 Working days
Please find the questionnaire.
Questionnaire
· Report Developer
o Why do you want to quit your current organisation?
o Which is the latest Excel version used by you?
o Have you created macros/vba code from scratch (not record macros).
o Have you created UDF using vba/.net language for excel.
o What is the largest data size you have handled (answer in number of rows)?
o Have you worked on Power BI Desktop. Power BI services / Power BI Gateway / Power BI Report Server
o Have you worked with DAX.
o Have you worked on ETL tools like Alteryx, Knime,SQL etc
o Which sectors did you make your dashboards for (eg: finance, marketing, supply chain, internal management)
o Which stakeholders used the dashboards that you created completely from scratch?
o Have you interacted directly with clients in your earlier roles.
o What was your toughest dashboard/report so far?
o Current CTC? Expected CTC? Notice Period?
o For Remote joining, candidate must have a system + internet connection
o Knowledge of Python / R ?
o Exposure to MSBI or Power Pivot – DAX functions (Power BI)
o Non Excel Automation Like – UI Path / Automation Anywhere / AutoHotKey
o Any .NET programming language Like C# will be an added advantage.
Sr. No. | Candidate Name | Location | Total Experience | Relevant Experience | Current Company | Current Designation | Current CTC | Expected CTC | Notice Period | Reasons To Quit | Communication Skills on the scale of 10 | Domain Knowledge on the scale of 10 | |
|
|
|
|
|
|
|
|
|
| Previous Company 1 |
|
|
|
|
|
|
|
|
|
|
|
|
| Previous Company 2 |
|
|
|
|
|
|
|
|
|
|
|
|
| Previous Company 3 |
|
|
|
|
|
|
|
|
|
|
|
|
| Previous Company 4 |
|
|
|
|
|
|
|
|
|
|
|
|
| Previous Company 5 |
|
|
|
Company Website www.awesomeanalytics.in |
|
Awesome Analytics is a team of goal oriented and highly driven professionals helping businesses with their |
data analysis, data transformation & report automation needs. We leverage technology to assist businesses to derive |
insights that assist in business decision making. |
Job Code | JC/2263 |
Process | IT |
Gender | Male/Female |
No. of Positions | 2 |
About Process | Using Excel and Power Bl to independently develop reports and automation |
Design data models and develop Dashboards | |
Automating various processes and reports using macros & ETL tools | |
Staying up-t o-date on the latest IT advancements to automate and modernize systems. | |
Be the go-to person on a subject/area for internal teams | |
Participate in developing case studies. | |
Title | Report Developer |
Location | Mumbai (Thane West) |
Requirement | Knowledge of Python / R |
Power Bl Service/ Power Bl Gateway/ Power Bl Report Server | |
Exposure to MSBI OR Power Pivot - DAX functions (Power Bl) | |
Non Excel Automation like - UI Path/ Automation Anywhere/ AutoHotKey | |
Any .Net programming language like C# will be an added advantage | |
Minimum 2 year's RELEVANT experience in preparing MIS or data analysis | |
for various clients. | |
Thorough knowledge of Advanced Excel - Formula & Features | |
Hands-on experience of VBA / Macros in Excel or entire MS Office | |
Hands on experience of SQL and SSIS OR Power Query (Advanced) | |
Knowledge of Power Bl (basic) | |
Analytical mindset | |
Education | Graduate in Finance or MBA in finance |
Or any one from Engineering background who has handled data and made such reports | |
Shift timings | 10.00 AM to 7.00 PM |
Transport Boundaries | Target candidates from nearby location |
Transport Facility | No Pick up/ No Drop |
Salary Range | 3,60,000 LPA- 5,40,000 LPA |
Weekly Off | Saturday-Sunday Fixed Off |
Age | 25 Years to 31 Years |
USP | Day Shift, weekly off and good growth |
| Candidate's resume + Questionnaire |
Rounds of Interview | Candidate to submit the Excel test on the given link - https://www.awesomeanalytics.in/excel-test/ |
If a candidate passes the online test, we will arrange a practical test for Excel & power Bi. | |
Final Ops Interview round | |
Documents | Educational + Identity Proof + Residential Proof + Salary Proof (Bank Statement/Payslip) + Relieving documents |
Clawback | 90 days |
Comments
Post a Comment