DWH Specialist
Dubai OneTeam – OneTeam / Contract / Remote
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. know what they’re doing, why they’re doing, not blown by the 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 the experience yet don't hesitate to challenge in full to unlearn.
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 ’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 ’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;
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 model
+ Optimizing existing DWH dimensional model to deliver better decision making performance
+ Implementing best practises for data warehouse modeling based on the requirements of the customer
+ Identifying new data sources and integrating them to the DWH architecture using best practices
+ Optimizing existing queries, reports and improving performance
+ Creating new ad-hoc reports based on pure SQL depending on the client’s requirements
+ Creating/optimizing ETL processes based on customer’s ETL tool of choice
+ Identifying best architecture practices on Redshift based on the data model and implementing them
+ Taking responsibility for architectural and development decisions
+ Communicating with client regularly and leading development efforts
Qualifications
+ Minimum 4+ years of experience in Data Warehousing projects
+ Good 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 processes
+ Experience in business requirement prioritization and serving accurate and consistent data to business users
+ Experience in ETL development with ETL tools such as Talend, ODI, Informatica etc.
+ Understanding of cloud DWH concepts and how cloud data warehouses work
+ Excellent knowledge of SQL and capable of writing complex SQL queries
+ Experience working with highly analytical complex SQL queries and query optimization
+ Strong analytical and problem solving skills
+ Excellent communication and interpersonal skills
+ Advanced in English
+ Experience working with AWS technologies, specifically Redshift (nice to have)
