Data Analyst

شرح موقعیت

Job Title: Data Analyst Consultant, NWU and BU Products Role Description: Data Analyst Consultant, NWU and BU Products Department: Product and BD Marketing Engagement type: Full-time consultant, onsite Location: Jeddah 1. Purpose of the Role The consultant will support the data extraction and analytics needs of two voluntary top-up products: Network Upgrade (NWU) and Benefit Upgrade (BU). The role provides daily visibility of the member funnel (eligible, contacted, purchased, expired) and automates recurring data processes. It also measures the true impact of communication campaigns and identifies the best segments and channels so communications reach members effectively. 2. Key Responsibilities Data extraction and automation Extract member, policy, and purchase data from Cognos daily and on demand. Link and reconcile data across multiple Excel sources into a single, consistent dataset. Build automated data pipelines (Power Query, Power BI dataflows, scheduled Cognos reports) to replace manual extraction and linking. Maintain data quality through validation checks, de-duplication, and reconciliation against source systems. Daily member tracking Maintain a daily master tracker covering purchased, eligible, and expired members for NWU and BU. Track members in the communication campaign, including campaign stage and communication type (SMS, IVR, push notification). Update purchased-member records daily and reflect them across all related trackers. Campaign analytics and impact measurement Measure conversion by member profile (e.g. demographics, plan, corporate segment, region) and by communication method. Design holdout (control) groups and A/B tests to measure the incremental impact of communications on purchases. Apply a consistent attribution window (e.g. purchase within [14] days of contact) across all analysis. Collect communication results (delivery, response, and outcome) and update trackers and the database. Identify and recommend the best segments to target, with data-backed rationale. Communication coordination Prepare target member lists for daily communications based on segmentation and test design. Coordinate with the technical team so daily SMS, IVR, and push notification campaigns go out on time and accurately. Follow up on execution issues and feed channel performance insights back into targeting. Reporting and dashboards Build and maintain Power BI dashboards tracking funnel, campaign, conversion, and incremental impact KPIs. Produce daily, weekly, and monthly progress reports for management. Support ad hoc analysis requests from the Product and BD Marketing team. Data management and documentation Organize all working files in a clear, consistent structure and archive the full history of trackers and extracts. Build and maintain a reference folder with all necessary data, definitions, and lookup tables. Document extraction queries, pipeline logic, and procedures so the work can be handed over or continued. 3. 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 Campaign impact measurement framework (holdout groups, A/B tests, attribution rules) Power BI dashboard covering funnel, campaign performance, conversion, and incremental impact Segment and channel conversion analysis with recommendations Daily, weekly, and monthly progress reports Organized reference folder and historical data archive Process documentation and a handover pack at the end of the engagement 4. Required Qualifications and Skills Bachelor's degree in Statistics, Computer Science, Information Systems, Business Analytics, or a related field [X]+ years of experience in data analysis, ideally in insurance, healthcare, banking, or telecom Hands-on experience extracting and reporting data from IBM Cognos Advanced Excel, including Power Query, lookups (XLOOKUP/INDEX-MATCH), and pivot tables Proven experience building Power BI dashboards (data modeling, DAX, scheduled refresh) Experience building automated data pipelines and reducing manual reporting work Working knowledge of A/B testing and control group design Experience analyzing marketing campaign performance and conversion funnels Strong attention to detail and discipline in data accuracy and file management Clear communication with both business and technical teams, in English (Arabic preferred) Preferred: SQL knowledge, experience with CRM or campaign management data, and familiarity with health insurance member and policy data.