- Role: REPORTING ANALYST POWER BI & VERTICA
- Contract: Long term
- Location: Dubai, Onsite
- Experience: 5+Yeras as a Data Analyst/BI Developer, or similar role, preferably in a large-scale organization or within the logistics industry.
Work Experience: Proven experience (5+Yeras) as a Data Analyst/BI Developer, or similar role, preferably in a large-scale organization or within the logistics industry.
Must Have:
- Strong SQL
- Power BI
- Python
- Vertica beginner
- Logistics domain like freight forward etc
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).
- Intermediate proficiency in Python for data analysis, automation, and advanced analytics is required.
- Experience working with Pandas, NumPy, API integrations, and database connectivity.
- Ability to build automation scripts for recurring reporting tasks.
Python (Intermediate Level Data Analytics & Automation):
- Strong working knowledge of Python for data analysis and automation.
- Hands-on experience with Pandas, NumPy, and Matplotlib/Seaborn for data manipulation and visualization.
- Ability to write reusable scripts for data extraction, cleansing, transformation, and validation.
- Experience connecting Python to databases (Vertica, SQL Server, REST APIs).
- Knowledge of using Python within Power BI (Python visuals / data transformation).
- Basic understanding of automation scripting and process optimization.
- Exposure to Jupyter Notebook or similar development environments.
- Ability to implement basic statistical models and forecasting using Python libraries.
