Sara Zarei-Data Analyst / Analytics Engineer
Check rate
Experience
Data Analyst / Analytics Engineer
IDG Tech Media GmbH
- Designed, built, and maintained scalable ETL/ELT data pipelines using Python, SQL, REST APIs, AWS Lambda, S3, PostgreSQL RDS, EventBridge, CloudWatch, Docker, Apache Airflow, and BigQuery – integrating data from GA4, Google Ads, Meta Ads, CMS, CRM, newsletters, events, and B2C ordering systems into analytics-ready datasets.
- Built a cross-brand lakehouse architecture from AWS to BigQuery – transforming raw JSON/CSV data into structured, partitioned, and reusable reporting layers with staging, intermediate, canonical, and mart models.
- Designed relational and dimensional data models: 3NF staging models, star schemas, fact tables, dimension tables, daily KPI aggregates, and dashboard-optimized marts for marketing, content, subscription, event, CRM, and revenue analysis.
- Implemented production-grade data quality and pipeline reliability features: incremental loads, idempotent upserts, deduplication, schema validation, row matching, null checks, anomaly detection, freshness monitoring, logging, retries, and error alerts.
- Automated cross-brand reporting processes and data products – pipelines for 73 newsletter campaigns, 31 lead list syncs, 52 event partner reports, and a 500K-record company matching pipeline; reduced manual data preparation by approx. 70% and increased analyst productivity by approx. 30%.
Data Scientist
Slow Down Health Inc
- Developed Python/SQL data workflows to clean, transform, and prepare user behavior datasets for analysis, reporting, and dashboarding.
- Built robust Power BI reporting datasets and dashboards to track engagement, product usage, and outcome KPIs for business stakeholders.
- Translated business requirements into structured datasets, KPI logic, and reusable analysis workflows to support data-driven decision-making.
Data Analyst / Analytics Engineer
Ministry of Education
- Designed and implemented a managed PostgreSQL relational database to centralize approx. 52,000 book metadata records from fragmented Excel sources – using 3NF normalization, primary keys, composite keys, foreign keys, and referential integrity checks.
- Developed Python-based ETL ingestion pipelines to load, clean, validate, and transform raw Excel files into structured database tables – flagging approx. 1,250 data quality issues through validation workflows.
- Built a MongoDB NoSQL data solution for semi-structured metadata from approx. 30 school libraries – processing nearly 1 million JSON documents via a Python batch ingestion pipeline.
- Created ERD diagrams, data documentation, validation rules, and data quality workflows to improve governance, maintainability, and repeatability of data engineering processes.
- Developed an end-to-end ETL orchestration script to optimize batch execution, enhance pipeline repeatability, and support downstream reporting and exploratory analysis.
Computer Science Lecturer
Ministry of Education
- Taught programming, database fundamentals, SQL concepts, and problem-solving methods – building a strong foundation in relational data, data structures, and analytical thinking.
IT Specialist
University of Medical Sciences
- Supported IT systems, databases, reporting, troubleshooting, and user-facing technical operations to ensure reliable access to institutional data and digital services.
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Education, Media and Entertainment, Government and Administration, and Healthcare.
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Information Technology, Business Intelligence, and Marketing.
Summary
Data Engineer with over 3 years of experience building scalable ETL/ELT pipelines, data warehouses and analytics-optimized data models with Python, SQL, BigQuery, PostgreSQL, MongoDB, AWS, Airflow and Docker. Experienced in API ingestion, batch processing, lakehouse architecture, staging/canonical/mart layers, dimensional modeling, data quality checks, incremental loads, orchestration and monitoring. Proven track record of automating cross-brand data pipelines and reporting workflows – reducing manual data preparation by 70% and improving data reliability for business stakeholders.
Skills
- Programming & Etl: Python, Sql, Pandas, Sqlalchemy, Boto3, Rest Apis, Json/Csv Ingestion, Etl/Elt Pipelines, Batch Processing, Incremental Loads, Idempotent Upserts
- Databases & Warehousing: Bigquery, Postgresql, Aws Rds, Mongodb, Data Warehousing, Lakehouse Architecture, Partitioned Tables, Sql Optimization
- Cloud & Orchestration: Aws Lambda, S3, Eventbridge, Cloudwatch, Apache Airflow, Docker, Serverless Data Pipelines, Workflow Scheduling, Monitoring
- Data Modeling & Quality: 3nf, Dimensional Modeling, Star Schema, Fact/Dimension Tables, Staging/Canonical/Mart Layers, Schema Validation, Deduplication, Data Quality Checks
- Bi & Tools: Power Bi, Domo, Tableau, Git, Bitbucket, Vs Code, Jupyter Notebook, Agile/Scrum.
Languages
Education
M.Sc. Computer Science · Computer Science
B.Sc. Computer Science · Computer Science
Certifications & licenses
Associate Data Scientist in Python (27-course program)
Cloud Computing for Everyone
Data Warehouse Fundamentals
Databases & SQL for Data Science
From Data to Insights with Google Cloud
Scrum Basics
Tableau 10 Essentials
Understanding Data Engineering
Statistics
Experience
Global Experience
Expertise
Qualifications
Profile
Frequently asked questions
Have questions? Find more information here.
Salary / Daily Rate Distribution
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.
The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Data Analyst / Analytics Engineer
Nearby freelancers
Professionals working in or nearby Munich, Germany
