Main Task
1. Design and implement Data Warehouse models and database layers (Staging, ODS, Core DW, and Data Marts).
2. Develop and maintain ETL processes using SSIS for SAP S/4HANA, Salesforce, and internal web applications.
3. Build and optimize backend services using .NET 8+.
4. Develop frontend interfaces using HTML, JavaScript, PHP, CodeIgniter (CI), Bootstrap, or modern frameworks such as React/Angular.
5. Configure SQL Agent Jobs, monitoring systems, and automated error handling processes.
6. Develop and maintain reports and dashboards using Power BI and SAP Analytics Cloud.
7. Analyze and optimize data flow processes across multiple business systems.
8. Collaborate closely with global and cross-functional teams, especially the Mexico team.
9. Lead, mentor, and support mid-level developers within the project team.
10. Prepare and maintain technical documentation for database structures, ETL processes, and system architecture.
Qualifications
11. Bachelor’s Degree in Information Technology, Computer Science, or related field.
12. Minimum 2-5 years of experience as a Full Stack Developer, BI Developer, or similar role.
13. Strong expertise in SQL Server, including stored procedures, triggers, views, CTEs, window functions, and SQL Agent Jobs.
14. Proficient in .NET 8+, REST API development, MVC pattern, middleware, and dependency injection.
15. Strong frontend development skills using HTML, PHP, CodeIgniter (CI), JavaScript, Bootstrap, React, or Angular.
16. Experience with Power BI and SAP Analytics Cloud.
17. Knowledge of SAP integrations (RFC, BAPI, OData, SAP .NET Connector) is a plus.
18. Proficiency in English is mandatory for coordination with international teams.
19. Able to work independently and collaboratively in a global project environment.
20. Willing to be placed in Pasuruan, East Java