Senior Business Intelligence Consultant

6 years

20 - 32 Lacs

Posted:1 week ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Company:

Delta technology and management services

Website:

Visit Website

Business Type:

Enterprise

Company Type:

Service

Business Model:

B2B

Funding Stage:

Bootstrapped

Industry:

IT Services

Salary Range:

₹ 20-32 Lacs PA

Role Overview

We are looking for a highly skilled

Business Intelligence / ETL Engineer

with at least 6+ years of enterprise experience in BI and ETL environments. The ideal candidate will possess strong analytical abilities, deep expertise in data warehousing and dimensional modeling, and hands-on experience with SSIS, SSRS, SSAS, and SQL. This role requires a disciplined, detail-oriented professional who can design and implement robust BI/ETL solutions while contributing to both individual and team success.

Key Responsibilities

  • Analyze source systems and perform detailed data analysis.
  • Design and implement Source-Target Mapping definitions, transformations, jobs, and sequences.
  • Develop BI and Data Warehouse solutions with strong dimensional modeling skills.
  • Build and maintain SSIS, SSRS, and SSAS components.
  • Develop SQL queries, stored procedures, and perform query performance tuning.
  • Integrate data from SQL Server and Oracle databases.
  • Extract and transform data using MDX queries.
  • Develop custom C#.NET functions for ETL transformations.
  • Document ETL processes and ensure proper unit testing and signoff.
  • Work independently as well as mentor and guide other team members.
  • Ensure project discipline by meeting deliverable dates and maintaining quality standards.

Must-Have Skills

  • 6+ years of enterprise-level experience in BI/ETL environments.
  • Strong analytical skills.
  • Expertise in Data Warehousing and BI architecture.
  • Strong dimensional modeling capabilities.
  • Proficiency in SSIS, SSRS, SSAS.
  • Strong SQL programming and stored procedure skills.
  • Hands-on experience with source/data analysis.
  • Proven knowledge of ETL performance tuning and optimization.
  • Experience in C#.NET for custom transformations.
  • Excellent verbal and written communication, including technical documentation.

Good to Have

  • Knowledge of cloud-based ETL solutions (e.g., Azure Data Factory).
  • Familiarity with additional BI tools and programming languages (e.g., Python).
  • Knowledge of Power BI.
  • Experience with ERP integrations such as JDE E1.

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.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You