Data & Analytics Engineer

About Us

Bitsoft is the market leader for software development of applications that help hotels and restaurants across Romania, Hungary, Bulgaria, and France run smooth and effective businesses. We are the strategic partner for multiple restaurant and hotel chains such as City Grill, KFC, Burger King, Starbucks, Radisson, JW Marriott, and Ramada. We are a growing business, aiming for expansion to other European markets.

Role Overview

We are looking for a Data and Analytics Engineer to join Bitsoft in Bucharest, reporting directly to the Software Development Manager - Digital. You will build reliable pipelines, define business metrics, and deliver hospitality analytics. You will also build agentic workflows that query governed data, coordinate tools, and automate analysis and business tasks.

Our current stack combines Apache Superset for business intelligence, AWS DMS for database replication, AWS Glue for data processing and cataloging, Apache Iceberg for lakehouse tables, and Amazon Athena for SQL analytics.

Working with product, engineering, finance, marketing, and customer-facing teams, you will take data solutions from requirements through deployment and monitoring. Priorities will be agreed with the Software Development Manager - Digital and product stakeholders, with an emphasis on dependable data, measurable business value, and maintainable solutions.

Requirements

Education and Experience

Bachelor's or Master's degree in Computer Science, Data Science, Engineering, Mathematics, or a related field, or equivalent practical experience.

At least 2 years of experience in data engineering, analytics engineering, or a similar role, with evidence of delivering and maintaining production pipelines or analytics solutions.

SQL and Python

Strong SQL skills for Amazon Athena and relational source databases such as PostgreSQL or MySQL, including query optimization and understanding source data structures.

Proficiency in Python and working knowledge of PySpark for AWS Glue transformations, API integration, and automated testing; ability to write readable, maintainable code.

Data Ingestion and AWS Glue

Experience with AWS Database Migration Service (AWS DMS) for full loads and change data capture (CDC), including table mappings, replication lag, validation, and recovery.

Experience building and scheduling AWS Glue ETL jobs using Python or PySpark, with reusable transformations, retries, backfills, and AWS Glue Data Catalog integration.

Apache Iceberg and Amazon Athena

Experience with Apache Iceberg tables on Amazon S3 and the AWS Glue Data Catalog, including schema and partition evolution, incremental updates, compaction, and snapshot retention.

Ability to write efficient Athena queries, use partition pruning and suitable file layouts, and control data scanned and query costs.

Analytics Engineering and Apache Superset

Experience with dimensional modeling, clear dataset grain, and reusable SQL transformations, including version control, automated tests, and documentation.

Hands-on experience with Apache Superset datasets, SQL Lab, shared metrics, calculated columns, dashboard filters, and chart selection; ability to build usable dashboards backed by Amazon Athena.

Strong analytical judgment, including reconciliation, statistical reasoning, and explaining uncertainty; ability to translate business questions into data requirements.

Data Quality and Engineering Practices

Experience with Git, code review, automated tests, and deployment workflows; ability to monitor data freshness, completeness, DMS replication, and Glue job failures.

Understanding of AWS IAM, least-privilege access, data lineage, and privacy. Ability to combine Superset roles and row-level security with controls on underlying AWS data access to enforce customer isolation.

AI and Agentic Workflow Skills

Experience using AI assistants for SQL, Python, tests, or documentation, while independently reviewing correctness, security, and performance and protecting confidential data.

Ability to build LLM-based workflows using APIs and tool calling, with context management, structured outputs, and validation against governed data; understanding of model limitations.

Collaboration and Ownership

Clear communication with technical and business stakeholders; ability to prioritize work, explain tradeoffs, and collaborate in an agile team.

Interest in restaurant and hotel operations, and the ability to learn their workflows and translate operational problems into useful data solutions.

Nice to Have

AI Applications and Machine Learning

Experience preparing data for retrieval-augmented generation (RAG), including document processing, embeddings, vector or hybrid search, metadata, and retrieval evaluation.

Experience deploying agentic workflows, using agent orchestration frameworks or Model Context Protocol (MCP); familiarity with forecasting, anomaly detection, or recommendation models.

Platform Operations and Integration

Experience with infrastructure as code, AWS Lake Formation, or CloudWatch monitoring and alerting for data workloads.

Familiarity with Docker, operating Apache Superset in production, or embedded analytics and single sign-on integrations.

Hospitality and Commercial Analytics

Knowledge of POS, reservations, payments, inventory, loyalty, or delivery data; familiarity with hospitality metrics such as sales, margins, food cost, guest retention, and occupancy.

Experience with finance reconciliation, product analytics, or marketing measurement, including conversion, campaign attribution, and return on investment.

Responsibilities

Build and Operate AWS Data Pipelines

Use AWS DMS for database full loads and CDC, and AWS Glue to transform ingested data into curated Iceberg tables. Handle inserts, updates, deletes, duplicates, late events, and safe reprocessing.

Monitor DMS replication lag, Glue jobs, data freshness, Athena query performance, and AWS costs. Resolve failures, document recovery procedures, and improve recurring problems.

Maintain Iceberg partitions, compact small files, and manage snapshots and retention to balance query performance, storage cost, and recovery needs.

Create Trusted Models and Metrics

Build documented Iceberg data models and shared KPI definitions with business owners. Publish reusable Athena queries and Superset datasets and metrics, with clear grain, lineage, and ownership.

Implement automated quality checks and reconcile critical figures with source systems. Verify customer isolation across Superset dashboards, SQL access, AWS permissions, and AI interfaces.

Deliver Superset Dashboards and Business Insights

Develop Apache Superset dashboards and Athena analyses for hospitality operations, product usage, finance, and marketing. Configure filters and caching appropriately, and explain findings and limitations.

Enable self-service analytics through clear documentation, discoverable datasets, and support for business users.

Build AI Applications and Agentic Workflows

Design, build, and operate multi-step agentic workflows over governed data queried through Amazon Athena, coordinating LLM reasoning with SQL and approved tools or APIs.

Build workflows that detect anomalies, investigate KPI changes, or automate recurring reporting. Handle state, retries, and failures, and record execution traces for monitoring and debugging.

Evaluate task completion, answer accuracy, latency, and cost. Enforce customer isolation, read-only analytical access, and query limits; require human approval for actions that change business data.

Collaborate and Improve

Contribute to the data roadmap with the Software Development Manager - Digital and product stakeholders. Prioritize work by business value, data readiness, and effort.

Deliver reviewed, tested, and monitored releases. Share knowledge and adopt tools that improve quality, maintainability, or delivery speed.

What We Offer

Exposure: Interaction with global and local customers in the hospitality industry.

Culture: Entrepreneurial organizational culture and flexible work program.

Growth: Access to the team's know-how and expertise, along with self-development opportunities.

Benefits: Meal tickets, medical insurance, and regular training sessions.