Data Warehouse (DW) Developer

at  Kredit Pintar

Kredit Pintar is a Fintech (Financial Technology) company that has a mission to improve the quality of life of Indonesian people by providing various short-term loan options. To realize the mission as a Fintech Company that can advance the country, Kredit Pintar opens opportunities for those who want to contribute in improving the quality of life by investing in the form of providing loans to borrowers in Kredit Pintar. With various investment options, anyone can now participate safely because Kredit Pintar ensures the security and confidentiality of the data of the giver and the borrower.
As one of the top players in P2P Lending platform with the niche of personal loan in Indonesia, Kredit Pintar can help you shape your future. We have a diverse culture because we value our employees based on their skills, regardless of their background. With a fun and dynamic working pace, we believe you will enjoy your journey with us.
Designing and implementing robust data warehouse architectures that support business requirements
Developing ETL (Extract, Transform, Load) processes to integrate data from multiple sources into a centralized repository
Creating data models that accurately represent business processes and support analytics
Ensuring the security of the data warehouse and compliance with data governance standards
Optimizing data warehouse performance through indexing, partitioning, and query tuning
Collaborating with business analysts and data scientists to understand analytical needs and deliver appropriate data structures
Writing complex SQL queries for data manipulation and retrieval
Testing and troubleshooting data systems to ensure accuracy and quality of data
Documenting the data warehouse environment and maintaining metadata repositories
Monitoring data warehouse systems to ensure reliability and performance standards are met
Keeping abreast of new technologies and methodologies in data warehousing and big data
Providing support and training to end-users on data warehouse usage and best practices
Bachelor’s degree in Computer Science, Information Technology, or a related field.
Proven experience as a Data Warehouse Developer or similar role.
Strong knowledge of database management systems (DBMS) and SQL.
Experience with data warehousing tools and technologies (e.g., Oracle, SQL Server, Teradata).
Proficiency in ETL tools (e.g., Informatica, Talend, SSIS).
Experience with data modeling and database schema design.
Strong analytical and problem-solving skills.
Excellent communication and collaboration skills.
Detail-oriented with a focus on data accuracy and quality.
Ability to work independently and as part of a team.
Experience with BI and analytics tools (e.g., Tableau, Power BI) is a plus.
Knowledge of data governance and data quality best practices.
Familiarity with data privacy and security regulations.
Experience with cloud-based data warehousing solutions (e.g., AWS Redshift, Google BigQuery) is a plus.
Strong organizational and time management skills.
Ability to manage multiple projects and priorities simultaneously.
Experience with scripting languages (e.g., Python, R) is a plus.
Knowledge of big data technologies (e.g., Hadoop, Spark) is a plus.
Certification in data warehousing or related fields is a plus

Please refer the Job description for details