Business Intelligence Data Analyst II

Advarra; Bengaluru; On-site; INR 1,200,000 - 2,100,000; Full time

Job summary

Advarra is seeking a hybrid Data Engineer in Bengaluru, India, to optimize data structures, model data to support BI, and monitor data feeds. The role emphasizes collaboration with business and product teams to document requirements and ensure analytics readiness.

The ideal candidate has 2–4 years of SQL, data monitoring, and validation experience, with advanced Excel, Snowflake, and Databricks skills, plus DBT and GitHub familiarity.

Qualifications

• Bachelor's degree in data science, information science or related field.
• 2–4 years experience focusing on SQL coding, data feeds monitoring, and data validation.
• Advanced Excel skills; Snowflake, Databricks, and SQL proficiency.
• Experience with DBT, GitHub and end‑user requirements gathering.

Responsibilities

• Understand and optimize data structure to drive consistent data capture and reporting.
• Lead data modeling initiatives to support business needs.
• Follow data engineering best practices to support BI requirements.
• Coordinate with stakeholders to document and capture requirements.
• Support analytics by monitoring data feeds and resolving issues.
• Participate in release management and deployment when needed.

Skills

SQL

Data Modeling

Data Validation

Cross-functional teamwork

Attention to detail

Time management

Learning new tech

Education

Bachelor in Data Science

Related field

Tools

Snowflake

Databricks

DBT

Github

Python

JSON

HTML

Job description

• Understand andoptimizedata structure to drive consistent data capture and reporting
• Lead situations where new data modeling isrequiredto support the business
• Follow best practice as defined by Data Engineering to support BusinessIntelligenceneeds
• Drive collaboration with identification of required individuals necessary foridentifiedresolutions
• Work with Business and Product Management team to ensureappropriate requirementsarecaptured and documented
• Support the architect of solutionsto support analytics needs
• Understanding of on all development in process,regardless of team ownership, forappropriate trackingand project updates
• Participate in release management and deployment, where necessary
• Monitor data feeds and engage withDataEngineering to resolve issues

Location

This role is open to candidatesworkinghybrid in Bengaluru, India.

BasicQualifications

• Bachelor’s Degree in Data Science, Information Science or related area of experience
• 2-4 years of experience with a focus on SQL coding, system and data feed monitoring, and data validation
• Excel – advanced
• Snowflake – advanced
• Databricks – advanced
• SQL – advanced
• DBT
• Github
• Business analysis skills – advanced
• Demonstratedproficiencyin making effective, well-reasoned decisions
• Demonstratedproficiencyin end user requirements gathering
• Ability to work on cross-functional teams
• Excellent attention to detail and time management skills, proven ability to adapt and navigate change
• Ability to quickly learnnew technologiesand systems

Preferred Qualifications

• Python, JSON,HTML,and other coding experience

Physical and Mental Requirements

• Sit or stand for extended periods of time at stationary workstation
• Regularly carry, raise, and lower objects of up to 10 Lbs.
• Learn andcomprehendbasic instructions
• Focus and attention to tasks and responsibilities
• Verbal communication; listening and understanding, responding,and speaking

Advarra is an equal opportunity employer that is committed to providing a workplace that is free from discrimination and harassment of any kind based on race, color, religion, creed, sex (including pregnancy, childbirth, and related medical conditions, sexual orientation, and gender identity), national origin, age, disability or genetic information, or any other status or characteristic protected by federal, state, or local law.