Database Expert ( big data & data warehouse )

SWATX; Saudi Arabia; On-site; SAR 60,000 - 100,000; Full time

Job summary

An established industry player is seeking a skilled Data Warehouse Architect to design and implement robust data solutions. This role involves optimizing data warehouses for analytical queries, managing big data platforms like Hadoop and Spark, and ensuring data quality and security. You will collaborate with data scientists and business stakeholders to drive data-driven initiatives. If you have a passion for big data and a strong background in data warehousing, this opportunity offers a chance to make a significant impact in a dynamic environment.

Qualifications

• Minimum 8 years of experience in Big Data and Data Warehousing.
• Expertise in designing and implementing ETL processes.

Responsibilities

• Design, build, and maintain data warehouses and data lakes.
• Manage and administer big data platforms ensuring scalability and security.

Skills

Big Data

Data Warehousing

ETL Processes

Data Modeling

Performance Optimization

Data Governance

Hadoop

Spark

Hive

Education

Bachelor's Degree in Computer Science

Bachelor's Degree in Information Technology

Tools

Hadoop

Spark

Hive

Job description

Data Warehouse Design and Implementation:

Design, build, and maintain data warehouses and data lakes, optimizing them for analytical queries and reporting. Select appropriate architectures (e.g., Kimball, Inmon), develop ETL (Extract, Transform, Load) processes, and apply data modeling techniques.

Big Data Platform Management:

Manage and administer big data platforms like Hadoop, Spark, and Hive, ensuring they are scalable, reliable, and secure. Handle cluster management, resource allocation, and performance tuning.

Data Integration:

Integrate data from various sources (structured and unstructured, internal and external) into the data warehouse or data lake, ensuring data quality and consistency.

Performance Optimization:

Optimize the performance of big data systems and data warehouses for complex analytical queries using techniques like indexing, partitioning, and query optimization.

Data Governance and Security:

Implement data governance policies and security measures to protect sensitive data within the data warehouse and big data environment. This includes access control, data masking, and compliance with regulations like GDPR.

Data Modeling for Analytics:

Design data models optimized for analytical queries to enable business users to easily access and analyze data.

Tool Selection and Evaluation:

Evaluate and recommend suitable big data and data warehousing tools and technologies, staying updated with the latest advancements in the field.

Collaboration:

Work closely with data scientists, analysts, and business stakeholders to understand their data needs and support data-driven initiatives.

Requirements

• A bachelor's degree in computer science, information technology, or a related field
• Minimum 8 years of experience
• Expertise in Big Data
• Expertise in Data Warehousing