ABOUT OneTeam:OneTeam, headquartered in Dubai, is a company that emerged as a spinoff after 15 years of VNGRS’s domain experience, provides software consultancy services to Gulf Region countries, and consists of independent consultants from all over the world.At OneTeam;We love what we’re doing, we don’t pick favorite “clients/works”.We understand our partners’ needs, discover them even before they do.We’re laser-focused, we listen to our partners well, from inception to completion.We own the work as it’s our own and fight for it.We’re authentic and genuine.We do not copy & paste. We seek what’s the best practice and we create our own (internalized) solution.And our consultants;know what they’re doing, why they’re doing, not blown by the wind.have good communication skills, thus get on well with customers.interested in problem-solving, not stuck in the problem itself. Thus, result-oriented.focus on delivering, not making excuses.respect the experience yet don't hesitate to challenge in full force.willing to unlearn.About the position:DWH Specialist will be responsible for creating, optimizing and developing ETL flows, delivering better query/report performance and designing Data Warehouse architecture.Responsibilities Working closely with customer to understand their data sources, requirements, data architecture and data modelOptimizing existing DWH dimensional model to deliver better decision making performanceImplementing best practises for data warehouse modeling based on the requirements of the customerIdentifying new data sources and integrating them to the DWH architecture using best practicesOptimizing existing queries, reports and improving performanceCreating new ad-hoc reports based on pure SQL depending on the client’s requirementsCreating/optimizing ETL processes based on customer’s ETL tool of choiceIdentifying best architecture practices on Redshift based on the data model and implementing themTaking responsibility for architectural and development decisionsCommunicating with client regularly and leading development effortsQualificationsMinimum 4+ years of experience in Data Warehousing projectsGood Knowledge of DWH modeling concepts(EDW & Data Mart Modeling, Star Schemas, Snowflake Schemas, Dimension and Fact Tables, Slowly Changing Dimensions)Experience in designing data models for different business processesExperience in business requirement prioritization and serving accurate and consistent data to business usersExperience in ETL development with ETL tools such as Talend, ODI, Informatica etc.Understanding of cloud DWH concepts and how cloud data warehouses workExcellent knowledge of SQL and capable of writing complex SQL queriesExperience working with highly analytical complex SQL queries and query optimizationStrong analytical and problem solving skillsExcellent communication and interpersonal skillsAdvanced in EnglishExperience working with AWS technologies, specifically Redshift (nice to have)$105 - $185 a day
#J-18808-Ljbffr