BI/Data Engineer

ORIL is seeking a skilled and proactive Senior BI/Data Engineer to design, scale, and maintain our mission-critical, AI-driven data platform. At the core of our engineering culture is a steadfast commitment to performance, reliability, clean data architecture, and uncompromising data integrity. The ideal candidate is an autonomous problem-solver who thrives in an agile environment, takes end-to-end ownership of data pipelines, and ensures robust, scalable deployments.

About the Project
Our client is a US-based innovator providing a centralized data platform for multi-family real estate. The product leverages BI analytics and AI to help operators optimize marketing spend and operational efficiency. The platform aggregates complex real estate datasets to feed real-time BI dashboards and power an intelligent Text-to-SQL analytics chatbot.

What are we looking for?
4+ years of experience building and maintaining production-grade data pipelines, backend data architectures, and BI systems;
Strong expertise in Python and advanced SQL (complex queries, query optimization, indexing, and performance tuning);
Proven experience with Data Modeling (Star/Snowflake schemas, relational databases, data warehousing concepts);
Hands-on experience building and maintaining ETL/ELT pipelines;
Strong experience with data cleaning, normalization, and aggregation to ensure accurate, consistent, and reliable data for both BI dashboards and AI applications;
Experience working with relational databases and modern Data Warehouses;
Experience with BI tools (e.g., PowerBI, Tableau, Metabase, or custom visualization solutions);
Curiosity about multi-family real estate domain metrics (marketing spend, occupancy rates, operational efficiency, ROI) to better design analytical models;
English level: Upper-Intermediate (B2+).

What will you do?
Design, build, and optimize scalable ETL/ELT data pipelines to process real estate data from multiple sources;
Architect and maintain clean, structured databases and data models optimized for fast querying, BI reporting, and AI/LLM integration (Text-to-SQL);
Ensure data quality, consistency, and freshness across the entire platform through automated testing and monitoring;
Collaborate with the AI/ML Engineer to prepare, expose, and optimize data schemas required for the intelligent chatbot and automated AI insights;
Build and support analytical dashboards/reports that help business users derive actionable insights;
Diagnose and resolve data bottlenecks, slow queries, and pipeline failures;
Work closely with Product Managers and the engineering team to refine the data roadmap and ensure smooth data integration.

We Offer:
Flexible engagement (Part-time or Full-time for 3+ months);
Competitive compensation;
Accounting support services;
Flexibility to work from anywhere (fully remotely or in our office in Lviv);
Comprehensive day-off policy, including public holidays and special events;
Education & certification budget + corporate education events;
Wellness budget;
An agile environment and culture that promotes personal and team development.

Application Process:
Initial Screening: Call with Recruiter.
Technical Interview.
CI (Culture Index) Test.