DescriptionsLooking forward to a technology-driven career in a dynamic environment KPMG is now on the lookout for a Solutioning & ETL Lead within the KPMG Lighthouse, our Center of Excellence (CoE) in Data and Analytics, Automation, AI and Digital Solution in our Malaysia office. 'Digital Solution, Enhanced Business Productivity' You will be joining the Lighthouse Team to work as a Solutioning & ETL Lead here at KPMG. We work closely with our clients across diversified industries such as retail, FMCG, manufacturing, financial services, telecommunications, etc. to shape and lead technology-enabled business change engagements, typically motivated by digital transformation agenda, realising operational efficiencies, timely management information and insights, etc. You will be joining a collaborative and energetic team of data analysts, software engineers, automation specialists, innovation specialists and business analysts that share projects delivery knowledge and experiences. Our team covers a broad range of functional and technical domains you will have the opportunity, and be expected, to grow your skill set and experience across a variety of these. The lead is a senior-level data engineer who oversees the design, development, and deployment of ETL (extract, transform, and load) processes. ETL processes are used to extract data from a variety of sources, transform it into a format that can be used by target systems, and load it into those systems. You will be responsible for ensuring that ETL processes are efficient, accurate, and reliable and work to ensure that ETL processes are compliant with all applicable regulations. In addition to the technical skills, you also need to have strong leadership and communication skills. You are responsible for managing a team of ETL developers and ensuring that they are working towards common goals. You also need to be able to communicate effectively with stakeholders from both the technical and business sides of the organization. Besides, you are expected to take part on the management and maintenance of department databases. They ensure that databases are running efficiently and securely, and that authorized users have access to the data they need. DBAs also play a key role in data security and compliance, and they often work closely with different team. If you are passionate about technology transformation and implementation projects and love finding better ways to digitalise business processes, we welcome you to embark the journey with us! Inspire Confidence. Empower Change. KPMG the Clear ChoiceResponsibilities- Develop and implement the ETL strategy for the organization. - Design, develop, and implement ETL pipelines and data integration processes that involve different data source systems, such as relational databases, flat files, and APIs - Lead and manage a team of ETL developers. - Work with stakeholders to understand their data needs and ensure that the ETL pipelines meet those needs. - Monitor and troubleshoot ETL pipelines. - Optimize ETL pipelines for performance and scalability. - Work closely with project leads or data architect and database administrator to setup database, design and manage target systems and sources integration. - Document ETL and data integration processes and solutions - Keep up to date with the latest ETL technologies and best practices. - Configure and maintaining the Team Foundation Server for the department's project. - Working alongside the infrastructure team on installation of new servers' setup, application installation and data integration setup for projects. - Design, develop, implement, and maintain databases. - Monitor and optimize database performance. - Implement and maintain database security and access. - Manage database backups and recovery. - Troubleshoot database problems and issues. - Work with users to ensure that they have the necessary access to data. - Develop and implement database standards and procedures. - Maintain, monitor and setup job scheduler for database scheduler and reminder. - Assist and help the department for database setup, architecture and data integrationRequirementsQualifications and Education requirements: - Bachelor's degree in computer science, information technology, or a related field - 5+ years of experience in ETL development - Strong knowledge of SQL and database management systems (DBMS) - Preferred to have Database Administrator certificate. - Experience with ETL tools and technologies, such as SQL Data Server Tools - (SSIS, SSAS,SSMS), Azure Databricks, Azure Data factory Experience with data modeling and data warehousing - Experience with project management methodologies, such as Agile and Waterfall - Excellent leadership and team management skills - Excellent communication and interpersonal skills Additional Skills and Qualifications: - Experience with cloud-based databases - Experience with big data technologies, such as Hadoop and Spark - Experience with data visualization and analytics tools - Experience with scripting languages, such as Python or Powershell
