Executive-Data Analyst

Location: Bangalore, Gurugram, Mumbai, Chennai, Pune, Jaipur

Experience: 3 - 5 Years

Position: Executive / Senior Executive

About Us

The Audit Innovation Centre (AIC) is a premier hub offering cutting-edge Data & Analytics services to over 2000 clients across India. We specialize in delivering solutions like General Ledger and Sub-ledger Analytics, driving audit efficiency, mitigating risk, and enhancing client value. Our strength lies in our diverse team of Chartered Accountants, Techno-functional experts, and ERP & ETL specialists, fostering a collaborative environment for continuous learning and exceptional service delivery.

The Opportunity

We are seeking a highly motivated Data & Analytics professional to join our dynamic team. In this role, you will be at the forefront of audit innovation, leveraging advanced tools to develop automated solutions, improve audit quality, and provide deep insights from client data. This position offers significant exposure to a variety of technologies and client engagements, paving the way for substantial career growth and progression within the organization.

Key Responsibilities

Design, develop, and maintain efficient and robust Alteryx workflows for data extraction, transformation, and analysis.

Create insightful and interactive Power BI dashboards for data visualization and storytelling, enabling audit teams to make data-driven decisions.

Write complex T-SQL queries for data manipulation, validation, and analysis within client databases.

Collaborate with audit teams to understand their requirements and translate them into effective D&A solutions, particularly in General Ledger and Sub-ledger analytics.

Extract and transform data from leading ERP systems (e.g., SAP, Oracle, MS Dynamics, Navision).

Develop and maintain advanced data models and entity relationship diagrams.

Utilize strong analytical skills to identify patterns, anomalies, and insights within large datasets.

Present findings and demonstrate developed solutions to internal teams and clients with clarity and confidence.

Required Skills and Qualifications

Must-Have:

3-5 years of hands-on experience in Data & Analytics, preferably within an audit or finance context.

Technical Proficiency: Proven expertise in:

Alteryx: Advanced workflow development.

Power BI: Advanced dashboard development, including proficiency in DAX, Power Query, and data modeling.

T-SQL: Writing and optimizing complex queries.

Advanced knowledge of MS Excel (pivot tables, complex formulas, macros).

Experience with data extraction from ERPs (SAP, Oracle, MS Dynamics, Navision, etc.).

Strong analytical, problem-solving, and critical thinking skills.

Excellent verbal and written communication and presentation skills.

Good to Have (Highly Desirable):

Experience with the Microsoft Azure data ecosystem, including Azure Data bricks.

Programming skills in Python for data analysis and automation.

Formal certification in Alteryx, Power BI, or related technologies.

Understanding of audit processes and standards.

What We Offer

A chance to work with a vast network of over 2000 clients on challenging projects.

An environment that fosters innovation and continuous learning with exposure to a suite of advanced analytics tools.

Opportunities for professional development and clear career progression paths.

A collaborative culture that values diversity of thought and expertise.

Job Type: Full-time

Pay: ₹377, ₹800,000.00 per year

Experience:

• Alteryx: 2 years (Required)

Work Location: In person