Skip to content
BB

Bauyrzhan Balken

@bauyrzhan-balken

Junior Data Analyst | SQL, Python, ETL, and Power BI

I like turning messy data into something people can use. For my RFM project, I worked through more than a million transactions and built a Power BI dashboard. I also enjoy finding ways to automate routine work.

Career

Experience: 0 years

Experience

Data Analyst Intern

Kazakhtelecom JSC

Kazakhtelecom is Kazakhstan's national telecommunications operator, providing fixed-line, mobile, internet, and digital services to consumers and businesses.

Jan 2026 — May 2026

Built three data marts and ETL workflows, and automated weekly reporting, cutting preparation time by about 60% for a team of 5 to 10.

• Designed and implemented 3 data marts for 2 related departments, providing centralized access to key service metrics instead of scattered manual extracts. • Automated weekly reporting on key service metrics, reducing preparation time by about 60%, from several hours of manual work to automatic generation. • Built ETL processes to collect, clean, and transform raw data into dashboards used by a team of about 5 to 10 people for operational reporting. • Contributed to analytical projects to improve business processes, helping make key metrics more transparent to management.

Education

Bachelor's degree, IT Management

Kazakh-British Technical University (KBTU)

2027

Advanced SQL and Data Analysis

Karpov.Courses

Selected projects

RFM Customer Segmentation

Built an ETL pipeline to clean 1,067,371 transactions, used SQL to calculate RFM metrics for 5,878 customers, identified a high-value Champions segment and 345 customers at high risk of churn, and created an interactive Power BI dashboard.

Open project

Analytical SQL Project

Imported datasets and wrote analytical queries for aggregation, ranking, and grouping to support detailed segmentation.

Procurement Tracking System

Developed an RPA process application for internal office use, including status dropdown logic and links to data variables.

AI Agent Design

Developed a business case, BPMN diagram, product roadmap, and customer journey map for a concept using intelligent agents in business workflows.

Data Processing Script

Wrote a lightweight CSV parser to improve the speed of initial data processing and basic calculations.

Skills

SQLPostgreSQLPythonPandasNumPyC++SAP Buildn8nMakeAirtablePower BIDAXInteractive dashboardsMS ExcelPivot tablesAdvanced formulasVBASAPETL pipelinesData marts