Staff Data Engineer

NTUC FIRST CAMPUS LIMITED; Singapore; On-site; SGD 80,000 - 110,000; Full time

Job summary

A leading educational organization in Singapore is seeking a Senior Data Engineer to define and execute big data initiatives, optimize data models, and ensure governance compliance. The ideal candidate will have a Bachelor's or Master's degree in Computer Science or equivalent, along with extensive experience in data infrastructure and SQL. This role includes mentoring junior analysts and championing a data-driven culture. The company offers competitive benefits and a collaborative work environment.

Qualifications

• Experience as a Senior Data Engineer with Data Management and Governance exposure.
• 2-3 years in data integration projects with Google Cloud or AWS.
• Expert-level proficiency in SQL including complex queries.

Responsibilities

• Define and execute the strategic roadmap for big data initiatives.
• Design and optimize scalable data models and ETL processes.
• Champion a data-driven culture and mentor junior team members.

Skills

Data Management

SQL proficiency

Data Modeling

Data Analytics

Stakeholder Management

Education

Bachelor’s or Master’s in Computer Science, Engineering, Math

Tools

Google Cloud

AWS services

PostgresSQL

MSSQL

Apache Kafka

Job description

KEY JOB RESPONSIBILITIES:

• Define and execute the strategic roadmap for big data and data analytics initiatives, aligning with overall business objectives.
• Partner with various business units to understand their data needs and deliver tailored analytical solutions.
• Identify opportunities to leverage data for competitive advantage, innovation and enhanced decision making across the organization.
• Identify high impact data products/analytics projects through scoping with end users
• Translate complex business problems into data analytics solutions and strategic programs/products.
• Communicate complex analytical findings and recommendations to non-technical stakeholders and senior leadership effectively.

Data Engineering & Architecture

• Pipeline & Model Design: Design, build, and optimize scalable data models and ETL/ELT processes, ensuring seamless integration from source systems to the data lake and internal data mining models.
• Infrastructure Optimization: Maintain and tune the performance of the analytics infrastructure to ensure the accurate, reliable, and timely delivery of key insights for decision-making.
• Secure Data Delivery: Develop secured pipelines and data endpoints (APIs/Views) to efficiently expose raw and analytical data to downstream systems and business stakeholders.
• System Integration: Orchestrate complex integrations between source systems, the data lake, and analytics layers to create a unified data ecosystem.

Governance, Security & Standards

• Engineering Standards: Define and enforce data engineering best practices and coding standards across the team to ensure code quality and maintainability.
• Security & Risk: Implement robust security controls for sensitive and PII data, ensuring strict adherence to risk assessments and conducting periodic access reviews.
• SLA & Quality Management: Define and manage Service Level Agreements (SLAs) and data quality frameworks for all owned data assets.
• Governance Compliance: Lead departmental adherence to Data Governance policies, ensuring the team remains compliant with the latest regulatory updates.
• Asset Management: Maintain an accurate, approved data asset inventory and facilitate secure interdepartmental data sharing requests.

Leadership

• Team Mentorship: Responsible for coaching and mentoring junior members of the team to improve their commercial acumen, presentation, and analytical skills.
• Exercise leadership in guiding junior analysts to scope, plan, design and execute projects
• Culture Shift: Actively champion the shift towards a data-driven culture, based on continuous improvement.

QUALIFICATIONS AND JOB REQUIREMENTS:

• Bachelor’s or Master’s in Computer Science, Engineering, Math, or equivalent practical experience.
• Relevant work experience as a Senior Data Engineer having exposure to Data Management and Governance aspects.
• Experience with Data Analytics Infrastructure. 2-3 years’ experience in designing, building and operationalizing medium to large scale data integration projects with Google cloud or AWS services.
• Familiarity with SQL and one or more data Lake, Data Warehouse, RDBMS technologies (e.g. PostgresSQL, MSSQL, Oracle, SAP Hana, Hive, etc.)
• Able to work independently with large and multiple data sets from various business processes and systems, to support the business in achieving strategic objectives.
• Familiarity with python or any equivalent programming language.
• Expert-level proficiency in SQL (complex window functions, query optimization, CTEs)
• Strong background in data modeling (Kimball dimensional modeling, star/snowflake schemas, slowly changing dimensions) and data handling best practices
• Has experience in stakeholder management, project management and leading a team.
• Good to have proficiency in major AI models, their deployment and experience in using AI to develop innovative data products and solutions.
• Good to have experience with real-time / streaming pipelines: Kafka, Kinesis, Pulsar, or Flink

Skills and Attributes

• Strong interest in understanding and solving business problems with data
• Familiarity with cloud technologies, e.g. Google Cloud Platform using Cloud Composer, GCE/GKE, Google Data Studio, and Big Query.
• Self-starter, able to work independently to drive and deliver projects.