Senior Business Intelligence Consultant

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

Job Description

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.
  
  

• 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.
  
  

• 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.