Data Architect Manager

1. Education:

• University Graduate, major: Computer Science, IT or Business Management;
• At least 5 years’ experience working in Data Warehouse & Business Intelligence project, preferably working in Financial Services sector.

2. Experiences:

• Proven data team management experience;
• Expert understanding of ETL & DW processes;
• Good knowledge of RDMSs (relational database management systems) or foundational database skills;
• Good knowledge of Data Modelling and data management system;
• Good knowledge of tuning and optimization;
• Good knowledge of data warehouse/ data lake, data mart, provide end-to-end data warehouse high-level architecture sets the stage for the sections that follow, mine data such as ETL, virtualization is a long-standing "offshoot" of data warehousing;
• Good knowledge of cloud data architecture such as AWS MSK - Architecture Diagram, AWS Database Migration Service (DMS) and Schema Conversion Tool (SCT), AWS Data Sync - Architecture Diagram;
• Must have excellent understanding of normalized and dimensional data modeling skills;
• Extensive experience with database and ETL technologies (IBM Netezza, Oracle, IBM Data Stage and SAS Enterprise Guide);
• Expert command on ANSI PL-SQL & UNIX scripting;
• Extensive experience with BI Tools: Power BI / QlikSense/ Tableau / etc;
• Knowledge of at least one modern scripting language (Python, R, etc.);
• Strong oral & written communication skills;
• Strong Leadership & Time management;
• Ability to work under pressure.

3. Skills:

• Design and implement effective database solutions and models to store and retrieve company data;
• Recommend solutions to improve new and existing database systems;
• Assess database implementation procedures to ensure they comply with internal and external regulations;
• Define complex technical design/requirements for data warehousing projects;
• Perform necessary tuning of database & ETL systems and objects to ensure timing and performance goals are met. Implement best practices within the team;
• Equip team members to work on data migration from company data sources to new data warehouse;
• Equip team members to implement the Data Marts and make information available to all users in a timely fashion;
• Perform all Reporting activities with BI Tools;
• Proactively propose solutions and highlights to the business team using BI dashboards or story telling reports;
• Implement Management Dashboards to provide highlights/alert for data driven decision making;
• Bottom-up proactive and explorative approach and propose both quick-wins and adhocs analysis to consulting field teams meaningful relevant and accurate insights and recommendations;
• Top-down well cooperated with line manager to quickly drill in business questions to support Leader Team’s decision making;
• Follows through with initiatives, assignments, and issues without direction and communicate updates and statuses effectively;
• In charge of developing & executing plans and projects;
• Mentor and help develop technical competency of assigned team members;
• Create project related document;
• Work Load planning, prioritization of work, delivery, review, monitor etc.