BI & Data Analytics

• 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.