Automation Technician - IT (Advance Excel)

Key Responsibilities

• Prepare, maintain, and automate daily, weekly, and monthly MIS reports.
• Work with large datasets and perform data cleaning, sorting, filtering, and analysis.
• Use advanced Excel formulas to automate calculations and reporting activities.
• Develop automated Excel reports using logical and lookup functions.
• Create interactive reports and summaries using Pivot Tables.
• Apply Data Validation and Conditional Formatting to maintain data accuracy.
• Identify repetitive manual tasks and suggest Excel-based automation solutions.
• Maintain employee, operational, attendance, and performance-related reports.
• Ensure accuracy, consistency, and timely delivery of reports.
• Coordinate with different departments to collect, verify, and consolidate data.

Required Technical Skills

1. Logical Functions

• IF
• Nested IF
• AND and OR
• COUNTIF and COUNTIFS

2. Lookup Functions

• VLOOKUP
• HLOOKUP

3. Mathematical and Statistical Functions

• SUM
• SUMIF
• AVERAGE
• AVERAGEIF
• COUNT
• COUNTA

4. Data Management

• Data Validation
• Conditional Formatting
• Sorting and Filtering
• Duplicate Identification and Removal
• Data Cleaning and Formatting

5. Pivot Tables and Reporting

• Creating and managing Pivot Tables
• Department-wise and employee-wise reports
• Summary reports and data analysis
• Report formatting and presentation

6. Cell References

• Relative References (A1)
• Absolute References ($A$1)
• Mixed References ($A1 and A$1)

Desired Candidate Profile

• Strong working knowledge of Microsoft Excel.
• Good analytical and problem-solving skills.
• Ability to handle large volumes of data.
• Good attention to detail and accuracy.
• Ability to automate repetitive reporting tasks.
• Good communication and coordination skills.

Preferred Skills (Additional Advantage)

• Basic knowledge of Power Query.
• Basic knowledge of Power BI.
• Basic VBA and Macro knowledge.

Basic understanding of IT operations and process automation.

Pay: ₹15,000.00 - ₹25,000.00 per month

Benefits:

• Provident Fund

Application Question(s):

• Immediate Joiner
• Pls read JD carefully before applying for this Post
• WEST DELHI NEARBY

Education:

• Bachelor's (Required)

Experience:

• Advance Excel: 1 year (Required)

Work Location: In person