Singapore
Cindy has worked a number of different roles in the data & analytics field with a focus on data engineering. Her current stack includes Snowflake, DBT, and Apache airflow, with prior experience working with AWS and Postgres. Her core competencies include python, sql, data modelling, data warehousing, orchestration, and extensive experience in etl/elt operations within the retail and telecommunications industries.
Key Responsibilities: • Data extraction, analysis, and transformations required to build data marts from Redshift and S3 tables using SQL scripts. • Collaborated with stakeholders and product owners to ensure smooth project delivery. • Led feature discovery and build for business missions. • Support continuous development and integration of features to match client business • Executed AWS cloud-based solutions architectures to orchestrate jobs and push to downstream sources. • Performed extensive testing using real and dummy test cases for client regulatory requirements. • Create dashboards using Power BI to showcase quarterly insights on business’s objectives and key results. • Performed preliminary exploration of source data to assess data quality and categorise entities into data domains. • Collaborated with enterprise data team to perform data analysis and assess key business use cases to future proof data model. • Implement dimensional data modelling best design principles into the construction of an integrated data model. • Detailed linage mapping between source-to-target dimensions and domains. • Supported reconciliation efforts to integrate data from different source systems. Achievements: • Established a data analytics platform to perform advanced analytics and streamline project delivery. • Automated the calculation processes for crediting customers and alleviate pressure on internal agents and subsequently, create an improved customer experience. • Designed and transformed data into feature tables used for data-driven missions and to enrich customer experience. • Concisely documented entity relationships between various source systems and outlined gaps in underlying source data to enrich client’s data strategy. • Designed and built an integrated data model to create a single source of truth to be used for business decision making.