14 Nov
|
FuGenTex Solutions
|
Mumbai
14 Nov
FuGenTex Solutions
Mumbai
Job Title: SQL Data Analyst
Experience: 3–4 Years
Location: Mahape Mumbai
Employment Type: Full-Time
Job Summary
We are looking for an experienced SQL Data Analyst with strong expertise in T-SQL or GoogleSQL (BigQuery) to develop, maintain, and optimize MIS reports, dashboards, and analytical datasets. The ideal candidate should have hands-on experience in complex SQL queries, stored procedures, database development, query optimization, and data modelling.
Key Responsibilities
- Design, develop, and maintain database tables, schemas, views, stored procedures, functions, and triggers.
- Write and optimize complex SQL queries using T-SQL or GoogleSQL (BigQuery).
- Perform data extraction, transformation, aggregation, and validation for MIS and analytical reporting.
- Analyze query execution plans and optimize database performance.
- Monitor database performance, troubleshoot issues, and ensure data accuracy and reliability.
- Handle ad-hoc reporting requirements and resolve stakeholder requests through JIRA, ServiceDesk, or similar ticketing tools.
- Work with business stakeholders to understand reporting requirements and deliver accurate MIS reports within agreed timelines.
- Maintain documentation of SQL queries, database objects, data models, and reporting processes.
- Ensure data integrity, security, and access control across databases.
Required Skills
- Strong hands-on experience in SQL / T-SQL / GoogleSQL (BigQuery).
- Expertise in complex SQL queries, joins, subqueries, CTEs, window functions, and aggregations.
- Experience developing stored procedures, functions, triggers, and views.
- Robust understanding of database design, data modelling, normalization, primary keys, and foreign keys.
- Experience in query optimization, execution plan analysis, and performance tuning.
- Knowledge of data warehousing and MIS/reporting processes.
- Working knowledge of GCP BigQuery, including partitioning and query optimization.
- Understanding of data governance, database security, and access controls.
- Familiarity with JIRA / ServiceDesk and Git / SVN.
- Experience supporting BI and analytics reporting tools such as Power BI or Tableau.
Education & Experience
- Bachelor's degree in Computer Science, Information Technology, Data Analytics, Information Systems, or a related field.
- 3–4 years of relevant experience in SQL development, T-SQL or
Pay: ₹600,000.00 - ₹2,900,000.00 per year
Work Location: In person
📌 SQL Data Analyst (Mumbai)
🏢 FuGenTex Solutions
📍 Mumbai