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.
Requirements:
Technical Skills:
- 7+ years of experience in data warehousing and business intelligence.
- Strong expertise in SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
- Good understanding of SQL Server architecture and SQL Queries.
- Experience with PowerBI Desktop and PowerBI Service, including DAX.
- Knowledge of data modeling and data governance.
- Experience with data integration and ETL processes.
Soft Skills:
- Strong analytical and problem-solving skills.
- Excellent communication and collaboration skills.
- Ability to work with cross-functional teams.
- Strong attention to detail and quality.
Education:
- Bachelor's degree in Computer Science, Information Technology, or related field.
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.