12 Nov
|
EXL
|
Maharashtra
Job Title: Omni BI Developer
Experience: 4+ Years
Location: Pune / Bangalore / Hyderabad / Chennai (Hybrid)
Job Summary
We are looking for a skilled Omni BI Developer with 4 years of experience designing and delivering business intelligence solutions on the Omni analytics platform. The ideal candidate combines hands-on expertise in Omni dashboard and data model development with a strong foundation in data visualization, analytical thinking, and stakeholder communication.
In this role, you will partner with business teams and data engineers to build intuitive, high-impact dashboards and self-service analytics experiences that drive decision-making across the organization. You will own the BI layer end-to-end — from data model design in Omni to governed, production-ready dashboards — while applying best practices in data visualization and analysis.
Required Experience
- 4+ years of overall experience in BI development, data analysis, or analytics engineering.
- Minimum 3 years of hands-on experience building dashboards and data models in Omni.
- Experience working with cloud-based data warehouses (Snowflake, BigQuery, Databricks, or Redshift).
- Demonstrated ability to deliver BI solutions end-to-end from requirements to production.
- Experience supporting business stakeholders across multiple functions (finance, marketing, operations, product, etc.).
- Proven ability to handle multiple concurrent projects and prioritize in a fast-paced environment.
Key Responsibilities Dashboard Development & Delivery
- Design, build, and maintain dashboards and reports in Omni for business stakeholders across functions.
- Translate complex business questions into transparent, insightful visualizations and self-service analytics.
- Build reusable, governed data models and topics within Omni to support consistent metric definitions across the org.
- Optimize dashboard performance and ensure reliability of published reports.
- Apply data visualization best practices to make insights accessible to non-technical audiences.
Data Modeling & Analysis
- Define and maintain semantic data models in Omni, including relationships, calculated fields, dimensions, and measures.
- Write and optimize SQL queries to support reporting, analysis, and dashboard development.
- Collaborate with data engineers to ensure BI-ready data is available, clean, and correctly structured in the data warehouse.
- Perform exploratory data analysis (EDA) to identify trends, anomalies, and actionable insights.
- Develop and maintain KPI frameworks, metric definitions, and business glossary documentation.
Stakeholder Collaboration
- Partner with business owners, product managers, and analysts to gather requirements and translate them into BI solutions.
- Conduct demo sessions and walk-throughs of dashboards with end users.
- Support self-service analytics adoption — training users on Omni and promoting a data-driven culture.
- Manage multiple stakeholder requests, prioritize effectively, and communicate timelines clearly.
Governance & Data Quality
- Ensure data accuracy, consistency, and completeness across all dashboards and reports.
- Apply row-level security, access controls, and data governance standards within the BI layer.
- Document data models, field definitions, and dashboard logic for maintainability and knowledge transfer.
- Monitor dashboard usage and iterate based on user feedback and adoption metrics.
Required Technical Skills
Omni
- Omni dashboard development (3–5 years hands-on)
- Omni data model and topic configuration
- Calculated fields, dimensions, and measures in Omni
- Omni access controls and row-level security
- Omni workbook and embed features
- Dashboard performance tuning in Omni
Data Visualization
- Strong command of visualization best practices (chart selection, layout, labeling, color)
- Experience building executive-level and operational dashboards
- Familiarity with design principles for data clarity and storytelling
- Knowledge of accessibility standards in data visualization
SQL & Data Warehousing
- Advanced SQL (CTEs, window functions, aggregations, joins)
- Experience with cloud data warehouses — Snowflake, BigQuery, Databricks,
or Redshift
- Understanding of dimensional modeling (star schema, snowflake schema)
- Familiarity with dbt or similar data transformation tools (preferred)
Data Analysis
- Proficiency in exploratory data analysis and descriptive statistics
- Experience defining and tracking KPIs, metrics, and business performance indicators
- Ability to validate data, trace discrepancies, and ensure analytical accuracy
- Comfortable working with large datasets and cross-functional data sources
Programming & Tools
- SQL (Advanced)
- Python or R for data analysis (preferred)
- Git for version control
- Experience with data cataloging or documentation tools (preferred)
Preferred Qualifications
- Bachelor's or Master's Degree in Data Science, Statistics, Computer Science, Information Systems, or a related field.
- Omni certification or active Omni community contributions.
- Experience with dbt for data transformation upstream of the BI layer.
- Exposure to data governance and cataloging tools (e.g., Collibra, Atlan, Alation).
- Experience with agile delivery methodologies.
- Familiarity with embedding Omni dashboards in external applications.
Nice to Have
- Exposure to other modern BI tools such as Looker, Tableau, Power BI, or Metabase.
- Experience with semantic layer concepts or tools (AtScale, Cube.dev, dbt Semantic Layer).
- Knowledge of data mesh or data product principles.
- Experience with real-time or streaming data visualization.
- Python-based analytics or notebook experience (Jupyter, Hex, Evidence).
- Familiarity with AI/ML output visualization and model monitoring dashboards.
Key Competencies
- Data Storytelling & Visualization
- Analytical Thinking & Problem Solving
- Stakeholder Communication
- Attention to Data Accuracy
- Self-Service Analytics Enablement
- Collaboration & Cross-functional Partnering
- Continuous Improvement & Learning
- Time Management & Prioritization
Technology Classification
Technology Tower: Data & AI
Practice Area: Business Intelligence & Analytics
Primary Skill: Omni BI Development
Secondary Skills: SQL, Cloud Data Warehousing (Snowflake / BigQuery / Databricks / Redshift), Data Visualization, Dimensional Modeling, dbt (preferred)
📌 Omni BI Developer (Maharashtra)
🏢 EXL
📍 Maharashtra