
Overview
ID : 2526
Experience
5 - 7 years
Location
Pune
About Clarion Technologies
Clarion Technologies is an IT services company providing customized software solutions to small & medium businesses globally in a broad spectrum of industries. With 20+ years of expertise in Digital Transformation, we help our customers to improve their business performance significantly. With cutting-edge technology, Agile development, and best coding practices, we are proud to offer one of the most Usable, Reliable, and Secure software solutions. We are certified as a CMMI level 3 company, Great Place to Work in 2019 & Top Software Developers in India by Clutch. -head office in Pune, India, we have two state-of-the-art delivery centers in Pune and Ahmedabad.
About The Role
We are seeking an experienced SQL Developer with a strong background in handling large datasets and optimizing database performance. The ideal candidate will be responsible for maintaining and evolving Data Warehouse structures that support BI and analytics use cases. While deep BI tool knowledge is not mandatory, a basic understanding of Power BI or similar tools is a plus.
Job Responsibilities
- Develop and optimize complex SQL queries for large and complex datasets.
- Monitor and enhance query performance, indexing strategies, and data access patterns.
- Design and maintain schema changes in the Data Warehouse in support of BI and reporting needs.
- Collaborate with BI developers and business stakeholders to ensure data models align with reporting requirements.
- Implement and manage data pipelines for transforming and loading data into the warehouse.
- Work closely with teams to troubleshoot data discrepancies and performance bottlenecks.
- Ensure data accuracy, consistency, and integrity across integrated systems.
- Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field.
- 5+ years of experience in SQL development with large datasets in enterprise environments.
- 2+ years of experience in managing and maintaining Data Warehouses (on-prem or cloud-based).
- Exposure to BI tools (Power BI, Tableau, etc.) is a plus but not required.
Expert-level SQL skills, including stored procedures, CTE, views, indexing, joins, partitioning, and performance tuning.
Experience with database platforms such as MS SQL Server, Azure SQL.
Solid understanding of data warehousing concepts, dimensional modeling.
Good To Have:
Scheduling jobs in SQL server agent
Familiarity with ETL/ELT tools or frameworks like SSIS, SSAS Tabular
Basic knowledge of PowerBI
Experience with scripting or programming languages (e.g., C#, PowerShell) is a plus.
- Strong analytical thinking and attention to detail when working with complex data models.
- Good communication skills to interact with BI/Analytics teams and business stakeholders.
- Self-driven and capable of working independently in a remote or hybrid setup.
- Agile/Scrum team experience is preferred.
Job Requirements