Data Engineer (Pinnacle Asset Management)

POSITON OBJECTIVE

Data engineers play a crucial role in ensuring the smooth flow of data across platforms and departments by designing and implementing robust, scalable, and secure database systems. This allows businesses to have a steady stream of high-quality data for timely decision-making.

MAIN FUNCTION

They also maintain and optimize these systems to handle growing databases, unexpected issues, and new technological demands, promoting the continuous improvement of data infrastructure. Additionally, data engineers create pipelines to collect, cleanse, and structure data, transforming it into a format that data scientists and analytics teams can use to extract valuable insights and trends, thereby influencing business strategies.

JOB DETAILS

• Design, develop, and maintain robust database systems that meet the company’s data storage and retrieval needs.
• Create and manage Entity Relationship (ER) diagrams to model Data structures and relationships.
• Optimize Database performance through indexing, query optimization, and regular maintenance.
• Collaborate with Data scientists, analysts, and other stakeholders to understand Data requirements and implement effective solutions.
• Develop and enforce Data governance and Data management best practices to ensure Data integrity and security.
• Perform Data migrations, transformations, and integrations from various sources.
• Troubleshoot and resolve Database-related issues, ensuring minimal downtime and disruption.
• Stay up-to-date with the latest Database technologies and industry trends to continuously improve our Data infrastructure.

QUALIFICATIONS

• Proven experience as a Data Engineer, Database Administrator, or similar role.
• Strong proficiency in database management systems (e.g., MySQL).
• Experience with cloud-based database solutions (e.g., AWS).
• experience in designing and managing databases, including the creation of Entity Relationship (ER) diagrams.
• Familiarity with Data warehousing concepts and ETL processes.
• Knowledge of Data governance and Data management best practices.
• Strong analytical and problem-solving skills.
• Excellent communication and teamwork abilities.
• Ability to work independently and manage multiple projects simultaneously.
• Good command of English