Senior Data Analyst with Financial Services Expertise

ZEGEYE HAILE

Senior Data Analyst

US Citizen Alexandria, VA 571-***-**** ***********.****@*****.*** LinkedIn

PROFESSIONAL SUMMARY

Senior Data Analyst with 5+ years of experience delivering data-driven insights for financial services, investment platforms, and regulated environments. Strong background in statistical analysis, machine learning–adjacent analytics, and translating complex models into clear, actionable business insights for stakeholders. Experienced across the full analytics lifecycle—from customer onboarding and data preparation to model performance analysis, risk insights, and executive communication. Proven collaborator with Data Scientists, ML Engineers, and Product teams to support analytics-driven decision-making in fast-paced fintech environments.

TECHNICAL SKILLS

●Languages & Tools: SQL, Python (Pandas, NumPy), DAX, R (basic), Power Query, PowerShell

●BI Tools: Power BI, Tableau, SSRS, Looker, Excel (Advanced), Power Query, DAX

●Databases: SQL Server, Azure SQL, Snowflake, BigQuery, MySQL, PostgreSQL

●ETL & Data Integration: SSIS, PowerShell, Python (Pandas, NumPy, Scikit-learn), APIs, Azure Data Factory

●Cloud Platforms: Microsoft Azure, AWS (RDS, Redshift), GCP (BigQuery)

●Programming: SQL (T-SQL), Python, PowerShell, R (Basics)

●Data Modeling: Star Schema, Snowflake Schema, Normalization, Dimensional Modeling

●Other: Data Governance, Data Quality, Compliance Reporting (SOX, NCUA), KPI Development

Fintech & ML Analytics Expertise

●Financial & Investment Analytics

●Risk & Portfolio Performance Analysis

●Customer Lifecycle Analytics (Onboarding Retention Optimization)

●Model Performance Evaluation & Insights

●Statistical Analysis & Hypothesis Testing

●Explainability & Business Translation of ML Outputs

●KPI Design for Lending, Risk, and Operations

●Regulatory & Compliance-Aware Analytics

PROFESSIONAL EXPERIENCE

Senior Data Analyst June 2023 – Present

Edward Jones Contract Remote

●Developed robust SQL queries and Python scripts to perform data cleaning, wrangling, and transformation for analytics and reporting.

●Built and optimized Tableau dashboards to visualize client investment trends, portfolio performance, and operational KPIs.

●Led ETL workflows using AWS Glue and Redshift, integrating structured and semi-structured data sources for downstream analytics.

●Partnered with finance, compliance, and product teams to define business metrics and develop actionable insights.

●Automated recurring reports via AWS Lambda and Python, reducing manual workload and improving data timeliness.

●Designed data models to support self-service analytics and reduce data silos across departments and automated data pipelines with Python, AWS Lambda, CloudWatch, reducing manual work by 60%.

●Validated data integrity through QA routines and reconciliations before deployment to BI platforms.

●Performed exploratory data analysis (EDA) on large scale user datasets to identify behavioral trends that guided product feature enhancements.

●Designed and deployed churn prediction models using Scikit-learn to support personalized outreach, improving client engagement and retention.

●Mentored junior team members on SQL best practices, Tableau design, and AWS data tools.

Data Analyst June 2021 – May 2023

Janus Handerson Contract Remote

●Built and maintained Tableau dashboards for portfolio performance, cost analysis, and risk metrics used in executive planning sessions.

●Automated data transformation tasks using Python scripts, improving report turnaround and team efficiency.

●Cleaned and structured data from SQL databases and APIs using Pandas and Power Query for downstream analysis.

●Helped implement secure BI access layers to maintain compliance while ensuring broader reporting access.

●Partnered with stakeholders to gather feedback and iteratively refine analytics outputs, improving report usability.

●Developed KPI-based reports that aligned with strategic financial objectives and operational metrics and automated reporting with Python (Pandas, NumPy), reducing monthly reporting time by 50%.

Database Developer June 2020 – May 2021

LPL Financial Contract Remote

●Migrated legacy reporting systems to SQL Server using SSIS and BCP, enhancing reliability and audit compliance.

●Built stored procedures and views to support real time and batch based sales reporting, Improved SQL query performance by 70% through indexing and execution plan tuning.

●Delivered SSRS dashboards with drill-down capabilities to aid leadership in operational reviews.

●Tuned slow-performing queries using indexing and execution plan optimization to improve reporting speed.

●Modeled dimensional data structures (star/snowflake) to support scalable business intelligence.

●Collaborated with QA teams to validate data pipelines and ensure reporting integrity across financial datasets.

EDUCATION

M.S. in Data Science (In Progress) May 2025 — May 2026

Eastern University, St. Davids, PA

B.S. in Data Science (Summa Cum Laude) Oct 2023 — Dec 2024

University of Maryland Global Campus, Adelphi, MD

B.A. in Business Management Oct 2008 — June 2012

Bahir Dar University, Ethiopia

CERTIFICATIONS

Microsoft Certified: Power BI Data Analyst Associate (PL-300)

Certified Analytics Professional (CAP)

Google Data Analytics Certificate

Contact this candidate