Senior Business Intelligence Analyst
Emerson
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.
Candidate will have strong expertise in SQL programming, database optimization, and data integration, ensuring high performance and reliability of our data infrastructure. In this role one needs to interact with customers to understand requirements and provide optimal solution.
In this Role, Your Responsibilities Will Be:
Proficient in SQL 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:
The incumbent in this position would be responsible for PL/SQL support & development under Data Management & Insights projects. This would include handling Tier 3 support tickets and following change management process for development and enhancement. In this role one needs to interact with customers to understand requirements and provide optimal solution. Provide prompt support, and development to assigned projects and other responsibilities.
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
Our Offer to You:
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.
We are committed to creating a global workplace that supports diversity, equity and embraces inclusion. We welcome foreign nationals to join us through our Work Authorization Sponsorship.
We attract, develop, and retain exceptional people in an inclusive environment, where all employees can reach their greatest potential. We are dedicated to the ongoing development of our employees because we know that it is critical to our success as a global company.
We have established our Remote Work Policy for eligible roles to promote Work-Life Balance through a hybrid work set up where our team members can take advantage of working both from home and at the office.
Safety is paramount to us, and we are relentless in our pursuit to provide a Safe Working Environment across our global network and facilities.
Through our benefits, development opportunities, and an inclusive and safe work environment, we aim to create an organization our people are proud to represent.
Our Commitment to Diversity, Equity & Inclusion
At Emerson, we are committed to fostering a culture where every employee is valued and respected for their unique experiences and perspectives. We believe a diverse and inclusive work environment contributes to the rich exchange of ideas and diversity of thoughts, that inspires innovation and brings the best solutions to our customers.
This philosophy is fundamental to living our company’s values and our responsibility to leave the world in a better place. Learn more about our Culture & Values and about Diversity, Equity & Inclusion at Emerson.
If you have a disability and are having difficulty accessing or using this website to apply for a position, please contact: idisability.administrator@emerson.com.
Our Commitment to Our People
At Emerson, we are motivated by a spirit of collaboration that helps our diverse, multicultural teams across the world drive innovation that makes the world healthier, safer, smarter, and more sustainable. And we want you to join us in our bold aspiration.
We have built an engaged community of inquisitive, dedicated people who thrive knowing they are welcomed, trusted, celebrated, and empowered to solve the world’s most complex problems — for our customers, our communities, and the planet. You’ll contribute to this vital work while further developing your skills through our award-winning employee development programs. We are a proud corporate citizen in every city where we operate and are committed to our people, our communities, and the world at large. We take this responsibility seriously and strive to make a positive impact through every endeavor.
At Emerson, you’ll see firsthand that our people are at the center of everything we do. So, let’s go. Let’s think differently. Learn, collaborate, and grow. Seek opportunity. Push boundaries. Be empowered to make things better. Speed up to break through. Let’s go, together.
Emerson is a global leader in automation technology and software. Through our deep domain expertise and legacy of flawless execution, Emerson helps customers in critical industries like life sciences, energy, power and renewables, chemical and advanced factory automation operate more sustainably while improving productivity, energy security and reliability.
With global operations and a comprehensive portfolio of software and technology, we are helping companies implement digital transformation to measurably improve their operations, conserve valuable resources and enhance their safety.
We offer equitable opportunities, celebrate diversity, and embrace challenges with confidence that, together, we can make an impact across a broad spectrum of countries and industries. Whether you’re an established professional looking for a career change, an undergraduate student exploring possibilities, or a recent graduate with an advanced degree, you’ll find your chance to make a difference with Emerson. Join our team – let’s go!
Our Commitment to Our People
At Emerson, we are motivated by a spirit of collaboration that helps our diverse, multicultural teams across the world drive innovation that makes the world healthier, safer, smarter, and more sustainable. And we want you to join us in our bold aspiration.
We have built an engaged community of inquisitive, dedicated people who thrive knowing they are welcomed, trusted, celebrated, and empowered to solve the world’s most complex problems — for our customers, our communities, and the planet. You’ll contribute to this vital work while further developing your skills through our award-winning employee development programs. We are a proud corporate citizen in every city where we operate and are committed to our people, our communities, and the world at large. We take this responsibility seriously and strive to make a positive impact through every endeavor.
At Emerson, you’ll see firsthand that our people are at the center of everything we do. So, let’s go. Let’s think differently. Learn, collaborate, and grow. Seek opportunity. Push boundaries. Be empowered to make things better. Speed up to break through. Let’s go, together.
Accessibility Assistance or Accommodation
If you have a disability and are having difficulty accessing or using this website to apply for a position, please contact: idisability.administrator@emerson.com.
Emerson is a global leader in automation technology and software. Through our deep domain expertise and legacy of flawless execution, Emerson helps customers in critical industries like life sciences, energy, power and renewables, chemical and advanced factory automation operate more sustainably while improving productivity, energy security and reliability.
With global operations and a comprehensive portfolio of software and technology, we are helping companies implement digital transformation to measurably improve their operations, conserve valuable resources and enhance their safety.
We offer equitable opportunities, celebrate diversity, and embrace challenges with confidence that, together, we can make an impact across a broad spectrum of countries and industries. Whether you’re an established professional looking for a career change, an undergraduate student exploring possibilities, or a recent graduate with an advanced degree, you’ll find your chance to make a difference with Emerson. Join our team – let’s go!
No calls or agencies please.
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. Candidate will have strong expertise in SQL programming, database optimization, and data integration, ensuring high performance and reliability of our data infrastructure. In this role one needs to interact with customers to understand requirements and provide optimal solution.