Data Analyst (Market Data & KPI) at HealthCare in Omega-konsalting, OOO

Data Analyst (Market Data & KPI) in HealthCare

Position description

We are building a core for collecting and analyzing market data of the Ukrainian farm market based on our existing products. The key challenge is to distill disparate facts into single, consistent “facts”, monitor discrepancies, coverage and quality, and translate this into clear insights, KPIs and business analytics.

As a Data Analyst, you will be at the intersection of business, data and development: formulating metric/viewpoint requirements, helping the team agree on “what is the truth”, and delivering analytics that endure reality.

Main responsibilities

• Collection and formalization of requirements for market analytics and internal KPIs: definition of metrics, formulas, rules, restrictions and acceptance criteria
• Description of the business logic of matching data between sources: what we consider “sales/delivery/remaining”, how we interpret delays, gaps, duplicates
• Work with consistent views (daily/weekly/monthly slices): validation, coverage control, analysis of discrepancies between flows (checks/ERP as observed sales, inference from balances, control supply flows)
• Preparation and support of dashboards/reports/analytical models in PowerBI, explaining results to stakeholders
• Collaboration with data/engineering teams: setting tasks, prioritization, testing results, participating in releases
• Supporting approaches to data governance: data catalog/description, agreed terms, metric versioning
• Ensuring compliance with privacy requirements: working with aggregate slices and rules of minimum groups (without access to the “point of sale”)

Technological stack

• ClickHouse as the main storage
• dbtCore for transformations
• MDM-directories (pharmacies/networks/legal entities/goods and classifiers) - logic of mapping and "golden" records
• PowerBI for dashboards and reporting
• Understanding data sources and types: receipts (sell-out), deliveries (sell-in), balances/prices, ERP/CRM events, e-recipes
• SQL, Excel, working with task setting systems (Jira)

Requirements

• Experience as a Data Analyst (or related) with a focus on metrics, reporting, analytics for business
• Sure SQL (aggregations, joins, validation queries, quality/completeness check)
• Ability to formalize "fuzzy" queries into clear requirements: defining metrics, rules, edge cases, acceptance criteria
• Experience with dashboards/BI and explaining business data
• Analytical thinking, attention to detail, healthy skepticism of “ideal” data

Would be an advantage

• Experience with DWH/windows, dbt or similar transformation tools
• Understanding MDM/references/identity mapping, working with classifiers
• Experience with market or retail analytics (sell-in/sell-out, balances, pricing, promos, channels)
• Domain experience HealthCare/retail
• Experience with ClickHouse (or very large volumes of data)

We will offerWe

• Competitive salary
• Opportunity to work remotely
• Opportunities for professional development and training
• Participation in interesting and innovative projects
• Possibility of booking
• Official salary, we are residents of Dia-City

About companyOpenPharma

OpenPharma - a platform created by a group of independent companies, jointly formed a holistic offer as a basis for uniting and effective interaction among all participants of the pharmaceutical market.
Our team consists of experts, managers and specialists of IT and Pharma, combining advanced solutions and industry experience.

We are:

• A software company for work with BigData and business analysis.
• Software company developing desktop solutions for pharmacies.
• Software company developing solutions for hospitals.
• Operational integrator company of OpenPharma services.
• Integrator company of IT solutions and IT infrastructure.
• Software company with products for business support (electronic document flow, software PRO, training platform).