Emerson - Senior Data Engineer - ETL/SQL

Job Summary

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

- The candidate will be working on MSBI data warehouse & database projects under Data Management & Insights group.

- He/ She will provide optimum solutions using Microsoft BI tool stack specially SSIS, SSAS, SSRS, Azure Synapse Analytics, ETL, SQL Server programming & Data Marts.

- He/ She will be responsible for developing solutions in Power BI.

- Provide prompt support, maintenance, and development to assigned projects and other responsibilities.

- In this role one needs to interact with customers to understand requirements and provide an optimal solution.

- This team delivers technological solutions for strategic business needs, drives the adoption of these services and support processes and boosts value by enhancing our customers experience.

- This role is to work along a hardworking and resolute team of initiative-taking professionals who share a collective passion for progress and excellence.

In this Role, Your Responsibilities Will Be :

- Proficient in Microsoft BI tool stack (SSMS, SSIS, SSRS) and SQL server programming.

- Responsible for handling production tier three support tickets and providing resolutions within defined service level agreements.

- Develop and execute reports, Bug fixes, optimizations and enhancement, document processes and generate required metadata.

- Perform root cause analysis on production issues, using data to diagnose bottlenecks and inefficiencies.

- Design, develop, and maintain scalable and high-performance data pipelines using Azure Data Factory, Azure Synapse Analytics, and other Azure services would be an added advantage.

- Develop and maintain ETL/ELT processes to ensure the quality, consistency, and accuracy of data.

- Experience in Fabric components, including Lakehouse, OneLake, Data Pipelines, Real-Time Analytics, Power BI Integration, and Semantic Models would be an added advantage.

- Review and implement best practices within the team to maximize system potential.

- Strong proficiency in Business Intelligence (BI) tools such as Power BI, and other analytics platforms.

- Contributes 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 SQL aggregate and analytic functions.

- Must have skill sets in writing complex SQL programs and proficiency in tuning the code.

- Work with Business users to understand reporting requirements and provide optimal solutions.

- Effective 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 BI tools, Data fixes and operational support under Data Management & Insights projects.

- This would include handling Tier 3 support tickets and following a change management process for development and enhancement.

- In this role one needs to interact with customers to understand requirements and provide an optimal solution.

- Provide prompt support, and development to assigned projects and other responsibilities.

- 7-12 years of experience in designing, developing, and managing data solutions using Microsoft BI tools and SQL Server programming.

- Strong analytical abilities with a proven track record of resolving complex data challenges.

- Strong SQL skills, including experience with data modeling, complex queries, and performance optimization.

- Knowledge of Data Lake Architecture, Data Warehousing, and Data Modeling principles.

- Familiarity with standard processes in data governance, lineage, security, and privacy.

- Expertise in SSDT tools (SSIS, SSRS) and SQL Server in enterprise environments.

- Willingness to work flexible hours based on project requirements.

Ability to deliver complex business solutions with minimal supervision.

Working experience on SNOW and Agile Process is a plus.

Strong problem-solving, communication, and collaboration skills.

Ability to work independently and manage multiple tasks simultaneously.

Preferred Qualifications that Set You Apart :

Bachelors 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 industry and local labor markets.

We also offer 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 of providing 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.

ABOUT EMERSON :

Emerson is a global leader in automation technology and software.

Through our deep domain expertise and legacy of perfect 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 are an established professional looking for a career change, an undergraduate student exploring possibilities, or a recent graduate with an advanced degree, you will find your chance to be effective with Emerson.