Job
- Level
- Junior
- Location
- Marienheide
- Working Model
- Onsite
- Job Field
- Data
- Employment Type
- Full Time
- Contract Type
- Permanent employment
Job Summary
In this role, you will develop clean datasets from distributed data, optimize SQL queries for analysis, and assist in data modeling to create clear KPI definitions and generate valuable insights.
Job Technologies
Your role in the team
- You work at the intersection of business, data, and technology. The goal is to develop clean datasets, meaningful analyses, and - where appropriate - ML/LLM use cases from distributed data.
- Understanding, structuring, and making data usable.
- You analyze data sources and assist in building clean data models (e.g., events, user/customer, and process data).
- You support the definition of key figures (KPIs) and data logic.
- SQL & Analytics (Core Focus).
- You write and optimize SQL queries for analytics, reporting, and data transformations.
- You assist in building reusable views/queries for teams.
- ClickHouse (bonus, but very welcome).
- You work (or are learning) ClickHouse for fast analytics on large datasets.
- You assist with performance topics: data modeling, aggregations, partitioning (depending on the setup).
- Data Science / ML use cases (depending on experience).
- You explore data (EDA), build initial models/forecasts/clustering or classifications.
- You develop features and evaluate models pragmatically (not "papers", but added value).
- Optional: LLM-based evaluations (e.g., text classification, tagging, summaries).
- Data Quality & Documentation.
- You help to make data quality visible (checks, plausibility, monitoring ideas).
- You document your results in a way that remains transparent and usable.
This text has been machine translated. Show original
Our expectations of you
Education
- Ongoing studies in Data Science, Computer Science, Business Informatics, Statistics, Mathematics, or similar (or comparable skills).
Qualifications
- Good understanding of SQL (joins, aggregations, window functions are not foreign concepts).
- Analytical thinking and enjoyment in deriving clear insights from raw data.
- Python for Data (pandas, numpy, ...).
- Basic understanding of data pipelines/ETL (dbt, Airflow, n8n, etc.).
Experience
- Initial practical experience in the Data Science/Analytics environment (university project, working student, personal project).
- Experience with ClickHouse (or motivation to learn it quickly).
- Experience with BI/Reporting (e.g., Grafana, Metabase, Power BI, Looker, Superset, etc.).
This text has been machine translated. Show original
What we offer
- Long-term collaboration instead of short-term support - we want to build together.
- Real data, real decisions, visible impact.
- A lot of scope for design: You can influence data structures and standards.
- Short communication channels, pragmatic implementation, direct collaboration with stakeholders.
This text has been machine translated. Show original
Topics You Will Work On
Job Locations
About Your Employer
Tepto Gmbh
Tepto GmbH, a family-run company based in Marienheide, North Rhine-Westphalia, has established itself as a specialist in high-quality products in the field of renewable energies. They offer comprehensive solutions such as solar modules, inverters, storage systems, and accessories for photovoltaic systems, including consulting and installation. Their focus is on sustainable energy solutions to support the energy transition.
Description
- Company Type
- Established Company
- Industry
- Power Sector, Economy