DWH Specialist

**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 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)

$105 - $185 a day

Apply for this job