Senior Business Intelligence Analyst

Emerson; Sahibzada Ajit Singh Nagar; On-site; INR 4,50,000 - 6,75,000; Full time

Job summary

A leading technology company in Punjab is looking for an experienced SQL Developer to design and support BI reporting applications. Candidates should have 7-10 years of experience with SQL and PL/SQL, as well as a strong capability in data analysis and BI reporting tools like Power BI. This role involves developing SQL queries, maintaining database operations, and supporting production issues. Ideal for those with a Bachelor's degree in a technical field and excellent problem-solving skills.

Benefits

Comprehensive medical and insurance coverage

Opportunity to make a difference in the workplace

Qualifications

• 7-10 years of experience working with SQL and PL/SQL.
• Strong proficiency in SQL and relational database systems.
• Experience with database design, normalization, and optimization.

Responsibilities

• Design and develop BI reporting applications.
• Handle production tier 3 support tickets.
• Perform root cause analysis on production issues.

Skills

SQL Development

PL/SQL

BI Reporting

Data Analysis

Problem Solving

Communication Skills

Education

Bachelor's degree in related field

Tools

Power BI

MS SQL Server

MySQL

Oracle

Job description

Job Summary

As an SQL Developer you will design, develop and support BI reporting applications and analytics under Data Management & Insights. Your role focuses on SQL Development, SQL Support & Troubleshooting and BI Reports creation. You will develop, enhance and provide prompt support for analytics and reporting needs.

Responsibilities

• Proficient inSQL and PL/SQL development & BI reporting solutions
• Design, develop, and maintain SQL queries, stored procedures, functions, and triggers.
• Responsible for handling production tier 3 support tickets and providing resolutions within defined service level agreements.
• Develop and execute reports, Bug fixes, optimizations and enhancement.
• Perform root cause analysis on production issues, using data to diagnose bottlenecks and inefficiencies.
• Strong proficiency in Business Intelligence (BI) tools such as Power BI, and other analytics platforms.
• Document database structures, processes, and best practices.
• Contribute throughout project life cycles, from planning to production implementation, including the creation of functional designs, technical designs and test plans for repository models and hierarchies.
• Should know how to write advance SQL, use Oracle's SQL aggregate and analytic functions.
• Must have skill sets in writing complex SQL and PLSQL programs and proficiency in tuning the code.
• Work with Business users to understand reporting requirements and provide optimal solution.
• Good communication skills, with the ability to convey technical concepts to both technical and non-technical customers.
• Ability to work independently within a team environment.
• Support strategic decision-making through comprehensive data analysis and recommendations.
• Microsoft certifications in data-related fields are preferred.

Who You Are

You show a tremendous amount of initiative in tough situations; are exceptional at spotting and seizing opportunities. You observe situational and group dynamics and select best-fit approach. You make implementation plans that allocate resources precisely. You pursue everything with energy, drive, and the need to finish.

For This Role, You Will Need

• Minimum of 7-10 years of experience working with SQL, PL/SQL and any BI reporting tool
• Strong proficiency in SQL and relational database systems (e.g., MS SQL Server, MySQL)
• Experience with database design, normalization, and optimization techniques.
• Strong analytical abilities with a proven track record of resolving complex data challenges.
• Understanding of Excel, including formulas, filters, macros, pivots, and related operations.
• Willingness to work flexible hours based on project requirements.
• Advanced SQL skills, including experience with complex queries, data modeling, and performance tuning.
• Ability to deliver complex business solutions with minimal supervision.
• Experience working with various data sources like Oracle, SQL Server etc.
• Working experience on SNOW and Agile Process is a plus.
• Good written and verbal communication skills
• Good problem solving and analytical skills.
• Flexible to work in 24x7 environment.

Preferred Qualifications that Set You Apart

• Bachelor’s degree or equivalent in Science with a technical background (MIS, Computer Science, Engineering or any related field)
• Good interpersonal skills using English, both spoken and written, as will be working with overseas team

Benefits

By joining Emerson, you will be given the opportunity to make a difference through the work you do. Emerson’s compensation and benefits programs are designed to be competitive within the industry and local labor markets. We also offer a comprehensive medical and insurance coverage to meet the needs of our employees and support a global workplace that embraces diversity, equity and inclusion.