Яна

YANA ANDRIYEVSKA
📍
✉️ Lviv, Ukraine
[open contact info](look above in the "contact info" section)
📞
🔗 [open contact info](look above in the "contact info" section)
[open contact info](look above in the "contact info" section)

Early-career data professional with practical experience in SQL, databases, data integration
processes, and pipeline maintenance. Skilled in data processing, job configuration, root cause
analysis, monitoring and reporting. Motivated to grow in a Data Analytics or Junior Data
Engineering role, continuously expanding my technical skills.

Skills
Code: strong SQL (JOINs, CTEs, window functions, aggregations, subqueries, DML, DDL), basic
Python and Pandas
Hard skills: ETL/ELT, DWH (queries, jobs, data flows, performance optimization), schema and
normalization concepts, data structuring and reporting, data quality, root cause analysis, job
scheduling and monitoring
Tools: SSMS, DuckDB, Power Query, Power BI, Tableau, VS Code, SSIS, Jupyter Notebook,
Microsoft Office Suite, Google Workspace, CRM, ERP systems
Additional skills: product and project management fundamentals, business literacy,
correspondence and presentations, prioritization and efficiency, problem-solving, attention to detail,
fast learning, AI prompting. Languages: English, Hebrew

Professional Experience
Data Ops Analyst | Gomla Economic Simulations Ltd., Israel | Mar 2025 – May 2026
● Migrated data from client virtual machines to local servers, integrated Excel tables, corrected
extraction queries for server data and tested data integrity
● Extended ETL/ELT pipelines and built tables on an Oracle-based proprietary platform
● Configured and monitored scheduled jobs, responded to alerts and resolved errors
● Investigated data discrepancies on client request and performed root cause analysis across
data structures and processing logic
● Improved existing SQL queries and objects; applied normalization/denormalization to support
analytics
● Built ad hoc and recurring reports on ERP data for healthcare and fintech clients, including
drill-through and complex calculations
● Maintained cost allocation systems (e.g., department-level to client-level), troubleshooting and
fixing calculation logic to ensure consistency in final reports
● Collaborated with stakeholders to clarify issues and validate expectations in a B2B setting

Integration Consultant | Ministry of Aliyah and Integration, Israel | Apr 2023 – Sep 2024
● Planned, organized and coordinated meetings and presentations
● Gathered requirements, prioritized tasks and handled business correspondence
● Managed and optimized workflows using CRM and MS Office tools

Forensic Reporting Assistant | Freelance, Ukraine | Oct 2017 – Jan 2020
● Structured and processed data collected during examinations
● Analyzed outcomes, identified patterns and interpreted findings
● Summarized key insights in clear analytical reports

Education
Business Intelligence Developer Certificate | Technion, Israel | 2024 – 2025
MBA, Entrepreneurship and Future Technology | Ariel University, Israel | 2022 – 2024
Bachelor's Degree in Psychology | Odessa National Medical University, Ukraine | 2014 – 2019
Professional Certificate in Finance | Mykolaiv Sukhomlynsky College, Ukraine | 2011 – 2014