Data Analyst & DWH

Responsibilities

• Design, develop, and maintain data warehouse (DWH) structures to support efficient data storage, retrieval, and analysis.
• Analyze complex datasets from multiple sources to provide actionable insights and support business decision-making processes.
• Build and optimize ETL (Extract, Transform, Load) processes to ensure timely and accurate data integration into the DWH.
• Collaborate with business stakeholders to understand data requirements and translate them into technical specifications for reporting and analysis.
• Create and maintain dashboards, reports, and visualizations to track key performance indicators (KPIs) and support organizational goals.
• Ensure the accuracy, integrity, and security of data in the DWH, performing regular audits and validations to maintain quality.
• Optimize query performance and database operations to ensure efficient data retrieval and processing.
• Identify trends, anomalies, and patterns in data to support forecasting, business planning, and operational improvements.
• Document DWH processes, data flows, and analysis methodologies to ensure knowledge continuity and compliance.
• Stay updated on the latest DWH technologies, data analysis tools, and best practices to improve system performance and usability.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field.
• At least 3 years of experience in data analysis and data warehouse development.
• Strong proficiency in SQL and expertise in data modeling and database design.
• Experience with ETL tools and processes, familiarity with data visualization tools like Tableau, Power BI, or Looker.
• Programming skills in Python, R, or a similar language for data analysis are a plus.
• Strong problem-solving and analytical skills with the ability to interpret and present complex data in a clear and concise manner.