Data Engineer - Data Warehouse & ETL

About the role

Data Engineers design and build the data warehouse and the related extraction, transformation and load (ETL) functions. They analyse what the business wants to achieve with its data and design the best possible ETL and BI processes around those goals.

Key responsibilities

• Develop data models and data marts derived from various source systems.
• Build and maintain ETL scripts that move data from sources into staging areas, the data warehouse and data marts.
• Use existing objects and code where appropriate to reduce development effort and enforce consistent business rules.
• Identify opportunities for analysis and reporting solutions within the company.
• Evaluate and select data modelling, BI and data warehouse tools.
• Translate business requirements into technical data models and data marts, and contribute to the BI initiative and strategy.
• Communicate BI strategy and concepts to other business users.
• Document development clearly to company standards, support team members, help establish new standards and processes, and report task status and problems to the project lead.

Required profile

• Minimum bachelor's degree in computer science, BIT, BBIT or a related field; a master's degree is preferred.
• 1-2 years of experience in data engineering or a related field, with additional exposure to Big Data methodologies.

Required skills

• Strong knowledge of RDBMS and SQL.
• Familiarity with ETL tools such as Talend, Informatica, SSIS or IBM Infosphere Datastage.
• Experience with Big Data technologies such as Hadoop and Cloudera is preferred.