BI/Data Engineer | BLR | 3-5 Years | FullTime

Light & Wonder; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Light & Wonder is hiring a BI/Data Engineer to design, build, and maintain scalable data pipelines, dashboards, and reports. You will work with Snowflake-based environments, optimize SQL, and partner with analysts and product teams to enable data-driven decision-making.

The role requires 3–5 years of software/BI data engineering experience, proficiency in SQL, ETL/ELT tooling, and BI visualization platforms. Strong collaboration and governance practices are essential.

Qualifications

• 3–5 years of software/BI data engineering experience.
• Strong SQL with query optimization and complex joins.
• Hands-on ETL/ELT design with modern tools (dbt/Airflow/etc.).
• Experience with a cloud data warehouse (BigQuery/Redshift/Azure Synapse).
• Proficiency in Python or Scala for data processing.
• Experience with BI/visualization tools (Tableau/Power BI/Looker).
• Knowledge of version control and CI/CD practices.
• Understanding of dimensional modeling (star/snowflake).

Responsibilities

• Design and build robust ETL/ELT pipelines for data ingestion and transformation.
• Create and optimize data models and ER/star/snowflake schemas for BI workloads.
• Develop and maintain interactive dashboards and reports.
• Write efficient SQL and data models to support analytics and cost optimization.
• Collaborate with analysts, product managers, and stakeholders to translate requirements.
• Ensure data quality, consistency, and governance across pipelines and reports.
• Monitor workflows, troubleshoot failures, and optimize performance.
• Document data flows, dictionaries, and reporting logic.

Skills

SQL proficiency

ETL/ELT design

Python/Scala

BI tools

Cloud data warehouse

Version control

Dimensional modeling

Snowflake

Tools

dbt

Apache Airflow

Talend

Job description

BI/Data Engineer

• Job Location: ITPL Whitefield, Bangalore
• Required Experience: 03 - 05 Years
• 4 days work from office

About the Role

We are looking for a skilled Software Engineer to join our Business Intelligence team. You will design, build, and maintain scalable data pipelines, dashboards, and report solutions that empower data-driven decision-making across the organization.

Key Responsibilities

• Design and develop robust ETL/ELT pipelines to ingest, transform, and load data from multiple sources into the data warehouse.
• Design ER models and implemented fact-dimension schemas optimized for BI workloads and Snowflake data platforms.
• Design the data model principles to build star or snowflake schema with exposure to Kimbel architecture and Medallion conceptual architecture with CDC Events and familiar with Dimension models and SCD types.
• Build and maintain interactive dashboards and reports using BI tools
• Write optimized SQL queries and data models to support analytical and reporting needs and handle snowflake costs.
• Collaborate with data analysts, product managers, and business stakeholders to translate requirements into technical solutions.
• Ensure data quality, consistency, and integrity across data pipelines and reports
• Monitor and troubleshoot data pipeline failures and performance bottlenecks
• Document data flows, data dictionaries, and reporting logic
• Participate in code reviews and contribute to best practices for BI engineering.

Required Skills & Qualifications

• 3 to 5 years of experience in software engineering with a focus on data or BI and SQL basics and advanced level with hands on query optimizations.
• Strong proficiency in SQL (query optimization, complex joins, window functions)
• Hands-on experience with at least one ETL/ELT design approach (e.g., dbt, Apache Airflow, MSBI, Talend, or Informatica).
• Experience with a cloud data warehouse (Big Query, Redshift, or Azure Synapse)
• Proficiency in Python or Scala for data processing and automation
• Experience with BI/visualization tools (Tableau, Power BI Looker, or similar).
• Familiarity with version control (Git) and CI/CD practices.
• Understanding of dimensional modeling and data warehousing concepts (Star/Snowflake schema).

Added Advantage

• Power BI Experience building interactive dashboards, reports, and data models in Power BI (DAX, Power Query, data gateways)
• Snowflake Hands-on experience with Snowflake including data sharing, virtual warehouses, build workflow with ETL/ELT & performance tuning, clustering, pruning the data.

Good to Have

• Exposure to real-time/streaming data processing (Kafka, Debezium, Spark Streaming)
• Experience with cloud platforms (AWS, GCP, or Azure)
• Knowledge of data governance and data catalog tools
• Familiarity with Agile/Scrum methodologies.

Soft Skills

• Strong analytical and problem-solving mindset
• Ability to communicate technical concepts clearly to non-technical stakeholders
• Self-driven with an ability to manage multiple priorities
• Collaborative team player with a detail-oriented approach
• Should be adaptable to learning mindset.