Senior Data Warehouse 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

Location: Mumbai ( WFO )
Notice Period: Immediate - 30 Days
Experience: 5+ Years of experience
Relevant experience: 3 Years minimum
Interview process: 2 rounds of virtual interviews

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 having proficiency in SSIS, SSAS and SSRS.

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