ETL and Data Quality Analyst

The role is critical for sourcing data from the operational systems, applying the business transformation rules and preparing a database-loadable file for the Data Warehouse. The role is also involved working with Business users and 3rd party suppliers to understand, analyze, and refine product data and reporting requirements and business rules and to translate these requirements into data models, data mapping and transform practices.

Job Responsibility

• Work closely with users and the Data Analytics team to determine business reporting requirements and implementation of these requirements.
• Work with Business users and 3rd party suppliers to understand, analyse, and refine product data requirements and business rules. Translate requirements into technical specifications, data models, data mapping and transform practices.
• Source data from the operational systems, apply the business transformation rules and prepare a database-loadable file for the Data Warehouse.
• Participate in the daily operational ETL support rotation.
• Support the data warehouse design and integration efforts, including data sourcing and transformation, logical/physical data modelling and ETL development in support of the BI application.
• Ensure the correct application of the business rules through data query after the data is loaded into the Data Warehouse.

Technical / Professional Competencies

• Degree in Engineering / Computer Science or a related field
• More than 3 years of work experience in a business and technology-focused IT environment
• Extensive use of SQL and RDBMS systems (Oracle, SQL Server, etc.)
• Experience in .designing and building complete ETL/SSIS processes moving and transforming data for ODS, Staging, and Data Warehousing.
• Multiple OS and DB platform experience