Sr. Business Intelligence Analyst

Sr. Business Intelligence Analyst 

Work Location: Lahore Pakistan or Faisalabad Pakistan

Work Type: On-Site

What are we looking for?

At elGrocer, we’re proud to stand at the forefront of the Big Data revolution. Using the latest analytic tools and processes, we’re able to maximize our offerings and deliver unparalleled service and support. To help carry us even further, we’re searching for an experienced data analyst to join our team. The ideal candidate should be highly skilled in all aspects of data analytics, including mining, generation, and visualization, with a deep understanding of marketing data analysis. Additionally, you should be committed to transforming data into readable, goal-driven reports for continued innovation and growth in the marketing domain.

Objectives of this Role:

• Develop, implement, and maintain leading-edge analytic systems, taking complicated marketing problems and building simple frameworks
• Identify trends and opportunities for growth through analysis of complex marketing data sets
• Evaluate organizational methods and provide source-to-target mappings and information-model specification documents for marketing data sets
• Create best-practice reports based on marketing data mining, analysis, and visualization
• Evaluate internal systems for efficiency, problems, and inaccuracies, developing and maintaining protocols for handling, processing, and cleaning marketing data
• Work directly with marketing management and users to gather requirements, provide status updates, and build relationships
• Should be able to work independently with business team to collect marketing requirements and implement them

Daily and Monthly Responsibilities:

• Developing visual reports, KPI scorecards, and dashboards using Power BI desktop.
• Connecting marketing data sources, importing data, and transforming data for Business intelligence.
• Analytical thinking for translating marketing data into informative reports and visuals.
• Should have an edge over making DAX queries in Power BI desktop.
• Expert in using advanced-level calculations on the marketing data set.
• Responsible for design methodology and project documentation.
• Should be able to develop tabular and multidimensional models that are compatible with data warehouse standards.
• Very good communication skills must be able to discuss the marketing requirements effectively with the marketing teams, and with internal teams.
• Create and maintain rich interactive visualizations through marketing data interpretation and analysis integrating various reporting components from multiple data sources

Skills and Qualifications:

• Bachelor’s degree in Marketing, Statistics, Mathematics, or Computer Science
• 5+ years experience mining marketing data as a data analyst using PowerBi.
• Strong SQL (ETL. ELT) skills with the ability to learn other analytic tools.
• Preferred Qualifications:
• Prior experience with database and model design and segmentation techniques in marketing.
• Proven success in a collaborative, team-oriented environment.