Summary
Rihal is hiring a Data Architect for a role in Oman. The position involves designing enterprise data architecture and logical, physical, and dimensional data models, as well as developing SQL scripts and supporting data warehouses, lakes, and lakehouses. The role works with data engineers, analysts, and business stakeholders to define requirements, address integration challenges, and ensure data solutions are scalable and secure. Applicants should have a relevant bachelor's degree, at least five years of hands-on data experience, and strong communication and presentation skills.
The posting
As published on rihal.om. Pulled from the employer's site and shown as they wrote it.
Job Purpose
To be responsible for designing, creating, deploying, and managing data architecture and models. deep understanding of data systems, structures, and principles, along with hands-on experience in data modeling. Work with relational, dimensional, and NoSQL databases to design the databases using a mixture of conceptual, physical, and logical data models.
Duties & Responsibilities:
- Design and establish enterprise-level data architecture, ensuring it aligns with the company's business requirements.
- Analyze and translate business needs into long-term solution data models.
- Analyze data for source/target mappings. create SQL scripts for data processing.
- Perform data analysis and data modeling for operational applications and analytical databases.
- Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
- Create and maintain a conformed data warehouse/ data lake/ lakehouse environment (including data marts, data cubes, subject areas, etc.) for performing data analytics.
- Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
- Collaborate with the data analytics development to implement the data model.
- Develop entity relationships models for normalized and dimensional models.
- Work closely with data engineers, analysts, and stakeholders to determine data requirements for the organization and translate business needs into data solutions.
- Perform reverse engineering of physical data models from databases and SQL scripts.
- Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
- Analyze data-related system integration challenges and propose appropriate solutions.
- Design, develop and deploy database models for application development to support business applications, ensuring system scalability, security. performance and reliability.
- Mentor junior data engineers, providing them with training, guidance, and expertise to foster professional growth and uphold team standards.
Qualifications & Experience:
- Bachelor's degree in information technology. software engineering, computer science, or related field.
- 5+ years of hands-on relational. dimensional, and/or analytic experience dimensional, NoSQL data platform technologies, and ETL and data ingestion.
- Experience with data warehouse, data lake, and enterprise big data platforms, across multiple industries and subject areas
- Capable of facilitating data discovery sessions involving business subject matter experts
- Excellent presentation, communication, and organizational skills
- Ability to work both independently and as part of a team.