Sr. Data Analyst - SQL Job

YASH Technologies is a leading technology integrator specializing in helping clients reimagine operating models, enhance competitiveness, optimize costs, foster exceptional stakeholder experiences, and drive business transformation.

At YASH, we’re a cluster of the brightest stars working with cutting-edge technologies. Our purpose is anchored in a single truth – bringing real positive changes in an increasingly virtual world and it drives us beyond generational gaps and disruptions of the future.

We are looking forward to hire SQL Professionals in the following areas :

Job Description:

Job Summary
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 be responsible 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.

• 6-7 years of experience working with Microsoft BI tool stack and SQL server programming
• 6-7 years of experience on SSDT tools specially into SSIS, SSAS, SSRS & SQL Server
• Strong analytical abilities with a proven track record of resolving complex data challenges.
• Proficient in database management, SQL query optimization, and data mapping.
• Understanding of Excel, including formulas, filters, macros, pivots, and related operations.
• Demonstrable experience leading and managing data-driven projects or teams.
• Strong proficiency with data visualization tools such as Power BI, or similar tools.
• Experience in strategic business analysis and collaborating with senior leadership.
• 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

At YASH, you are empowered to create a career that will take you to where you want to go while working in an inclusive team environment. We leverage career-oriented skilling models and optimize our collective intelligence aided with technology for continuous learning, unlearning, and relearning at a rapid pace and scale.

Our Hyperlearning workplace is grounded upon four principles

• Flexible work arrangements, Free spirit, and emotional positivity
• Agile self-determination, trust, transparency, and open collaboration
• All Support needed for the realization of business goals,
• Stable employment with a great atmosphere and ethical corporate culture