EXL Service logo

Lead Assistant Manager

EXL Service

2 years

India

Posted:1 day ago

Job Description

Job Description: This role requires a hands-on BI Developer with deep, expert-level proficiency in the Omni Analytics BI platform. The ideal candidate will design and build semantic models, dashboards, and reports that drive data-driven decision making across the business, while working closely with data engineering and business stakeholders to translate requirements into reliable BI solutions.


Responsibilities: Job Responsibilities:

BI Development & Dashboard Design

  • Design, develop, and maintain interactive dashboards, reports, and visualizations in Omni Analytics to meet evolving business requirements.
  • Translate business and analytical requirements into intuitive, performant BI solutions.

Semantic Modeling & Data Layer

  • Build and maintain semantic/data models within Omni Analytics to ensure consistent, reusable metrics and a single source of truth across reports.
  • Define and manage data relationships, calculated fields, and reusable measures within the modeling layer.

Data Integration & Query Development

  • Write and optimize SQL queries against enterprise data warehouses and data lakes to power Omni Analytics dashboards and models.
  • Partner with data engineering teams to ensure data sources are reliable, well-structured, and performant for BI consumption.

Governance & Best Practices

  • Implement naming conventions, workspace organization, access controls, and content management standards within Omni Analytics.
  • Establish and promote BI development best practices to ensure consistency and scalability across the reporting ecosystem.

Performance Optimization & Troubleshooting

  • Monitor and optimize dashboard and query performance; troubleshoot data discrepancies, rendering issues, and model errors.

Collaboration & Documentation

  • Collaborate with business stakeholders, analysts, and data engineers to gather requirements and validate BI deliverables.
  • Create and maintain documentation for data models, dashboards, and BI development standards.

Qualifications: Skills:

Must have:

  • 2+ years of experience in BI development, with expert-level, hands-on proficiency in the Omni Analytics BI platform.
  • SQL skills for data modeling, querying, and performance tuning.
  • Proven experience building semantic/data models, dashboards, and visualizations for business consumption.
  • Solid understanding of data warehousing concepts and experience working with cloud data platforms (e.g., Snowflake, BigQuery, Redshift, or Databricks).
  • Strong analytical and problem-solving skills with the ability to translate business requirements into effective BI solutions.
  • Excellent communication skills, with the ability to engage both technical and non-technical stakeholders.

Good to Have:

  • Experience with other BI tools such as Tableau, Power BI, or Looker, including migrating or integrating content into Omni Analytics.
  • Familiarity with version control (Git) for managing BI code and semantic models.
  • Knowledge of data governance, role-based access control, and embedded analytics patterns.
  • Working knowledge of Python or scripting for data preparation and automation.
  • Experience working in consulting or client-delivery environments, managing competing priorities across multiple projects.

Eligibility:

  • Bachelor’s degree or equivalent (BTech/BE/BSc) or Master’s degree (MTech/MCA/MSc) in a relevant field.
  • 4+ years of total experience in BI development and enterprise reporting/analytics platforms.
  • Demonstrated, expert-level hands-on experience with Omni Analytics is required.

Skills Required

Analytics Data Engineering Data Integration SQL Queries Content Management Performance Optimization Troubleshooting SQL Data Modeling Performance Tuning Data Warehousing Concepts BI Tools

Learn the skills this job asks for

Free courses, interview questions and practice for each skill.

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
EXL Service logo
EXL Service

RecommendedJobs for You

EXL Service logo

India

EXL Service logo

India

EXL Service logo

Pune

EXL Service logo

Bengaluru

EXL Service logo

India

Noida, Uttar pradesh, India

Noida, Uttar pradesh, India

Jaipur, Rajasthan, India