Domain : BFSI Life Insurance

Data Warehouse Analyst

Interested Candidates Share there CV on : [email protected]| (phone hidden)

Job Summary

We are looking for an experienced Data Warehouse Analyst with around 3 years of experience in data warehousing, SQL, data analysis, and reporting. The ideal candidate will be responsible for analyzing business requirements, working with data warehouse systems, validating data, and supporting data-driven business decisions.

Roles & Responsibilities :

1. Analyze business requirements and translate them into data and reporting requirements.
2. Develop, optimize, and execute complex SQL queries for data extraction and analysis.
3. Work with data warehouse structures, including fact and dimension tables. Perform data validation, reconciliation, and quality checks to ensure data accuracy.

4. Analyze data from multiple sources and identify trends, inconsistencies, and anomalies.
5. Support ETL/ELT processes and troubleshoot data-related issues.
6. Collaborate with Data Engineers, BI Developers, Business Analysts, and business stakeholders.
7. Create and maintain reports, dashboards, and data analysis outputs as required.
8. Document data definitions, mappings, business rules,



and analytical processes.

9. Investigate data discrepancies and provide root-cause analysis.
10. Assist with performance optimization of queries and data warehouse processes.
11. Ensure data integrity, consistency, and availability across reporting systems.

Required Skills and Qualifications:
1. 3 years of experience in Data Warehousing / Data Analytics / BI.
2. Strong proficiency in SQL.
3. Good understanding of ETL/ELT concepts and data warehouse architecture.

4. Experience working with Fact and Dimension tables, Star/Snowflake schemas, and data modeling concepts.
5. Strong knowledge of data validation and reconciliation techniques.
6. Experience with reporting/BI tools such as Power BI, Tableau, or similar tools.

7. Good understanding of databases such as SQL Server, Oracle, PostgreSQL, MySQL, or similar.
8. Strong analytical and problem-solving skills.
9. Ability to understand business requirements and convert them into technical/data requirements.

10. Valuable communication and stakeholder-management skills.

Pay: Up to ₹500,000.00 per year

Work Location: In person

📌 Data Warehouse Analyst (Vidyavihar)
🏢 ComUnus Technologies
📍 Vidyavihar