Business Intelligence Analyst

Job title: Business Intelligence Analyst

Location: Baner, Pune

Experience: 2-3 years

Salary: Best as per market standards

Shift Timings: 6:30 PM to 3:30 AM IST

Schedule: Monday - Friday | On-site | India Night Shift
Employment type: 6 months of contractual role

Job Summary

The Data Analyst Intern will embed with Organizations Data & Analytics team to work on a variety of data related projects. This role will be exposed to the full data lifecycle- including, but not limited to, understanding & documenting requirements, working with transactional system data, ensuring data quality, building ETL packages, integrating new sources into the data warehouse, creating reporting & business intelligence, and exploring predictive analytics, artificial intelligence & machine learning.

Key Responsibilities:

• Data Modelling & Orchestration: Build, optimize, and maintain robust data transformation pipelines using dbt within a Snowflake data warehouse environment.
• Dashboard & Report Development: Design, develop, and deploy scalable, interactive dashboards and data models in Domo and Omni to support executive and departmental reporting.
• Source System Integration: Clean, model, and analyze complex datasets originating from cloud applications, primarily CRM (Salesforce) and ERP (NetSuite) platforms.
• Stakeholder Collaboration: Partner with Sales, Finance, Operations, and Executive teams to gather reporting requirements, define Key Performance Indicators (KPIs), and deliver self-service analytics solutions.
• Data Governance & Quality: Implement automated data quality checks, maintain documentation (such as dbt docs), and ensure a single source of truth across all business metrics.

Required Skills/ Experience:

• Education: Bachelors degree in data Analytics, Computer Science, Information Systems, Finance, or a related quantitative field.
• Core Warehouse Experience: Minimum of 3+ years of experience working with Snowflake (writing optimized SQL, understanding architecture, and managing performance).
• Data Transformation: Strong proficiency with dbt (data build tool) for version-controlled data modelling, testing, and documentation.
• BI Tool Expertise: Proven experience building advanced semantic layers and visualizations in Domo and Omni (or similar modern BI tools like Looker).
• Business Applications: Hands-on experience modelling and analysing schema structures from Salesforce and NetSuite
• Technical Skills: Advanced SQL mastery is strictly required. Familiarity with Git workflows and command-line interfaces is highly preferred.
• Strong attention to detail and organizational skills.

Benefits:

• Doorstep Cab Facility
• Family Health Insurance
• Rewards & Recognition Programs
• Career Growth Opportunities
• Employee Engagement Activities