Data Analyst / Data Engineer
Kainjoo Sa
Morges, Switzerland
2 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English, French Experience level
Intermediate Compensation
CHF 208KJob location
Remote
Morges, Switzerland
Tech stack
API
Airflow
Google BigQuery
Spreadsheets
Cloud Database
Data Dictionary
Information Engineering
Data Transformation
Database Queries
Document-Oriented Databases
Google Analytics
PostgreSQL
Raw Data
Power BI
SQL Databases
Data Processing
Data Ingestion
Google Data Studio
Build Management
Information Technology
Data Analytics
REST
Data Pipelines
Job description
You'll define KPIs, build dashboards, write queries, and set up pipelines that keep data flowing cleanly. You'll work directly with clients to understand what they need, and with our tech team to make it happen.
- Define data dictionaries, KPIs, and metric hierarchies with clients and stakeholders
- Write and optimise SQL queries across relational and cloud data warehouses
- Build data transformation pipelines and automation flows
- Design and build interactive dashboards with drill-downs, filters, and cross-source blending
- Integrate data from REST APIs and third-party platforms
- Normalise and clean raw data - handle deviations, nulls, and schema inconsistencies
- Apply GDPR and data privacy best practices when handling client data
- Set up data quality monitoring and alerting
- Document data models, transformation logic, and dashboard usage for clients
Requirements
Personality
- You're comfortable sitting with messy data and bringing order to it
- You ask "what decision does this need to support?" before you build anything
- You explain data clearly to people who don't live in spreadsheets
- You're rigorous about accuracy - you double-check, you validate, you question anomalies
- You manage expectations well when data is incomplete or ambiguous
Experience
- 3+ years of experience in data analytics or data engineering
- Strong SQL skills across one or more platforms (BigQuery, PostgreSQL, or similar)
- Experience building dashboards in a BI tool (Looker Studio, Power BI, Metabase, or similar)
- Familiarity with REST API data ingestion
- Good understanding of analytics concepts: funnels, cohorts, attribution, KPI design
- Awareness of GDPR and data handling responsibilities
Nice to Have
- Experience with workflow automation tools for data pipelines (n8n, Airflow, or similar)
- Python for data transformation scripts
- Familiarity with marketing and CRM platform APIs
- Knowledge of cloud data warehouses and scheduled query jobs, * Bachelor's or Master's degree in Data Science, Statistics, Computer Science, or a related field
- Google Data Analytics, dbt, or BigQuery certifications are a plus
- Fluent in English; French is a plus