Save Job Back to Search Job Description Summary Similar Jobs Added 26/05/2026100% remoteWork with massive-scale social media and campaign dataAbout Our ClientThe employer is a large organisation operating within the professional services industry, known for delivering innovative solutions to its clients. It is committed to fostering a culture of excellence and providing its employees with opportunities to grow and thrive in their careers.Job DescriptionDesign and build scalable ETL pipelines to move data from transactional systems into analytical data warehousesDevelop real-time and batch data ingestion systems for social media, campaign, and user metricsCreate multi-tenant data models with strong data isolation and partitioning strategiesBuild and optimize analytical databases for high performance and low-latency queries (sub-second dashboards)Implement data quality checks, validation frameworks, monitoring, and alertingDesign and maintain secure data access using Row-Level Security (RLS) and Role-Based Access Control (RBAC)Build authentication and session-based access control for multi-tenant environmentsDevelop optimized SQL transformations for BI dashboards and embedded analyticsCreate aggregated tables, materialized views, and denormalized datasets for reportingWork with ETL orchestration tools like Apache Airflow, Prefect, or dbtOptimize OLAP systems using partitioning, indexing, compression, and query tuningSupport high-concurrency analytics workloads with large-scale datasetsCollaborate on BI and analytics integrations for internal teams and enterprise clientsEnsure compliance with security standards like SOC2 and GDPRTechnologies used:SQL (expert level)Python (pandas, numpy, pyarrow)ETL tools: Apache Airflow, Prefect, dbtAnalytical databases: ClickHouse, BigQuery, Snowflake, RedshiftStreaming systems: Apache Kafka, Pulsar, KinesisOLAP / data warehouse optimization techniquesBI / embedded analytics platformsData modeling, semantic layers, and metrics systemsThe Successful Applicant5+ years of experience in Data Engineering in production-scale environmentsVery strong SQL skills and experience with analytical / columnar databasesStrong Python skills, especially for data processing (pandas, numpy, pyarrow)Experience building ETL pipelines and data orchestration workflows (Airflow, Prefect, dbt)Solid understanding of OLAP systems, data warehousing, and performance optimizationExperience with multi-tenant SaaS data platforms and data isolation conceptsKnowledge of Row-Level Security (RLS), RBAC, and secure data access patternsExperience with distributed or streaming systems (Kafka, Pulsar, or Kinesis) is a plusFamiliarity with BI tools, embedded analytics, and dashboarding systemsUnderstanding of data compliance requirements (SOC2, GDPR)Experience with scalable, real-time data processing systems is a strong advantageWhat's on OfferPeople: work with talented, collaborative, and friendly people who love what they do.Guidance: utilize our learning platform to fully get the training and tools you'll need to become successful here from your first day with us.Surprise meal stipends: work from home can't stop the enjoyment of someone else making a meal for you!Work/life harmony: 26 days vacation, floating and set holidays, wellness allowance, and paid parental leave.Medical insurance, life insurance, and business travel insuranceStock options as part of our equity-sharing program.Comprehensive perks program providing stipends for cell phone and internet, home office setup, mental wellness, professional development and tuition reimbursement, plus occasional company-funded meal opportunities throughout the year.ContactDawid ZienkiewiczQuote job refJN-052026-7025266Job summarySectorInformation TechnologySub SectorIT Data AnalysisIndustryTechnology & TelecomsLocationWarsawTyp umowyPermanentConsultant nameDawid ZienkiewiczJob ReferenceJN-052026-7025266Job NatureHome Office
