Senior Consultant- Business Intelligence

Job Level:  Professional
Location: 

Trivandrum, KL, IN, 695581

Area of Expertise:  Operations
Unit:  Allianz Services
Employing Entity:  Allianz Services Private Limited (ASPL)
Job Type:  Full-Time
Remote Job:  Hybrid working
Employment Type:  Permanent
ID:  110321
Position Cluster:  Non-Executive

130 years of trust. One team shaping what's next. Allianz Group is one of the world's leading insurers and asset managers - built on over a century of stability, expertise, and financial strength. Allianz Services is where that legacy meets the future. 8,500+ people. Twelve countries. Four continents. We deliver specialized services to clients within Allianz Group, powered by AI, advanced analytics, and a mindset that refuses to stand still. From core insurance operations to engineering and consulting services, we reimagine how insurance works. What truly sets us apart are our people and the trusted partnerships we build, anchored in our values of expertise, integrity, and empowerment. We don't support the business. We shape it.

 

Job Description: Data Analyst

 

We are seeking a motivated Data Analyst with 8 to 10 years of experience, to design data-driven solutions, build interactive dashboards, and develop scoring models. You will leverage Power BI, SQL, and Data warehousing to analyse datasets, uncover trends, and support decision-making. This role requires collaboration with cross-functional teams to translate business needs into actionable insights and predictive scoring systems.

 

•             Data Modelling & SQL Development: Create optimized SQL queries, stored procedures, and data models to support complex reporting and analytics.

•             Tool Governance: Establish best practices for Power BI and MicroStrategy usage, including security, performance tuning, and version control.

•             Performance Optimization: Monitor and enhance BI system performance, including query optimization and data refresh cycles.

•             Certifications: Preferred certifications in Power BI, MicroStrategy, or cloud platforms.

•             Validate data integrity and troubleshoot discrepancies in datasets.

•             Knowledge of data governance and security best practices.

•             Strong analytical and problem-solving skills.

•             Document processes, workflows, and model logic for transparency.

•             Stay updated on industry trends in BI tools, analytics, and machine learning techniques.

•             Advanced SQL skills (complex joins, window functions, query optimization).

•             Strong understanding of data warehousing concepts (star/snowflake models, ETL/ELT).

•             Knowledge of data governance, metadata management, and compliance (GDPR, CCPA).

•             Familiarity with Agile methodologies and DevOps practices for BI deployments, hands-on experience with Power BI (DAX, data modeling) and SQL (joins, subqueries, optimization).

•             Basic understanding of statistical methods, data visualization, and scoring model frameworks.

•             Strong analytical skills with the ability to translate data into business insights.

 

Mandatory Skills:

 

  • Minimum 8 to 10 years of experience in Data Analysis.
  • Strong expertise in Power Bi & SQL.
  • Prior experience in developing interactive and user-friendly dashboards.
  • Cross functional collaboration with Data Engineers, Analysts and Business Leaders.
  • Experience with ETL processes and data integration.

 

Good-to-have Skills:

 

  • Prior experience in mentoring & guiding junior Analysts.
  • Familiarity with cloud platforms such as MS Azure & Snowflake.
  • Familiarity with DAX (Data Analysis Expressions) and Power Query.
  • Experience integrating BI tools with cloud platforms (Azure, AWS, GCP) is a plus.

 

Disclaimer: At Allianz Services, we believe in fostering an inclusive workplace and in giving fair and equitable opportunities to all our employees, so everyone can succeed. We, the Allianz Services India community, welcome applications from all regardless of gender identity and/or expression, sexual orientation, race or ethnicity, age, nationality, religion, disability, or philosophy of life.

 

110321 | Operations | Professional | Non-Executive | Allianz Services | Full-Time | Permanent

Allianz Group is one of the most trusted insurance and asset management companies in the world. Caring for our employees, their ambitions, dreams and challenges, is what makes us a unique employer. Together we can build an environment where everyone feels empowered and has the confidence to explore, to grow and to shape a better future for our customers and the world around us. 

 

At Allianz, we stand for unity: we believe that a united world is a more prosperous world, and we are dedicated to consistently advocating for equal opportunities for all. And the foundation for this is our inclusive workplace, where people and performance both matter, and nurtures a culture grounded in integrity, fairness, inclusion and trust. 

 

We therefore welcome applications regardless of ethnicity or cultural background, age, gender, nationality, religion, social class, disability or sexual orientation, or any other characteristics protected under applicable local laws and regulations. 

 

Great to have you on board. Let's care for tomorrow.