Reporting Analyst-Power BI & Vertica

JOB SUMMARY

We are looking for a Reporting Analyst with strong SQL expertise to design, develop, and maintain operational and management reports using data from our Warehouse Management System (WMS – LFS). The role will focus on building high-quality Power BI dashboards, writing optimized SQL queries, and supporting data-driven decision-making across logistics and warehouse operations.

As a Data Analyst, you will be responsible for collecting, analyzing, and interpreting large datasets to solve complex problems and provide actionable insights using Data Lake and Power BI. You will use various charts/graphs and visualization techniques to present business KPIs using Power BI. Ability to Present your insights in a clear and concise manner to both technical and non-technical stakeholders is important. Ensuring data accuracy and reliability, resolving inconsistencies, and collaborating with teams to improve data processes are crucial. Exposure to WMS / logistics systems will be a strong advantage.

Duration: 6 months and extendable if the work is satisfactory

Salary: 11,500 AED

KEY RESPONSIBILITY

• Write complex and optimized SQL queries to extract, transform, and analyze data from WMS-LFS and related systems.
• Design, develop, and maintain Power BI dashboards and reports for operations, finance, and management.
• Work closely with business users and IT teams to understand reporting requirements and translate them into technical solutions.
• Build operational KPIs and performance dashboards (inbound, outbound, inventory, billing, productivity, etc.).
• Ensure data accuracy, consistency, and performance optimization across reports.
• Support ad-hoc reporting and analysis requests from business stakeholders.
• Document report logic, data models, and SQL queries for maintainability.
• Collaborate with integration and application teams to validate data sources and resolve data issues.

TECHNICAL COMPETENCIES

• An aspiring Data Analyst candidate requires a wide range of technical competencies to effectively analyze data, build data models, Design Appealing Dashboards and derive valuable insights. Here are some of the key technical competencies that are essential for a Data Analyst:

Data Manipulation and Cleaning:

• Proficient in collecting, cleaning, and preprocessing data from multiple sources, using Power Query for data transformation.
• Skilled in querying data from databases using SQL and integrating it into Power BI.
• Strong hands-on experience in SQL (complex joins, subqueries, CTEs, performance tuning).

Data Modeling in Power BI:

• Expertise in building and optimizing data models within Power BI, focusing on efficient relationships, calculated columns, and measures using DAX (Data Analysis Expressions).
• Knowledge of star schema and snowflake schema modeling to improve performance and usability in Power BI reports.

Advanced DAX for Analytics:

• Mastery of DAX functions for advanced calculations, such as time intelligence, ranking, dynamic filtering, and performance optimization in reports.
• Experience in dynamic measures, KPIs, and predictive modeling within Power BI to support business forecasting.

Statistical and Analytical Thinking:

• Strong foundation in statistical concepts (e.g., hypothesis testing, regression analysis) applied through Power BI.
• Experience with R and Python integration within Power BI for more advanced statistical analysis and machine learning, if needed.

Optimization:

• Ability to optimize existing Dashboards performance to load the data effectively

Ethical Considerations:

• Awareness of ethical considerations in data governance, including data privacy, bias mitigation, and fairness in algorithms.

Collaboration and Communication:

• Effective communication skills to collaborate with cross-functional teams and convey complex technical concepts to non-technical stakeholders.

QUALIFICATIONS, EXPERIENCE AND SKILLS

Desirable Qualification: Bachelor’s degree in computer science, Information Technology, Data Science, or a related field.

Work Experience: Proven experience (5+Years) as a Data Analyst/BI Developer, or similar role, preferably in a large-scale organization or within the logistics industry.

Technical skills required to perform the role:

• 4-7 years of experience in data visualization using Power BI.
• Strong proficiency in DAX, Power Query, and Power Automate.
• Excellent analytical skills with the ability to interpret complex data sets.
• Familiarity with data modeling and visualization best practices.
• Strong communication skills to collaborate with cross-functional teams.
• Experience to design Dashboard to be compatible with Mobile Devices
• Expertise in extracting the data from REST APIs to Power BI Visualization Tool
• Strong knowledge in understanding of Database Concepts and Ability to write SQL Queries
• Able to Develop Data Models to identify potential opportunities and risks using the data sets
• Interpret data, analyze results using statistical techniques and provide ongoing trends or patterns and reports.
• Strong hands-on experience in SQL (complex joins, subqueries, CTEs, performance tuning).
• Experience in Python is an added advantage