https://bayt.page.link/v1TUmrkCw1dqRip19
Remote
3 Open Positions
Full Time Employee · 7-17 Years of Experience
500 Employees or more · IT Services - Insurance & TPA - Banking

Get the Bayt App

Download the Bayt App to manage your real time conversation with the recruiter
Download App
Create a job alert for similar positions

Job Description

Job Summary:

We are seeking an experienced Data Warehouse (DWH) Consultant with strong expertise in SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS). The ideal candidate will design, develop, and manage data warehousing solutions, implement ETL processes, and build and maintain OLAP cubes to support business intelligence needs.


Key Responsibilities:

Data Warehouse Design and Development:

- Design and develop scalable and robust data warehousing solutions to support business reporting and analysis needs.

- Collaborate with stakeholders to identify data requirements and develop data models.

- Implement data governance and quality control measures.


ETL Development (SSIS):

- Create and maintain SSIS packages for data extraction, transformation, and loading (ETL) from various data sources into the data warehouse.

- Troubleshoot and optimize SSIS package performance.


OLAP Cube Development (SSAS):

- Develop, deploy, and maintain SSAS OLAP cubes and tabular models to support data analysis and reporting.

- Design and implement data models for OLAP cubes.


Data Modeling:

- Design and implement data models that ensure data accuracy, consistency, and performance.

- Conduct data profiling and analysis.


Performance Optimization:

- Monitor and optimize the performance of data warehouse, SSIS packages, and SSAS cubes.

- Implement indexing, partitioning, and other optimization techniques.


Data Integration:

- Collaborate with other IT teams and stakeholders to integrate data from multiple sources.

- Ensure data quality and consistency.


Testing and Validation:

- Conduct data validation, unit testing, and quality assurance of ETL processes and OLAP cubes.

- Identify and resolve data discrepancies.


Documentation and Support:

- Document processes, workflows, and standards for ETL, DWH, and SSAS solutions.

- Provide support and troubleshooting for production issues.


Preferred Candidate

Years of Experience
Min: 7 Max: 17
Residence Location
India; Pakistan
Nationality
Bangladesh; India; Pakistan

Royal Cyber Inc. (HQ: Naperville, IL) is a leading software organization that provides services ranging from application development and deployment to training and consultancy. Since our inception in 2002, we have been assisting clients to meet the standards and demands of doing business in the rapidly changing marketplace. We are an IBM Premier Business Partner, providing services that include application design, development, and implementation of the complete WebSphere family suite, IBM Rational, Tivoli, HATS, Commerce, MQ, and Lotus. We are also an IBM Authorized Independent Trainer, specializing in Tivoli. In addition, we are a Microsoft Certified Gold Partner and a leader in Microsoft SharePoint and Microsoft Business Intelligence, providing consultancy services to clients such as Pizza Hut USA, American Express, Bell Canada and many other Fortune 500 companies. Having operations in nine countries and over 1000 domain specialists, Royal Cyber is an award winner under numerous categories for global IT implementations across industry verticals.

You have reached your limit of 15 Job Alerts. To create a new Job Alert, delete one of your existing Job Alerts first.
Similar jobs alert created successfully. You can manage alerts in settings.
Similar jobs alert disabled successfully. You can manage alerts in settings.