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.

Responsibilities

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.

Requirements

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+).

Benefits

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.