Sql Analyst

Job Overview

Job description

 

About the Role

We are seeking a skilled SQL Developer to design, develop, and maintain database systems, queries, procedures, and reports. You will work closely with application developers, data analysts, and business teams to ensure data accuracy, integrity, and performance across all systems.

Key Responsibilities

• Develop and maintain complex SQL queries, stored procedures, functions, and triggers.
• Design, optimize, and manage databases, tables, views, and schemas.
• Collaborate with backend and BI teams to support data-related functionality.
• Improve database performance through query tuning and indexing strategies.
• Develop ETL processes and data mapping workflows.
• Ensure data quality, consistency, and security across environments.
• Create and maintain technical documentation for database structures.
• Troubleshoot database issues and provide root cause analysis.
• Support data migrations, integrations, and version upgrades.

Required Skills & Qualifications

• Strong expertise in SQL (e.g., Oracle SQL, MS SQL Server, MySQL, PostgreSQL).
• Experience writing and optimizing stored procedures, functions, triggers, and complex joins.
• Strong understanding of database design principles (normalization, relationships, indexing).
• Experience with ETL processes and data transformation tools.
• Knowledge of performance tuning and query optimization techniques.
• Familiarity with data modeling and schema design.
• Experience with version control tools (Git preferred).
• Good understanding of business logic and ability to translate requirements into SQL solutions.

Preferred / Nice-to-Have Skills

• Experience with SSIS, SSRS, Power BI, or other reporting/BI tools.
• Knowledge of PL/SQL, T-SQL, or other database-specific procedural languages.
• Experience working with cloud databases (AWS RDS, Azure SQL, Google Cloud SQL).
• Familiarity with scripting languages (Python, Bash, PowerShell) for automation.
• Understanding of data warehousing concepts (star schema, fact/dimension models).
• Exposure to Big Data tools (Hive, Spark, Snowflake) is a plus.

Education

• Bachelors degree in Computer Science, Information Technology, or related field (or equivalent practical experience)