Business Intelligence Analyst II {Excel Specialist}
- Conduent
- 3 - 6 years
- Bengaluru
- 3 months ago
- Email to a friend
- Report this job
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.
Job Classification
Industry: BPM / BPOFunctional Area / Department: Data Science & AnalyticsRole Category: Business Intelligence & AnalyticsRole: Business Intelligence & Analytics - OtherEmployement Type: Full timeContact Details:
Company: ConduentLocation(s): Bengaluru
Keyskills: Advanced Excel Power Query Pivot Table Pivot Chart Power Pivot Data Validation Power Bi Conditional Formatting SQL Server Macros SQL VBA Azure Cloud Microsoft Data Modeling ETL Sharepoint Stakeholder Management
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in