ABOUT THE JOB
- Implement, maintain, and enhance Data Warehouse solutions to support business intelligence and analytics requirements.
- Develop and optimize advanced SQL/T-SQL queries, stored procedures, and data models, with a strong focus on performance tuning and optimization.
- Design, develop, maintain, and troubleshoot SSIS (SQL Server Integration Services) packages and ETL processes.
- Design and implement data integration and transformation solutions from multiple data sources into the Data Warehouse.
- Develop and maintain BI and reporting solutions to support business and analytics needs.
- Design and maintain appropriate data models, tables, views, and data structures for reporting and analytical purposes.
- Analyze and troubleshoot data and ETL issues, identify root causes, and implement effective solutions.
- Work closely with business stakeholders, Business Analysts, and technical teams to gather, clarify, and translate analytics requirements into technical BI solutions.
- Apply strong Life Insurance domain knowledge to understand business processes, data structures, and reporting requirements.
- Ensure the accuracy, reliability, performance, and maintainability of BI and Data Warehouse solutions.
- Contribute to continuous improvement of data integration, reporting, and BI development processes.
ABOUT YOU
- Bachelor’s degree in Computer Science, Information Technology, Data Analytics, or a related technical field.
- From 3+ years of experience as a BI Developer, Business Intelligence Developer, Data Warehouse Developer, or similar role.
- Strong hands-on experience with Data Warehouse implementation and maintenance.
- Advanced knowledge of SQL / T-SQL, including complex query development, performance tuning, and optimization.
- Strong understanding and practical experience in data modeling and Data Warehouse concepts.
- Hands-on experience with SSIS (SQL Server Integration Services) for ETL development, maintenance, and troubleshooting.
- Strong experience in data integration and transformation across multiple data sources.
- Experience developing and maintaining reporting and BI solutions.
- Proven experience working closely with business and technical stakeholders to understand and deliver analytics requirements.
- Advanced Life Insurance domain knowledge is a plus.
- Strong analytical, troubleshooting, and problem-solving skills.
- Good communication and stakeholder management skills.
WHY AMARIS?
- Competitive salary and 13th-month salary
- 14+ annual leaves per year
- Premium healthcare insurance, starting from your probation period
- Project reviews and yearly performance appraisal
- Annual company trips
- Teambuilding activities: Team lunch/dinner, events, and celebrations, sports clubs (football, basketball, badminton, pickleball)
- International team with flexible working time
- Tailor-made career path
- Technical workshops and training courses
- Mobility: Opportunities to be on-site abroad in our offices in over 60+ countries
Equal Opportunity
Amaris Consulting is proud to be an equal opportunity workplace. We are committed to promoting diversity within the workforce and creating an inclusive working environment. For this purpose, we welcome applications from all qualified candidates regardless of gender, sexual orientation, race, ethnicity, beliefs, age, marital status, disability, or other characteristics.
#LI-NH1
