Data & Analytics, Consultant

Master Works; Makkah Region; On-site; SAR 120,000 - 180,000; Full time

Job summary

Master Works seeks a Data & Analytics Consultant to lead BI and data engineering, overseeing the data warehouse, ETL/ELT pipelines and reporting ecosystem. You will partner with Operations, HR, Finance, IT and Strategy to capture business requirements and define KPIs.

The role requires strong SQL, Power BI, data modeling, and hands-on Informatica PowerCenter/IICS experience, plus cloud data platform capabilities. Translate business needs into analytics solutions and deliver executive insights.

Qualifications

• Bachelor's degree in a related field.
• 5+ years in Data Analytics, BI, or Data Consulting.
• Strong SQL and relational database experience.

Responsibilities

• Gather, analyze, and document business and data requirements.
• Design and develop Power BI dashboards and reports.
• Develop and optimize SQL queries for data extraction and analysis.
• Support data modeling, data integration, and data quality.
• Define KPIs and provide analytical insights for decisions.
• Collaborate with data engineers, BI developers, and stakeholders.
• Mentor team members and promote best practices.

Skills

SQL

Power BI

Data modeling

ETL/ELT

Data warehousing

Data analysis

Python

AI/ML analytics

Education

Bachelor's degree in Computer Science or related field

Tools

Informatica PowerCenter

Informatica IICS

SQL Server

Azure Data Services

Job description

Master Works is seeking a Data & Analytics Consultant to lead the business intelligence and data engineering functions, overseeing the enterprise data warehouse, ETL/ELT pipelines, and BI reporting ecosystem. In addition to technical leadership, this role acts as a strategic business partner across Operations, HR, Finance, IT, and Strategy to capture business requirements, define key performance indicators (KPIs), and deliver actionable decision-support tools.

Key Responsibilities

• Gather, analyze, and document business and data requirements
• Translate business requirements into data and analytics solutions
• Design and develop Power BI dashboards, reports, and data visualizations
• Perform data analysis to identify trends, patterns, opportunities, and business risks
• Develop and optimize SQL queries for data extraction, transformation, and analysis
• Support data modeling, data integration, and data quality activities
• Work with stakeholders to define KPIs, metrics, and performance indicators
• Provide analytical insights and recommendations to support business decisions
• Collaborate with Data Engineers, BI Developers, Data Scientists, and business stakeholders
• Conduct data validation and ensure the accuracy and consistency of analytical outputs
• Prepare presentations, analytical reports, and executive-level insights
• Support the implementation of data governance, standards, and best practices
• Identify opportunities to automate reporting and improve analytics processes
• Provide consulting and advisory services related to data and analytics
• Stay updated on emerging technologies, analytics methodologies, and AI-driven analytics

Requirements

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Statistics, Business Analytics, or a related field
• 5+ years of experience in Data Analytics, Business Intelligence, or Data Consulting
• Strong experience with SQL and relational databases
• Hands-on experience with Power BI and data visualization
• Strong understanding of data modeling, ETL, and data warehousing
• Experience translating business requirements into technical/analytical solutions
• Strong analytical, problem-solving, and communication skills
• Ability to work effectively with both technical and non-technical stakeholders
• Extensive hands-on background with Informatica PowerCenter or Informatica Intelligent Cloud Services (IICS)
• Mastery of SQL Server or modern cloud data warehouses, relational database design, and query optimization
• Expert-level competency in Microsoft Power BI (Power BI Service, Gateway management, Premium capacity, DAX)
• Demonstrated cross-functional domain knowledge across business operations, corporate finance, workforce analytics, and strategic execution
• Experience with Microsoft Azure, Azure Data Services, or cloud analytics platforms is preferred
• Knowledge of Python for data analysis is preferred
• Experience with DAX and Power Query is preferred
• Understanding of Data Governance, Data Quality, and Master Data Management is preferred
• Experience in AI/ML analytics or integrating AI capabilities into business solutions is preferred
• Certifications such as Microsoft Power BI Data Analyst, Azure Data Engineer, or related certifications are preferred

Job Location: Client Site