Senior Data Analyst / BI Developer

About Us:
At Koocafe, we're dedicated to curating the ultimate café experience for everyone. Our mission is to connect coffee enthusiasts with the best cafes while also empowering these cafes with the technical infrastructure to effortlessly provide top-quality online services to their customers. Koocafe currently serves users and cafes in multiple countries worldwide and is actively expanding its business in Iran. If you're passionate about joining us on this journey and becoming part of our team, we eagerly await your CV.

Job Description:
We are seeking a talented and insightful Senior Data Analyst / BI Developer to join our dynamic team. In this role, you will leverage advanced analytics tools and business intelligence platforms to provide actionable insights and support data-driven decision-making across the organization. You will collaborate with cross-functional teams including product, engineering, and marketing to uncover insights, visualize complex data, and optimize the technical infrastructure that empowers our partner cafes.

Responsibilities:

• Design and implement business intelligence (BI) solutions that translate complex data into actionable insights for various business units.
• Develop and maintain interactive dashboards and reports using BI tools like Power BI, Tableau, or similar to provide real-time business visibility.
• Collaborate with data scientists, engineers, and business stakeholders to define data requirements and deliver effective BI solutions.
• Extract, clean, and transform large datasets from various sources to enable accurate and insightful reporting.
• Analyze data using statistical techniques and machine learning models to uncover trends, patterns, and predictive insights.
• Work with cloud platforms such as AWS (e.g., Redshift, S3) and Azure (e.g., Synapse, Azure Data Lake) to manage and optimize data storage.
• Leverage Python libraries (e.g., Pandas, NumPy, scikit-learn) for data manipulation, analysis, and advanced reporting.
• Build and optimize ETL/ELT processes to move data efficiently into data warehouses or BI tools.
• Ensure data integrity by automating data validation processes and improving data quality.
• Create custom reports and automated dashboards with Excel, leveraging advanced Excel functions such as pivot tables, vLOOKUP, and Power Query for business analysis.
• Provide ad-hoc reporting and data analysis as requested by business teams to support decision-making.
• Work with containerization technologies like Docker and orchestration tools like Kubernetes to streamline deployment and scaling of data systems.
• Collaborate across teams to ensure that the BI and analytics processes meet business objectives and compliance standards.

Requirements:

• High level of English, both written and verbal.
• Bachelor's or Master's degree in Computer Science, Statistics, Mathematics, Economics, or a related quantitative field.
• Proven experience as a Data Analyst or Business Intelligence Developer, with strong knowledge of BI tools, data analysis, and visualization.
• Advanced proficiency in SQL (both complex queries and data manipulation) and experience with relational and NoSQL databases (e.g., PostgreSQL, MongoDB).
• Strong experience using Excel for data analysis, reporting, and advanced functions (e.g., pivot tables, vLOOKUP, Power Query, macros).
• Experience with BI tools like Power BI, Tableau, or similar for creating interactive and dynamic reports and dashboards.
• Strong knowledge of cloud technologies, specifically AWS (e.g., Redshift, S3) and Azure (e.g., Synapse, Azure Data Lake).
• Experience with data processing frameworks like Apache Spark or Databricks for large-scale data analysis.
• Proficiency in Python (Pandas, NumPy, scikit-learn) for data analysis and reporting automation.
• Experience with ETL/ELT processes and data pipelines.
• Familiarity with statistical analysis and machine learning techniques to interpret data and generate predictive models.
• Strong problem-solving skills and ability to troubleshoot complex data issues.
• Excellent communication and collaboration skills, with the ability to translate complex data insights into actionable recommendations for non-technical stakeholders.

Preferred Qualifications:

• Experience with custom data visualizations beyond standard BI tools, using Python or D3.js.
• Knowledge of data governance, security, and privacy best practices.
• Familiarity with tools for workflow orchestration (e.g., DBT, Apache Airflow).
• Previous experience working in agile development teams.

Benefits:

• Competitive salary commensurate with experience.
• Remote work opportunity with flexible hours.
• Comprehensive benefits package.
• Professional development and training opportunities.
• Dynamic and inclusive work culture with opportunities for growth and advancement.

Please send your CV in English.