Description

You will design and maintain scalable data warehousing and BI solutions using MSBI and Hadoop platforms.

You will own the integration of heterogeneous data sources into unified systems, including OLAP schema design, dimensional modeling, and performance tuning.

Responsibilities

• Integrate heterogeneous data sources into unified data warehousing systems.
• Design and maintain OLAP schemas, attributes, facts, and metrics.
• Perform source system analysis and document high-level business model designs.
• Create and maintain technical documentation, architecture designs, and data flow diagrams.
• Implement source code versioning and standard methodologies to ensure data quality.

Required Skills

• 3+ years of experience in Data Warehousing and Business Intelligence.
• Expert knowledge of SSIS, SSAS, and other DW tools.
• Proficiency in T-SQL, stored procedures, and database performance tuning.
• Experience with ETL processes and dimensional modeling.
• Strong analytical skills for data analysis and business performance indicator tracking.
• Effective communication and presentation skills.

Preferred Skills

• Experience developing reports and dashboards using Tableau, SSRS, or Power BI.

Key Skills

Education

Any Graduate