Data Engineer (Senior/ Team Lead Level)

Senior - Team Lead Data Engineer

Key Responsibilities:

• Database Administration & Data Warehouse Management: Lead the design, implementation, and maintenance of complex data warehouse environments for financial clients. Manage relational databases (e.g., Oracle, MSSQL, PostgreSQL) to ensure stability, scalability, and optimal performance for financial transaction processing and reporting.
• Data Integration & ETL Management: Oversee ETL (Extract, Transform, Load) processes, ensuring the accurate and efficient integration of large-scale financial data into data warehouses. Collaborate with data engineering teams to ensure high-quality, reliable data for reporting and analytics.
• Performance Tuning & Optimization: Proactively monitor and tune the performance of data warehouses, ensuring optimal response times for financial analytics. Implement index optimization, query optimization, and other performance-tuning techniques to ensure seamless data processing for financial decision-making.
• Data Backup, Disaster Recovery, and High Availability: Design and manage backup strategies, disaster recovery solutions, and high availability setups for data warehouse systems, ensuring that financial data is always protected and recoverable in the event of system failure.
• Financial Industry Compliance: Ensure the security of data warehouse environments by implementing and managing comprehensive security controls. Maintain compliance with financial industry regulations such as PCI-DSS, SOX, and GDPR, applying encryption, secure access controls, and regular audits to protect sensitive financial data.
• Presales Support: Collaborate with sales teams to provide technical expertise during presales activities. Assist in designing custom data warehouse and analytics solutions for financial clients, addressing their specific regulatory, security, and technical requirements. Prepare technical proposals and participate in client presentations.
• Project Management: Lead data warehouse and analytics projects from inception to completion, ensuring that projects are delivered on time, within scope, and meet financial industry standards. Coordinate with internal teams and vendors, managing timelines, resources, and client communications.
• Resource Management: Oversee resource allocation and team management, ensuring the data warehouse team is staffed effectively. Mentor and guide junior engineers, providing technical leadership and ensuring continuous professional development.
• Collaboration & Leadership: Collaborate with internal and external team ex. software developer, DevOps, Software Engineer, IT team and other related team, provide technical leadership to database team and mentoring junior.
• Client Engagement: Serve as a trusted advisor to financial clients, offering guidance on data architecture, data security best practices, performance optimization, and regulatory compliance. Build and maintain strong client relationships to ensure long-term satisfaction and ongoing business opportunities.
• Log Analysis and Monitoring: Implement and manage advanced monitoring systems to track database performance, identify anomalies, and address potential issues before they impact business operations. Lead the response to database incidents, ensuring minimal disruption to financial clients and conducting post-incident reviews to enhance future resilience.
• Data Security and Compliance: Oversee database security, including managing user access, roles, encryption, and security best practices to protect sensitive data.
• Incident Response: Lead the response to Database and security incidents, ensuring quick resolution with minimal disruption to client operations. Conduct post-incident reviews to enhance security measures and prevent future occurrences.
• Technical Documentation: Develop and maintain comprehensive documentation, including architecture diagrams, data models, ETL processes, security configurations, and disaster recovery plans. Ensure that documentation meets the financial industry’s compliance standards and is kept up-to-date..

Qualifications:

• Education: Bachelor’s degree in Computer Engineer, Computer Science, Information Systems, Data Management, or a related field. Certifications such as Oracle Database Administrator (OCA/OCP), Microsoft Certified: Azure Database Administrator, PostgreSQL Certified: EDB Postgres Advanced Server Associate Certification , EDB Professional Certification
• Experience: 3+ years of experience in data warehouse management, database administration, and data analytics, particularly within the financial industry. Experience working with financial data systems and ensuring compliance with industry regulations.
• Native Thai speaker with good English proficiency is MANDATORY
• Technical Skills:
• Expertise in relational databases (e.g., Oracle, MSSQL, PostgreSQL) and data warehousing technologies.
• Proficiency in SQL, database query optimization, and performance tuning for financial data processing.
• Strong knowledge of ETL processes, Data pipeline and tools (e.g., Alteryx, Tableau, Pentaho, Apache Airflow, Data Factory, ODI, SSIS) for financial data integration.
• Experience with cloud-based database and data warehouse solutions (e.g., AWS Redshift, Google BigQuery, Azure SQL).
• Familiarity with data governance, data quality management, and regulatory compliance requirements in the financial industry.
• Presales Experience: Demonstrated experience supporting sales teams during presales engagements by providing technical expertise in the design and proposal of data warehouse solutions for financial clients. Ability to participate in client presentations and address technical questions.
• IT Risk Management: Strong understanding of IT risk management principles, with experience identifying and mitigating security risks in financial database and data warehouse environments.
• Project Management: Proven ability to manage complex data warehouse projects, including resource planning, timeline management, and stakeholder communication. Experience managing financial data projects that require strict adherence to compliance and security standards.
• Resource Management: Effective in managing team resources, mentoring junior engineers, and ensuring projects are adequately staffed and delivered successfully.
• Client-Facing Skills: Excellent communication skills, with the ability to translate complex technical and regulatory concepts into clear, non-technical language for clients, and build strong, trusting relationships.

Desired Attributes:

• Passion for network and security technologies with a commitment to staying current with industry trends and best practices, particularly in the financial sector.
• Ability to thrive in a fast-paced, client-focused environment.
• Strong organizational skills with meticulous attention to detail.
• Proactive problem-solving ability with a focus on delivering secure and compliant solutions.