JOB DESCRIPTION / ROLE
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.
Find Top Talent
Other jobs you might be interested in
Service Engineer Jobs in DubaiField Engineer Jobs in Dubai
Senior Civil Engineer Jobs in Dubai
Show More