Data Analyst

About the Role

Staff Connect Saudi is seeking a Data Analyst Consultant to join their team in Jeddah, Makkah. This full-time role focuses on supporting data extraction and analytics for two voluntary top-up products: Network Upgrade (NWU) and Benefit Upgrade (BU). The consultant will be responsible for providing daily visibility into member funnels and automating data processes, with an emphasis on measuring communication campaign impact and identifying effective segments and channels.

Key Responsibilities

• Extract member, policy, and purchase data from Cognos daily and on demand, linking and reconciling data across multiple Excel sources into a consistent dataset.
• Build automated data pipelines using Power Query, Power BI dataflows, and scheduled Cognos reports to streamline data extraction and linking.
• Maintain data quality through validation checks, de-duplication, and reconciliation against source systems.
• Manage a daily master tracker for NWU and BU members, covering purchased, eligible, and expired statuses, and track members within communication campaigns.
• Measure conversion rates by member profile and communication method, designing holdout groups and A/B tests to assess incremental impact.
• Prepare daily target member lists for communications and coordinate with the technical team to ensure timely and accurate campaign execution.
• Build and maintain Power BI dashboards for tracking funnel, campaign, conversion, and incremental impact KPIs.
• Produce daily, weekly, and monthly progress reports for management and support ad hoc analysis requests.
• Organize working files, maintain a reference folder with data definitions, and document extraction queries and pipeline logic for continuity.

Key Deliverables

• Automated data pipelines for extraction, linking, and tracker updates.
• Daily updated master tracker for NWU and BU members.
• Daily target lists for communication campaigns.
• A comprehensive campaign impact measurement framework, including holdout groups, A/B tests, and attribution rules.
• Power BI dashboards covering funnel, campaign performance, conversion, and incremental impact.
• Segment and channel conversion analysis with data-backed recommendations.
• Daily, weekly, and monthly progress reports.
• An organized reference folder and historical data archive.
• Process documentation and a handover pack at the end of the engagement.

Qualifications and Experience

Candidates should possess 2-5 years of relevant experience in data analysis, extraction, and automation. A strong understanding of data quality, reconciliation, and reporting is essential for this role.

Technical Skills

• Proficiency in data extraction tools such as Cognos.
• Experience with data automation tools including Power Query and Power BI dataflows.
• Strong skills in Power BI for dashboard creation and maintenance.
• Ability to manage and reconcile data across multiple sources, particularly Excel.
• Familiarity with designing and implementing A/B tests and holdout groups for campaign measurement.

Work Environment

This is a full-time position based in Jeddah, Makkah. The role involves close coordination with product, marketing, and technical teams to ensure data-driven insights support business objectives.