Data Integration Specialist - ETL & Data Loading

Description: Are you a technically minded data professional who enjoys solving complex data challenges and making sure information flows accurately across systems and teams? As Data Integration Specialist - ETL & Data Loading at Allianz Partners in Bangkok, you will be responsible for the end-to-end process of loading beneficiary data into our portfolio management system - ensuring alignment with business objectives and the needs of our partners, claims teams, and reporting functions. Allianz Partners operates as a B2B2C business, connecting corporate partners such as travel companies, automotive manufacturers, and healthcare providers with their end customers through our products and services. Data is what makes this connection work, and your role sits at the heart of it. This is a full-time, permanent mid-level role for a detail-oriented specialist who is comfortable working across technical and business teams in a global environment.
Data Loading & Partner Onboarding.
Manage the onboarding of business partners at a global level, ensuring smooth integration of beneficiary data into our systems.
Coordinate with business partners and internal stakeholders on datasets, upload frequency, and data requirements.
Set up and maintain SFTP connections with business partners, ensuring secure and reliable data transfer.
Troubleshooting & Issue Resolution.
Investigate and resolve data loading issues, conducting root cause analysis for recurring problems and implementing preventive measures.
Manage multiple requests and prioritise effectively to ensure timely resolution.
Communicate outcomes and recommendations clearly to relevant stakeholders.
Process Optimisation & Compliance.
Identify and implement improvements to data loading processes to enhance efficiency, accuracy, and scalability.
Maintain awareness of data privacy regulations including PDPA and GDPR, ensuring day-to-day data handling practices are aligned with company policies.
Maintain a clear understanding of data touchpoints across all Lines of Business.
Stakeholder Collaboration.
Work closely with operations, contract implementation, claims, underwriting, and digital teams to ensure seamless data integration.
Act as a reliable point of contact for business partners and internal teams, bridging technical and business requirements.
Quality Assurance & Testing.
Support and participate in User Acceptance Testing (UAT) to ensure data quality, system functionality, and alignment with business requirements.
Implement monitoring and logging mechanisms to ensure transparency and traceability of data activities.
Continuous Improvement.
Stay current with trends, tools, and best practices in data loading and management.
Contribute ideas and improvements to enhance team processes and overall data operations.
Support knowledge sharing within the team to build collective capability.
What You'll Bring.
Solid experience in data loading, data integration, or a related data management role.
Hands-on experience with ETL tools such as Pentaho Data Integration (Kettle), SSIS, or similar platforms.
Proficiency in SQL for data querying, validation, and manipulation.
Experience setting up and managing SFTP connections or similar secure file transfer protocols.
Familiarity with scripting languages such as Python or JavaScript for data automation is a plus.
Advanced Excel skills; experience with Power Query or similar reporting tools is an advantage.
Familiarity with Agile project management tools such as Jira or Confluence is a plus.
Basic awareness of data privacy regulations - PDPA and/or GDPR - and how they apply to data handling practices.
Familiarity with AI-powered data tools or automated data quality solutions is an advantage.
Strong troubleshooting and analytical skills with the ability to resolve data issues independently.
Good stakeholder management skills - comfortable working with both technical and non-technical teams.
Customer-centric mindset with a focus on delivering accurate, timely data solutions.
Strong organisational skills with the ability to manage multiple priorities effectively.
Strong English proficiency - both written and verbal - is required for this role.
Must have full rights to work in Thailand - visa sponsorship is not provided.
What We Offer.
Competitive salary and performance-based bonus.
Provident fund contributions.
Comprehensive health insurance coverage.
Flexible working arrangements.
Annual leave and public holidays in line with Thai employment standards.
Learning and development opportunities to grow your technical career within Allianz Partners' global network.
Exposure to international data operations and cross-functional technology projects.
A collaborative, inclusive work environment at Soi Petchaburi 35, Ratchatewi, Bangkok.
f you're excited but don't meet every single requirement, apply anyway - we value potential and learning agility. Only shortlisted candidates will be contacted.
98328 | Data & AI | Professional | Allianz Partners | Full-Time | Permanent.
Allianz Partners is a world leader in B2B2C insurance and assistance, offering global solutions across automotive, travel, health, and home assistance. Present in over 75 countries, we combine the strength of the Allianz Group with a local, innovation-driven mindset. In Thailand, our technology and data teams are part of a growing hub supporting digital transformation across the APAC region and beyond. At Allianz Partners, we are committed to building an inclusive workplace where every team member can grow, contribute, and thrive.
Allianz Group is one of the most trusted insurance and asset management companies in the world. Caring for our employees, their ambitions, dreams and challenges is what makes us a unique employer. We are united by a shared commitment: to put our customers first and at the centre of everything we do. Their needs inspire our thinking and guide our actions. Together, we can build an environment where everyone feels empowered and confident to explore, grow and shape a better future - for our customers and for the world around us. At Allianz, we stand for unity: we believe that a united world is a more prosperous world, and we are dedicated to consistently advocating for equal opportunities for all. The foundation for this is our inclusive workplace, where people and performance both matter, and where integrity, fairness, inclusion and trust are at the heart of our culture. We therefore welcome applications regardless of ethnicity or cultural background, age, gender, nationality, religion, social class, disability or sexual orientation, or any other characteristics protected under applicable local laws and regulations. Join us. Let's care for tomorrow.
To Recruitment Agencies.
We have an in-house recruitment team that focuses on sourcing great candidates directly. Therefore, we do not accept unsolicited resumes from agencies or search firm recruiters. When we do work with recruitment agencies, that engagement is formalized by a contract. Fees will only be paid when such a contract is in place. Without a contract, we will not accept invoices related to unsolicited resumes, even if the candidate is ultimately hired. Please do not contact hiring managers directly.
Job skills required: SQL, ETL
Job skills preferred: Project Management, Recruitment, Javascript, Quality Assurance, Automation