Business Intelligence Analyst II {Excel Specialist}

3 - 6 years

4 - 9 Lacs

Posted:3 weeks ago| Platform: Naukri logo

Apply

Work Mode

Hybrid

Job Type

Full Time

Job Description

We are looking for a highly proficient Excel Developer with over 4 years of experience in advanced Excel development, data modeling, automation using VBA/macros, and dynamic reporting. The ideal candidate will be responsible for designing and maintaining robust Excel-based reporting solutions, transforming raw data into meaningful insights for business users. Exposure to Power BI and basic data visualization tools is a plus, but Excel will be the primary focus of this role. Key Responsibilities: Design, develop, and maintain advanced Excel-based dashboards and analytical tools. Use Power Query, PivotTables, Power Pivot , and formulas (e.g., INDEX-MATCH, SUMIFS, array formulas) for data transformation and reporting. Develop automation tools and workflows using VBA and Macros to streamline data processing. Collaborate with stakeholders to gather reporting requirements and deliver customized Excel reports. Ensure accuracy, consistency, and data integrity across all reports and templates. Conduct regular data audits and troubleshoot data issues within Excel models. Provide training and support to users on advanced Excel features and tools. Maintain version control and documentation for all developed solutions. Optimize large Excel workbooks for performance and scalability. Required Skills & Qualifications: Bachelors degree in Computer Science, Information Systems, Data Analytics, or a related field. 4+ years of hands-on experience in Microsoft Excel at an advanced level . Strong command of: Power Query Power Pivot PivotTables Advanced formulas and conditional formatting VBA and Excel Macros Ability to handle and manipulate large datasets in Excel efficiently. Basic exposure to Power BI and an understanding of DAX is a plus. Knowledge of SQL is a bonus. Strong problem-solving skills and attention to detail. Excellent verbal and written communication skills. Ability to work independently and manage multiple projects under tight deadlines. Preferred Qualifications: Microsoft Excel Certification or similar credentials. Experience with cloud-based Excel integrations (e.g., SharePoint, OneDrive). Experience working in cross-functional teams with business users and IT teams.

Mock Interview

Practice Video Interview with JobPe AI

Start Advanced Excel Interview Now

My Connections Conduent

Download Chrome Extension (See your connection in the Conduent )

chrome image
Download Now
Conduent
Conduent

IT Services and IT Consulting

Florham Park New Jersey

10001 Employees

614 Jobs

    Key People

  • Cheryl Campbell

    Chief Operating Officer
  • Claudia S. C. A. H. Cortes

    Chief Financial Officer

RecommendedJobs for You

Kolkata, Mumbai, New Delhi, Hyderabad, Pune, Chennai, Bengaluru

Kolkata, Mumbai, New Delhi, Hyderabad, Pune, Chennai, Bengaluru