BI & Data Analytics

Job Description 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. Job 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.