BI & Data Analytics

Your tasks

• Write advanced, optimized SQL queries to extract, transform, and load (ETL) data from multiple sources (CRMs, financial systems, program databases).
• Develop and maintain Python scripts (using libraries like Pandas, NumPy) for data cleaning, automation, and advanced statistical analysis.
• Ensure data integrity, quality, and security across all MEKI databases, adhering to international data privacy standards (e.g., GDPR).
• Design, build, and deploy interactive, user-friendly dashboards and reports using BI tools (e.g., Power BI, Tableau, or Looker).
• Create the "Six-Case Dashboard" and other real-time reporting tools to track fundraising progress, program outcomes, and donor engagement.
• Translate complex technical findings into clear, actionable insights and visual stories for non-technical stakeholders.
• Collaborate with cross-functional teams to define key performance indicators (KPIs) and data requirements for new initiatives.
• Champion a data-driven culture by training staff on how to interpret and utilize BI dashboards effectively.

Requirements

• Bachelor’s degree in Computer Science, Data Science, Statistics, Information Systems, or a related quantitative field.
• 3 to 5 years of progressive experience in data analytics, business intelligence, or a related field.
• Advanced SQL: Proficiency in writing complex queries, joins, window functions, and stored procedures.
• Python: Strong working knowledge of Python for data manipulation and analysis (Pandas, NumPy, Jupyter Notebooks).
• BI Tools: Proven experience building dashboards in Power BI, Tableau, or similar platforms.