Senior Data Analyst

JOB DESCRIPTION

If you are looking for an opportunity in Technology Solutions and Development, Emerson has this exciting role for you!

Candidate will be responsible to support BI tool stack specially SSIS, SSRS, Azure Synapse Analytics, ETL, SQL Server programming & Data Marts. Provide prompt support, maintenance, and development to assigned projects and other responsibilities.

This team delivers technology solutions for strategic business needs, drives adoption of these services and support processes and boosts value by enhancing our customers' experience. This role work along a hardworking and dedicated team of self-motivated professionals who share a collective passion for progress and excellence.

In this Role, Your Responsibilities Will Be :

• Understand the business need, develop solutions, Support production systems and monitoring.
• Proficient in Microsoft BI tool stack and SQL server programming
• Perform root cause analysis on production issues, using data to diagnose bottlenecks and inefficiencies
• Refine and automate regular processes, track issues, and document changes.
• Requirements Gathering and Analysis for changes in ETL, support and performance improvements
• Configure and maintain database servers and processes, including monitoring daily schedule jobs, monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Responsible for handling tier 3 support tickets and providing resolution within defined service level agreements
• Writing ETL jobs to download different types of data from Oracle to SQL Server Data Marts to support newer or existing reports
• Implemented SSIS package configurations (Environment Variable and SQL Server)
• Designed and Developed reports based on requirements using SQL Server Reporting Services (SSRS) and deployed them. Extensively worked on cross-tabbed and Matrix reports using SSRS.
• Experience in working on Azure Services like Azure Data Factory, Azure Data Lake(Good to have)
• Must have skill sets in writing complex SQL and PLSQL programs and proficient in performance tuning
• Ontime Coordination and Status Reporting to the client.
• Good communication skills, with the ability to convey technical concepts to both technical and non-technical customers.
• Ability to work independently work within a team environment.
• Microsoft certifications in data-related fields are preferred.
• Work closely with partners from Business, IT, Users, admin, and functional managers, and other counterparts

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 beresponsible to work on various BU's MSBI data warehouse support & projects. He / She will provide optimum solutions using Microsoft BI tool stack specially SSIS, SSAS, SSRS, Azure Synapse Analytics, ETL, SQL Server programming & Data Marts. Provide prompt support, maintenance, and development to assigned projects and other responsibilities.

Preferred Qualifications that Set You Apart :

Our Culture & Commitment to You

At Emerson, we prioritize a workplace where every employee is valued, respected, and empowered to grow. We foster an environment that encourages innovation, collaboration, and diverse perspectives- because we know that great ideas come from great teams. Our commitment to ongoing career development and growing an inclusive culture ensures you have the support to thrive. Whether through mentorship, training, or leadership opportunities, we invest in your success so you can make a lasting impact. We believe diverse teams, working together are key to driving growth and delivering business results. We recognize the importance of employee wellbeing. We prioritize providing competitive benefits plans, a variety of medical insurance plans, Employee Assistance Program, employee resource groups, recognition, and much more. Our culture offers flexible time off plans, including paid parental leave (maternal and paternal), vacation and holiday leave .

Skills Required

Plsql, Sql, Power Bi, Etl, Ssis, Azure Synapse Analytics, Sql Server Programming, Azure Data Factory, data marts, Ssrs, Azure Data Lake