Sr Data Warehouse Consultant

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:

1. 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.
2. 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.
3. 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.
4. Data Modeling:
   - Design and implement data models that ensure data accuracy, consistency, and performance.
   - Conduct data profiling and analysis.
5. Performance Optimization:
   - Monitor and optimize the performance of data warehouse, SSIS packages, and SSAS cubes.
   - Implement indexing, partitioning, and other optimization techniques.
6. Data Integration:
   - Collaborate with other IT teams and stakeholders to integrate data from multiple sources.
   - Ensure data quality and consistency.
7. Testing and Validation:
   - Conduct data validation, unit testing, and quality assurance of ETL processes and OLAP cubes.
   - Identify and resolve data discrepancies.
8. Documentation and Support:
   - Document processes, workflows, and standards for ETL, DWH, and SSAS solutions.
   - Provide support and troubleshooting for production issues.

1. 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.
2. 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.
3. Education:
   - Bachelor's degree in Computer Science, Information Technology, or related field.