Junior DataWarehouse Developer IDS NEXT

About IDS NEXT

Founded in 1987, IDS Next became India’s largest hotel software company in its first decade of operations and Asia’s largest in 2009. Today, IDS Next is the leading provider of smart hotel software across Southeast Asia, the Middle East, Africa, and Oceania, serving over 6,000 customers in 50 countries.

From contactless check-in, front office management, guest request and housekeeping management to payroll, finance, inventory management and procurement, IDS Next’s award-winning software automates and streamlines front and back-office hotel operations, covering all departments. Available in single modules and as all-in-one solutions, IDS Next’s smart hotel software is designed by the company’s 135 hospitality technology professionals and supported 24/7 in 30 languages.

With a standard HTNG API approach, IDS Next integrates with over 100 of the world’s leading, best-in-breed technology partners to ensure hotel operations run smoothly and securely to complement a hotel’s existing systems and solutions.

Our smart software solutions are PA DSS certified, GDPR compliant, and our business is ISO 27001 certified.

Job Description

Job title: Junior DataWarehouse Developer
Location: Mumbai
Year of experience: 2-3 Years
Salary: 7 LPA max
Notice period: Immediate - 15 Days
Mandatory Skills: SSIS,SSAS and SSRS
Interview process: Virtual intereview

About us: The Global Hospitality Technology Platform Provider Founded in 1987, IDS Next became India’s largest hotel software company in its first decade of operations and Asia’s largest in 2009. Today, IDS Next is the leading provider of smart hotel software across Southeast Asia, the Middle East, Africa, and Oceania, serving over 5,000 customers in 45 countries.

About the role: Min 3 years of hands-on experience in Data Warehouse function

Responsibilities: 

• The ideal candidate for this position will have a very strong SQL Server 2012/14 Business Intelligence background, deep analytical skills, and experience working with end users. 
• Create Integration Services (SSIS) packages and Analysis Cubes (SSAS)
• The ability to do ad-hoc SQL to research data questions, identify root causes, and interact closely with peers and the business data analysts is essential. 
• Develop and support end to end Data Warehouse and Business Intelligence solutions for analytics and management teams
• Create complex queries, data transformation, aggregation, stored procedures, and triggers
• Consult with business partners such as marketing analysts, management, and other developers to clarify program objectives, determine scope, identify problems and recommend solutions
• Performance tune ETL, stored procedures, and reports to keep databases and applications optimized; identify root causes in case of ETL failures
• Perform code reviews, data validation, and system testing for data warehouse changes
• Interact closely with members of both IT and the business

Candidate Specification:

• Expert knowledge of Transact-SQL
• Experience of the following technologies is required: SQL Server 2008/12, Azure SQL, SQL Server Integration Services, SQL Server Analysis Services
• Experience of BI tools like Power BI, Tableau or any other tool
• Knowledge of Azure Data Factory, Azure Synapse Services would be added advantage
• Experience modelling and designing Relational Databases, Star Schemas, and cubes
• Ability to innovate, multi-task and set priorities effectively
• Experience in logical and physical data modelling
• Ability to quickly understand both business and technical concepts
• Self-starter with strong verbal and written communication skills
• Experience with using MDX to query Analysis Services cubes