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:

1. Initial Screening: Call with Recruiter.
2. Technical Interview.
3. CI (Culture Index) Test.