Senior SQL Developer with SSIS & Power BI
Senior SQL Developer at ISS STOXX (financial market/index provider) in Mumbai who designs and optimizes SQL Server and PostgreSQL databases, builds SSIS ETL pipelines, and delivers Power BI dashboards and semantic models (DAX, Power Query) for business intelligence. Includes mentoring junior team members.
- Compensation
- Not disclosed
- Location
- Mumbai, India
- Work setup
- Onsite
- Seniority
- Senior
- Employment
- Not specified
- Experience
- 5+ years
- Category
- Not specified
- Posted
Skills
Must have
- Bachelor's degree in Computer Science, Information Technology, or related field
- Minimum 5 years of experience as a SQL Developer or Data Engineer
- Strong hands-on experience with SQL Server and PostgreSQL database development
- Proven expertise in SQL development: complex queries, stored procedures, functions, performance tuning
- Extensive experience designing and maintaining SSIS ETL solutions
- Strong experience with Power BI Desktop and Power BI Service for enterprise reporting
- Solid understanding of relational data modeling, ETL processes, and data warehousing concepts
- Proficiency in DAX and Power Query
- Excellent analytical, problem-solving, and debugging skills
- Strong verbal and written communication skills
- Passion for continuous learning and keeping up with modern data platforms
Nice to have
- Advanced Power BI knowledge: incremental refresh, composite models, row-level security
- Experience with PostgreSQL features: indexing strategies, query plans, performance optimization
- Understanding of Agile/Scrum methodologies
- Familiarity with source control systems (e.g., Git, TFS)
Full description
Let’s be #BrilliantTogether
ISS STOXX is actively hiring a Senior SQL Developer with SSIS & Power BI for Mumbai (Goregaon East) location.
Overview:
We are seeking an experienced SQL Developer with expertise in SSIS (SQL Server Integration Services), Power BI, and PostgreSQL to join our team. In this role, you will be responsible for developing and optimizing database solutions, creating and maintaining ETL (Extract, Transform, Load) processes, and delivering impactful business intelligence and analytics solutions. You will work across SQL Server and PostgreSQL environments to transform data into meaningful insights using modern reporting and visualization tools.
Responsibilities:
- Design, develop, and maintain database solutions using SQL Server and PostgreSQL, including tables, views, stored procedures, and functions
- Write and optimize complex SQL queries across SQL Server and PostgreSQL environments
- Build, enhance, and optimize robust ETL processes using SSIS to ingest, transform, and load data from multiple data sources
- Design, develop, and maintain interactive Power BI dashboards and reports to deliver actionable business insights
- Develop and manage Power BI semantic models, including relationships, calculated columns, and measures using DAX
- Use Power Query to extract, transform, and shape data from SQL Server, PostgreSQL, and other data sources
- Publish, manage, and maintain reports and datasets in Power BI Service, including workspace management and scheduled data refreshes
- Apply Power BI reporting best practices related to performance tuning, data modeling, row-level security, and user experience
- Optimize database performance through indexing, query tuning, partitioning, and efficient data model design in both SQL Server and PostgreSQL
- Collaborate with cross-functional teams to gather business and reporting requirements and translate them into scalable data and BI solutions
- Provide technical mentorship and guidance to junior team members on SQL, SSIS, PostgreSQL, and Power BI best practices
- Stay current with emerging trends and best practices in data engineering, analytics, Power BI, and open-source database technologies
Qualifications:
- Minimum a Bachelor’s degree in Computer Science, Information Technology, or a related field
- Minimum of 5 years of experience as a SQL Developer or Data Engineer
- Strong hands-on experience with SQL Server and PostgreSQL database development