Senior Data Warehouse Engineer
HR PLACEMENT CONSULTANTS (HRPC)
5 - 10 years
Mumbai
Posted: 10/12/2025
Getting a referral is 5x more effective than applying directly
Job Description
Position - Sr. Data Warehouse Developer
Location - Mumbai
Total Experience - 10+ Years
Qualifications Educational - B.Sc/M.Sc/BCA/MCA IT or Computer Science
Domain/Vertical - Insurance and / or Finance (preferred)
Relevant Enperience:
- 7+ years of experience into a similar role
- Experience of SQL and Databases (MS SQL Server, DB2, Postgres, Mongo).
- Experience with dimensional modelling and Kimball methodology.
- Strong proficiency with BI tools such as SSRS, Microsoft Power BI, etc.
- Expertise in SQL, ETL development, data pipelines, and data integration.
- Experience with cloud-based platforms (AWS, Azure, Google Cloud) is a plus.
Responsibilities:
Process:
- Design, develop, and maintain efficient dimensional data models and data marts.
- Architect enterprise data models to support analytical and business intelligence needs.
- Implement and maintain ETL processes for seamless data integration.
- Collaborate with cross-functional teams to gather data requirements and ensure high-quality data solutions.
- Optimize query performance, ensuring high availability and responsiveness of the data warehouse platform.
- Ensure data integrity, security, and consistency across all systems and solutions.
- Generate and produce descriptive and diagnostic analytics for the business.
- Provide mentorship and guidance to junior developers, ensuring best practices are followed.
- Continuously improve data warehouse architecture to support evolving business needs and emerging technologies.
Client:
- Provide authoritative expertise and advice to clients and stakeholders.
- Build and maintain relationships with clients, internal and external stakeholders.
- Delivery of service level agreements made with internal and external stakeholders and clients.
- Make recommendations to improve client service within area of responsibility.
- Participating in and contribute to a culture which build rewarding relationships, facilitates feedback and provides exceptional client service.
People:
- Develop and maintain productive and collaborative working relationships with peers and stakeholders.
- Positively influence and participate in change initiatives within the team and across the business.
- Continuously develop own expertise in terms of professional, industry and legislation knowledge.
- Contribute to continuous innovation through the development, sharing and implementation of new ideas.
- Take ownership for driving career development through available channels.
Finance:
- Identify opportunities to enhance cost effectiveness and increase operational efficiency.
- Provide input into the risk identification processes and communicate recommendations in the appropriate forum.
Mandatory Technical Skills:
- Understanding of SQL and Database technologies (MS SQL Server, DB2, Postgres, Mongo).
- Experience with dimensional modelling and Kimball methodology.
- Strong proficiency with BI tools such as SSRS, Microsoft Power BI, or similar platforms.
- Expertise in SQL, ETL development, data pipelines, and data integration.
- Experience with cloud-based data platforms (AWS, Azure, or Google Cloud) is a plus.
- Excellent problem-solving and troubleshooting skills.
- Strong communication skills, with the ability to work with both technical and business stakeholders.
Please contact - Shraddha Mahajan
Services you might be interested in
Improve Your Resume Today
Boost your chances with professional resume services!
Get expert-reviewed, ATS-optimized resumes tailored for your experience level. Start your journey now.
