Senior Data Engineer, Reporting

This is a fully remote position, open to applicants in Poland.

📋 Description

• Design and develop ETL pipelines for transitioning data from transactional databases to analytical data warehouses.

• Create systems for real-time data ingestion that process campaign data, user metrics, and business intelligence.

• Construct multi-tenant data models featuring effective partitioning strategies tailored for enterprise-scale clients.

• Establish data quality frameworks that include thorough validation, monitoring, and alerting mechanisms.

• Implement Row-Level Security (RLS) and Role-Based Access Control (RBAC) within analytical databases.

• Design flexible permission models that facilitate organization-level and division-level data access.

• Develop session-based context management systems that ensure secure multi-tenant query execution.

• Create detailed audit trails and access logs to meet compliance requirements.

• Design database schemas incorporating advanced partitioning and indexing strategies.

• Generate materialized views and aggregated tables to support real-time analytics.

• Apply query optimization, data skipping, and compression techniques for performance enhancement.

• Manage high-concurrency usage of embedded dashboards, ensuring sub-second query performance.

• Build data sources for dashboards utilizing optimized SQL transformations.

• Address complex data structures and parsing needs effectively.

• Create flat, denormalized tables that are optimized for embedded analytics consumption.

• Develop custom field handling solutions to meet tenant-specific metadata needs.

⛳️ Requirements

• Over 5 years of experience in data engineering with production-scale systems.

• Advanced SQL proficiency with analytical databases, preferably columnar databases.

• Strong programming skills in Python, particularly with data libraries such as pandas, numpy, and pyarrow.

• Experience with ETL orchestration tools like Apache Airflow, Prefect, dbt, or similar.

• In-depth knowledge of analytical databases, partitioning strategies, and OLAP optimization techniques.

• Experience in building SaaS data platforms with requirements for tenant isolation.

• Familiarity with the implementation of Row-Level Security (RLS) in analytical databases.

• Understanding of RBAC patterns and session-based access control mechanisms.

• Experience with authentication processes in data systems.

• Knowledge of compliance standards (SOC2, GDPR) pertinent to multi-tenant data.

🏝️ Benefits

• 26 days of vacation.

• Floating and designated holidays.

• Wellness allowance.

• Paid parental leave.

• Medical insurance.

• Life insurance.

• Business travel insurance.

• Stock options as part of our equity-sharing initiative.

• Comprehensive perks program, offering stipends for cell phone and internet, home office setup, mental wellness, professional development, tuition reimbursement, and occasional company-funded meals throughout the year.