Data Warehouse Engineer

Amazon.ae

Dubai, UAE

Ref: RP971-392

Job description / Role

Employment: Full Time

KEY RESPONSIBILITIES
• Provide day-to-day support of the data warehouse and troubleshoots existing procedures and process to improve data organization and accuracy
• Monitor and troubleshoot performance issues on data warehouse servers and assists in the development of business intelligence, business data standards, and processes
• Identify new data needs and deliver mechanisms for acquiring and reporting such information as well as addressing the actual needs
• Design and support the business’s database and table schemas for new and existent data sources for the data warehouse
• Create and support the ETL in order to facilitate the accommodation of data into the warehouse using SSIS and other technologies
• Develop logical and physical data flow models for ETL applications. Translate data access, transformation and movement requirements into functional requirements and mapping designs
• Design and develop systems for the maintenance of the business’s data warehouse, ETL processes, and business intelligence
• Understand and assess the Source to target map documents and provide the recommendations if any
• Analyze business requirements for reporting and analysis and subsequently translating the emanating results into good technical data designs
• Gather and maintain best practices that can be adopted in big data stacking and sharing across the business
• Keep abreast with technology; maintain a current level of knowledge of the technical environment relevant to industry leading practices and continuously propose innovative solutions
• Provide guidance and support to all business units
• Conduct any other activities relevant to the job.

Requirements

• Minimum a Bachelor’s degree in Computer Science, Data Science, Information Technology, Information Systems, Statistics, or any other related subject
• 2+ years of experience with SQL, ETL, Data Quality tools,
• Good exposure to SSIS, SSRS, SQL Server, PL/ SQL , DB2, Oracle, Teradata, Netezza, BE/ BTech/ MCA with adequate industry experience
• Hands on working with various types of Databases - Preferably OLAP & OLTP (building OLAP cubes using Oracle technologies or MS SQL Server Analysis)
• Troubleshooting Systems, Linux/Unix scripting and Source code control understanding.

PREFERRED QUALIFICATIONS
• Knowledge with various data sources like web services (rest, soap), unstructured data files, flat files, message queues, xml based events, databases such as Oracle, Postgres or other databases required.
• Advanced knowledge of Data Warehousing and Dimensional Data Modelling concepts required.
• Knowledge and experience with one or more programming language like Java or scripting languages like Perl highly desired.
• Knowledge in building reports and workflow design, and software development best practices
• Able to design and develop ETL solution for complex project.
• Able to work and communicate effectively with Engineers, DBAs, Business Analysts and Business users
• Able to write and Tune Complex SQL's, No SQL Databases.
• Experience in Big data is a great plus.

About the Company

Amazon.ae, formerly Souq.com, is an English-Arabic language e-commerce platform, owned by Amazon, Inc. It is the largest e-commerce platform in the Arab world. On March 28, 2017, Amazon.com Inc. confirmed it would be acquiring Souq.com for $580 million. On May 1, 2019, Souq.com became known as Amazon.ae.

Get personalised updates on latest vacancies
Job Alerts by Email
  • Personalised updates on latest career opportunities
  • Insights on hiring and employment activity in your industry
  • Typically sent twice a month
Engineer salaries in UAE

Average monthly compensation
AED 7,000

Breakdown available for industries, cities and years of experience