Data Engineer

ParagonCorp (Jakarta, Jakarta, Indonesia)

DKI Jakarta, Indonesia

Since 1985, Paragon has been developing rapidly. We create excellent beauty brands such as Wardah, Make Over, Emina and Putri with GMP (Good Manufacturing Practice) and HAS (Halal Assurance System) certification. With more than 10.000 personnels all over Indonesia and annual production around 185 million pieces, Paragon has become one of the largest cosmetic manufacturer in Indonesia. We conduct an end-to-end process, from ideation to production and until the distribution, even with many supporting roles in between. The integrity, agility, and persistency of our people preserves Paragon’s position as the market leader in Indonesia. Willingness to create a greater future is one of the reason for us to make our work continuously improved and always innovate.

About this position

The Data Engineer will be responsible for designing, developing, and maintaining data transformation processes, optimizing data workflows, and collaborating with various stakeholders to ensure data quality and compliance.

Responsibilities

• Design, develop, and maintain data transformation processes to cleanse, transform, and aggregate data within the data warehouse.
• Optimize and streamline data workflows to ensure efficient data processing and storage in the data warehouse.
• Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and implement appropriate data transformations.
• Develop and maintain data warehouse schemas, tables, and views to support reporting and analytics needs.
• Implement data governance policies and standards to ensure data quality, security, and compliance.
• Monitor data warehouse performance, troubleshoot issues, and optimize for scalability and efficiency.

Requirements

• Minimum of 2 years of professional experience as a Data Engineer or similar role.
• Proficiency in SQL for data extraction, transformation, and analysis from Snowflake or relational databases.
• Proficiency in Tableau Desktop and Tableau Server, including advanced knowledge of dashboard development, data blending, calculated fields, parameters, and filters.
• Knowledge and skills in ETL (Extract, Transform, Load) processes and tools to efficiently extract data from various sources, transform it, and load it into the data warehouse.
• Strong understanding of data analysis techniques, i.e.: data visualization best practices.
• Understand data modelling techniques including dimensional modelling, star schema design, and slowly changing dimensions (SCD).
• Familiarity with data quality assurance techniques and tools to ensure data accuracy, consistency, and completeness.
• Ability to collaborate effectively with business and technical counterparts to understand requirements and translate them into technical solutions.
• Strong analytical and problem-solving skills with attention to detail.
• Excellent communication and documentation skills to convey technical concepts to non-technical stakeholders.
• Ability to work independently and in a team-oriented environment, managing multiple tasks and priorities effectively.