Job description for Data Scientist at PT Avows Technologies
Requirements:
- Minimum 3–5 years of experience in Data Modelling, Data Engineering, or Data Warehousing, preferably within the banking industry.
- Strong understanding of Data Warehouse, Data Mart, and Data Lake concepts.
- Proven experience in database schema design (ERD) and SQL query optimization.
- Familiarity with project management tools such as Jira, Trello, or ClickUp.
- Proficient in developing and managing ETL (Extract, Transform, Load) pipelines.
- Capable of implementing data validation, data cleansing, data lineage tracking, and metadata management in accordance with banking standards.
- Experienced in preparing datasets for Power BI, Tableau, or Qlik to support business analytics and reporting requirements.
- Certifications or training in Big Data, Python, or SQL Programming will be considered an advantage.
Responsibilities:
- Design, develop, and maintain enterprise data models, data warehouses, data marts, and data lake solutions.
- Build, optimize, and monitor ETL/ELT pipelines to ensure reliable and efficient data integration.
- Develop and maintain database schemas, data structures, and SQL queries to support business and analytical requirements.
- Ensure data quality through data validation, cleansing, reconciliation, and governance processes.
- Implement and maintain metadata management and data lineage documentation.
- Collaborate with business stakeholders, analysts, and technology teams to understand data requirements and deliver scalable solutions.
- Support reporting and analytics initiatives by preparing high-quality datasets for BI platforms such as Power BI, Tableau, or Qlik.
- Monitor data platform performance and recommend improvements to enhance efficiency, scalability, and reliability.
- Ensure compliance with banking regulations, data security standards, and internal governance policies.
- Participate in project planning, progress tracking, and cross-functional collaboration using project management tools.



