Job Overview: We are seeking a skilled and experienced Database Engineer to help build and maintain a high-performing databases for our company.
The ideal candidate will be responsible for designing, developing and optimizing databases to ensure seamless data access for the company. You will play a key role in organizing and structuring data while optimizing performance, ensuring data security, and collaborating with other stakeholders to drive business.
Key Responsibilities: Data Warehouse Development: Design, build, and maintain scalable and efficient data warehouse solutions, ensuring the system can meet current and future data needs.Database Design & Architecture: Create and manage relational databases and data models that support analytical and reporting requirements, aligning with business objectives.Performance Optimization: Regularly monitor and optimize database performance, ensuring high availability, stability, and efficient data access for reporting purposes.Data Integration: Manage ETL (Extract, Transform, Load) processes to integrate data from multiple sources into the data warehouse.Database Security: Ensure the integrity, availability, and security of databases, implementing best practices for backup, recovery, and user access management.Collaboration with Data Analysts: Work closely with data analysts and BI teams to understand their reporting and data needs and ensure databases are structured in a way that supports efficient data extraction and analysis.Troubleshooting & Maintenance: Identify and resolve database-related issues, including bottlenecks, errors, and failures in data processing workflows.Documentation: Maintain clear and detailed documentation of database architectures, schemas, and processes.Requirements: Bachelor's degree in Computer Science or related fieldMandarin-speaking due to work associatesFamiliarity with cloud-based data storage and processing solutions (e.g., AWS, Google Cloud, Azure)Experience in designing and implementing automated database maintenance and optimization processesKnowledge of data governance, compliance and security best practicesExperience: Minimum 3-5 years of hands-on experience in database engineering, data warehousing, or related rolesDatabase Management: Proficiency in working with relational database systems (e.g., MySQL, PostgreSQL, SQL Server, Oracle, etc.) and knowledge of NoSQL databases is a plusData Warehousing Tools: Experience with data warehousing tools such as Amazon Redshift, Snowflake, or Google BigQueryETL Expertise: Strong understanding of ETL processes and tools (e.g., Apache NiFi, Talend, Informatica, etc.).Optimization: Proven experience in optimizing database queries and overall database performance.Languages & Tools: Proficiency in SQL, Python, and database management toolsProblem Solving: Strong analytical and troubleshooting skills with the ability to resolve data-related issues efficientlyCommunication Skills: Ability to communicate technical concepts effectively to non-technical stakeholdersTeam Collaboration: A team player who can collaborate with analysts, engineers, and business leaders