We are looking for a skilled Data Engineer to join our ESG service delivery team. As a member of this team, you would be keenly interested in using your data engineering powers to help corporate drive meaningful and material outcomes for their ESG ambitions.
As a technical and data expert in data ingestion, data transformation and data modelling, you will collect, manage and transform large, complex and disparate data from multiple data sources into required data models and datasets that support interactive dashboards and reports. You will work closely with various stakeholders to understand their data needs and deliver automated solutions that meet them.
Responsibilities:
- Design, develop, and maintain Data pipelines, Data Warehouse and Data Marts
- Perform data extraction, transformation, and loading (ETL) processes.
- Collaborate with stakeholders to understand their data needs.
- Ensure the accuracy and reliability of data that are ingested in the data lake and transformed in the data marts that support multiple dashboards.
- Work with data source owners to determine the most efficient methods of data collection.
- Work with the dashboard developers and analysts to make sure the data is transformed and processed in a required format and data model for dashboarding.
- Troubleshoot data-related issues and maintain the data pipelines and data warehouse infrastructure.
- Stay updated with the latest data engineering trends, features, updates, and best practices.
Requirements:
- Proficiency in SQL and Python would be very important.
- Experience with Airbyte would be preferred.
- Familiarity with other ETL tools like Azure Data Factory, SSIS, AWS Glue, Airflow, Pentaho, Fivetran would be an advantage.
- Familiarity with databases like MariaDB, MySQL, Azure SQL Server, PostgreSQL, Amazon Redshift, Google BigQuery would be an advantage
- Strong knowledge of relational database theory, data modelling and architecture.
- Strong understanding of data ingestion and data engineering principles.
- Excellent problem-solving skills and attention to detail.
- Strong communication skills and working well in a team.
- Keen desire to use the power of analytics to drive ESG goals for corporates.
