Description :

About the Role :

We are looking for an experienced BI Developer to build and optimize data solutions that support reporting, analytics, and business intelligence initiatives. This role involves designing efficient SQL queries, managing large datasets, and ensuring data accuracy across systems. The ideal candidate will work closely with analysts and data engineers to deliver reliable insights that drive business decisions.

Key Responsibilities :

- Develop, test, and maintain complex SQL queries and stored procedures

- Design and optimize data models, tables, and database relationships

- Build efficient SQL logic for data extraction, transformation, and loading (ETL)

- Create and manage CTEs, temporary tables, and subqueries

- Perform advanced data analysis using joins, aggregations, and window functions

- Identify and remove duplicate records using techniques such as ROW_NUMBER() and RANK()

- Support business reporting, analytics, and dashboard data requirements

- Ensure data integrity and consistency across multiple systems

- Troubleshoot performance issues using indexing, query tuning, and execution plans

- Collaborate with business analysts and data engineers to meet data requirements

Key Skills & Qualifications :

- 5-7 years of experience in BI/Data development

- Strong SQL expertise (T-SQL or PL/SQL preferred)

- Hands-on experience with joins, subqueries, CTEs, window functions, and aggregations

- Strong understanding of analytical functions such as GROUP BY, HAVING, ROW_NUMBER(), and RANK()

- Experience with DML (INSERT, UPDATE, DELETE) and DDL (CREATE, ALTER)

- Experience working with large datasets and transactional systems

- Familiarity with relational databases such as SQL Server, Oracle, PostgreSQL, or MySQL

- Strong problem-solving, analytical thinking, and collaboration skills

- Ability to write clean, reusable, and well-documented code