1 день назад
Data Analyst
hhВакансия с HeadHunter. Контакт ведёт на hh.ru
Мэтч & Сопровод
Покажет вашу совместимость и напишет письмо
Описание вакансии
Текст:
TL;DR
Data Analyst (SQL/Greenplum): Analyzing business data sources and designing scalable data marts for a Greenplum-based Data Warehouse with an accent on data profiling, logical modeling, and transformation rules. Focus on writing technical specifications, validating analytical solutions, and reconciling data with source systems.
Location: Tbilisi, Georgia. Work options: onsite, fully remote, or hybrid.
Company
Andersen is an IT services company delivering software and data solutions for technology-driven businesses across multiple industries.
What you will do
- Analyze and profile data sources, including structure, quality, completeness, and refresh frequency.
- Gather requirements from business stakeholders and translate them into technical specifications.
- Design logical data mart structures, including attributes, granularity, and metric calculation rules.
- Create source-to-data-mart mappings and document transformation business logic.
- Prepare Greenplum SQL queries and data mart prototypes for Data Engineers.
- Validate development results and reconcile data with source systems.
Requirements
- At least 3 years of experience as a Data Analyst.
- Strong SQL skills, including complex queries, window functions, and large datasets.
- Experience with Greenplum, distributed architecture, distribution keys, and partitioning.
- Experience with Data Warehouses and data modeling principles, including Data Vault, Star Schema, and Snowflake Schema.
- Ability to read source-system documentation and communicate with data owners.
- Intermediate English or higher and strong technical specification writing skills.
Culture & Benefits
- Choice of fully remote, office-based, or hybrid work.
- Mentoring and onboarding support with opportunities for professional, financial, and career growth.
- Corporate training portal and compensation for certifications such as AWS and PMP.
- Private health insurance and sports compensation, depending on the employment type.
- Corporate events, referral program, and team activities.
Будьте осторожны: если работодатель просит войти в их систему, используя iCloud/Google, прислать код/пароль, запустить код/ПО, не делайте этого - это мошенники. Обязательно жмите "Пожаловаться" или пишите в поддержку. Подробнее в гайде →