Data Analysts with Data Modeling (On-Prem & Cloud)

Dicetek LLC; Abu Dhabi; On-site; AED 120,000 - 200,000; Full time

Job summary

A data solutions company in Abu Dhabi is looking for an experienced Data Analyst. The ideal candidate will have over 5 years of experience in data analysis and modeling, strong proficiency in SQL, and hands-on experience with data modeling tools. Responsibilities include analyzing large datasets, designing data models for cloud environments, and collaborating with engineering teams. This opportunity is ideal for someone who excels in analytical skills and problem-solving.

Qualifications

• 5+ years of experience in data analysis and data modeling.
• Strong proficiency in SQL for querying, profiling and validation.
• Hands-on experience with data modeling tools and cloud databases.

Responsibilities

• Analyze and interpret large datasets to generate actionable insights.
• Design, develop and maintain data models for cloud and on-premise environments.
• Collaborate to ensure proper implementation of data models.

Skills

Data analysis

SQL proficiency

Data modeling tools

ETL/ELT processes

Analytical skills

Job description

Notice period: Ready to join Immediate to 15 days Only.

Required Skills and Qualifications

• 5+ years of experience in data analysis and data modeling.
• Strong proficiency in SQL for querying, profiling and validation.
• Hands-on experience with data modeling tools and exposure to on-premise databases and Cloud databases.
• Familiarity with ETL/ ELT processes, data pipelines and cloud data platforms.
• Strong analytical, problem solving and communication skills.

Key Responsibilities

• Analyze and interpret large datasets to generate actionable insights for business stakeholders.
• Design, develop and maintain conceptual and physical data model for both on-premise and cloud database environments.
• Collaborate with Data Engineers, Architects and Business analysts to ensure proper implementation of data models in data warehouses, lakes, or marts.
• Map business requirements to data sources and identify data gaps or redundancies.
• Perform data profiling, validation and quality assessments.
• Support ETL/ELT processes and integration of multiple data sources.
• Document data definitions, lineage and metadata to ensure consistencies and governance.