Oman Re is committed to attracting, developing and retaining highly motivated, competent and performance-oriented people. We look forward to meeting talented professionals who would like to join our growing team. If you are interested in joining us, please email your CV to email@example.com
Employment Opportunity (Omani nationals preferred)
Position: SQL & BI Administrator
The SQL & Business Intelligence Administrator is responsible for designing, developing, and maintaining business intelligence solutions that enable data-driven decision-making within Oman Re. This role involves collaborating with the IT team as well as relevant internal and external stakeholders to gather requirements, design data models, and create interactive reports and dashboards.
Duties and Responsibilities
- Data Modeling: Design and develop data models, data warehouses, and ETL (Extract, Transform, Load) processes to collect, store, and transform data for reporting and analytics.
- Report and Dashboard Development: Create interactive reports and dashboards using BI tools such as Tableau, Power BI, or QlikView to present data in a user-friendly and visually appealing manner.
- Data Integration: Integrate data from various sources, including databases, APIs, and external data feeds, to ensure data accuracy and completeness.
- Data Analysis: Analyze data to identify trends, patterns, and insights that can inform business decisions and strategies.
- SQL and Query Optimization: Write and optimize SQL queries for data extraction, transformation, and loading.
- Collaboration: Work closely with business stakeholders to gather and understand their reporting and analytics needs.
- Documentation: Document data models, ETL processes, and report specifications for future reference and team collaboration.
- Performance Tuning: Monitor and optimize the performance of BI solutions to ensure responsiveness and efficiency.
- Security and Compliance: Ensure that data is secure and compliant with relevant data protection regulations and organizational policies.
- Training and Support: Provide training and support to end-users to help them effectively utilize BI tools and reports.
Education and Experience
- Bachelor’s degree in computer science, information technology or related field. A master's degree or relevant certifications in business intelligence or data analytics is a plus.
- A minimum of 3-5 years of experience as a Microsoft BI Developer or in a related role.
Skills and Capabilities
- Familiarity with Master Data Services, MS Power BI, and MS Power Automate.
- Proficient in SQL (including SSIS, SSAS, SSRS).
- Ability to create intricate, nested queries and develop stored procedures.
- Background in data warehouse design, such as dimensional modelling, and expertise in data mining.
- A deep understanding of database management systems, online analytical processing (OLAP), and ETL (Extract, Transform, Load) frameworks.
- Possesses strong analytical skills and a problem-solving mindset.
- Solid grasp of Oracle Database.
- Proficiency in O365 and M365 Apps.
- Exceptional written and verbal communication skills.
- Detail-oriented with a strong analytical mindset.
Please send in your CVs latest by 15th November 2023 via email with relevant position as the subject to: firstname.lastname@example.org