Алматы
Метро: Алмалы~40% of the time
Development and maintenance of dashboards in Power BI and performing deep analytics in Excel (OLAP cubes).
Writing advanced DAX measures.
~35% of the time
Enhancing the analytical data warehouse (DWH).
Designing data models for BI needs, creating new business entities not present in source systems, and performing gradual refactoring of legacy structures.
~25% of the time
Developing complex ETL processes in Python (API integrations, parsing, custom scripts).
Maintaining pipelines in Apache Airflow.
Additional responsibilities
Analyzing, reverse‑engineering, and optimizing existing data structures.
Writing complex SQL queries (PostgreSQL, MariaDB) and analyzing T‑SQL to understand the structure of MS SQL–based systems.
Configuring and supporting automations in Power Automate (e.g., auto‑refreshing Excel reports, Outlook email flows).
Ensuring data consistency, identifying metric discrepancies across CRM databases, and resolving anomalies.
Collaborating with stakeholders to translate business requirements into technical BI solutions.
Nice to Have
Experience implementing data governance practices and access control models.
Understanding metrics relevant to hospitality or POS systems.
3+ years of experience as a BI Engineer, Data Engineer, or similar role.
Strong practical experience with Power BI: advanced DAX, data modeling, and Power BI Service administration.
Confident work with Excel OLAP cubes, including writing formulas and building queries to semantic Power BI models (standard Excel tables alone are not sufficient).
Strong knowledge of Python for writing complex ETL scripts, working with external APIs, and parsing data (not just maintaining existing DAGs).
Understanding the architecture of analytical DWHs, including denormalization principles and differences from classical relational databases.
Confident SQL skills (PostgreSQL, MariaDB) and ability to read T‑SQL.
Readiness to work with legacy: proven ability to analyze someone else’s code, unstructured data, and historical databases with limited documentation.
Understanding of SaaS business metrics, subscription models, and CRM structures (revenue, cohorts, churn logic).
Basic understanding of Power Automate flows and willingness to learn quickly.
Proficiency in Russian and English.
Working in an international company.
Registration under the Labor Code of Armenia from the first day.
Ability to work both remotely and in the office if desired.
Flexible start of the working day until 11:00 GMT+3.
Gym access package.
Free English Courses with colleagues.
Health insurance.
Epam Kazakhstan (Эпам Казахстан),ТОО
Астана
до 1000000 KZT