BI Developer (SSIS)

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.

• 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.

• 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

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.

Who are we?

Amaris Consulting is an independent technology consulting firm providing guidance and solutions to businesses. With more than 1,000 clients across the globe, we have been rolling out solutions in major projects for over a decade – this is made possible by an international team of 7,600 people spread across 5 continents and more than 60 countries. Our solutions focus on four different Business Lines: Information System & Digital, Telecom, Life Sciences and Engineering. We’re focused on building and nurturing a top talent community where all our team members can achieve their full potential. Amaris is your steppingstone to cross rivers of change, meet challenges and achieve all your projects with success.

At Amaris, we strive to provide our candidates with the best possible recruitment experience. We like to get to know our candidates, challenge them, and be able to give them proper feedback as quickly as possible. Here's what our recruitment process looks like:

Brief Call: Our process typically begins with a brief virtual/phone conversation to get to know you! The objective? Learn about you, understand your motivations, and make sure we have the right job for you!

Interviews (the average number of interviews is 3 - the number may vary depending on the level of seniority required for the position). During the interviews, you will meet people from our team: your line manager of course, but also other people related to your future role. We will talk in depth about you, your experience, and skills, but also about the position and what will be expected of you. Of course, you will also get to know Amaris: our culture, our roots, our teams, and your career opportunities!

Case study: Depending on the position, we may ask you to take a test. This could be a role play, a technical assessment, a problem-solving scenario, etc.

As you know, every person is different and so is every role in a company. That is why we have to adapt accordingly, and the process may differ slightly at times. However, please know that we always put ourselves in the candidate's shoes to ensure they have the best possible experience.

We look forward to meeting you!