Job Description
BI Analyst / Senior Consultant – Business Intelligence & AI
Job Title
BI Analyst / Senior Consultant – BI & AI
Experience
6–9 Years
Location
Hybrid / Remote
Job Summary
We are seeking an experienced BI Analyst / Senior Consultant with 6–9 years of hands-on expertise in business intelligence, advanced analytics, and data engineering — combined with growing exposure to AI/LLM application development. The ideal candidate brings strong proficiency in SQL, Python, and PySpark for data processing, alongside deep BI platform expertise in Power BI or Tableau. They will have experience building governed semantic layers, developing scalable data pipelines, and integrating Large Language Model (LLM) capabilities into analytics workflows. This role sits at the intersection of traditional BI and next-generation AI-augmented analytics, making it ideal for a technically solid consultant ready to lead complex data initiatives.
Key Responsibilities
Data Engineering & Pipeline Development
• Write complex SQL queries, stored procedures,
and optimized transformations across platforms such as Snowflake, Azure Synapse, BigQuery, or Redshift.
• Develop and maintain scalable data pipelines using Python and PySpark for large-scale batch and near-real-time data processing.
• Build and manage ELT/ETL workflows using dbt, ADF, Airflow, or Fivetran to ingest structured and semi-structured data.
• Implement Spark-based data processing on Databricks or Azure HDInsight for high-volume analytics workloads.
• Optimize query performance through partitioning, clustering, caching strategies, and execution plan analysis.
BI Development & Reporting
• Design, develop, and deploy enterprise-grade dashboards and reports using Power BI (DAX, Power Query, Composite Models) and Tableau.
• Build semantic models, calculated measures, KPI frameworks, and row-level security (RLS) configurations in Power BI or Looker.
• Develop LookML models, explores, and views in Looker to expose
📌 Associate - Business Analyst (Pune)
🏢 EXL
📍 Pune