DWH Analyst
Apperito is a fast-growing international IT company with the head office in Czech Republic. We have employees from nine countries. Mobile apps scaling is our primary business. We use innovative solutions and provide unique conditions for clients exponential growth. Our top priority is to build an effective team with ambitious mindset, where ideas of every employee are valued and counted, so we can grow and develop together.
Due to the fast growth and expansion of the company we are looking for a skilled DWH Analyst to help us design, optimize, and maintain our data warehouse and ensure high-quality data delivery for business insights.
Responsibilities:
Build Data Integrations:
- Set up connections to data sources and oversee data ingestion into the data lake;
- Collaborate with teams to define integration requirements.
Develop and Maintain Data Models:
- Design and optimize schemas for analytics and reporting;
- Create data marts and aggregation layers for business use.
ETL and Data Quality:
- Ensure clean, consistent, and transformed data is delivered to the warehouse;
- Monitor ETL pipelines and troubleshoot data quality issues.
Documentation:
- Maintain up-to-date data dictionaries and process documentation;
- Communicate data solutions clearly to stakeholders.
Requirements:
- Strong SQL skills and experience with DWHs (e.g., ClickHouse, Redshift);
- Knowledge of ETL tools and data modeling principles;
- Familiarity with BI tools (e.g., Superset, Metabase);
- Experience with integrating data from multiple sources (APIs, files, databases).
Benefits:
- Work in informal environment with a team of professionals;
- Professional growth and development;
- Participation in professional events (conferences, seminars, trainings) at the expense of the company;
- Outdoor team-building events;
- Comfortable and flexible working environment (remote or at the office);
- Modern and cozy office in the center of Prague with a terrace and excellent coffee and snacks;
- Guaranteed conditions for efficient work.