Principal, BI Engineer

At Cotality, we are driven by a single mission-to make the property industry faster, smarter, and more people-centric. Cotality is the trusted source for property intelligence, with unmatched precision, depth, breadth, and insights across the entire ecosystem. Our talented team of 5,000 employees globally uses our network, scale, connectivity and technology to drive the largest asset class in the world.

Join us as we work toward our vision of fueling a thriving global property ecosystem and a more resilient society.

Cotality is committed to cultivating a diverse and inclusive work culture that inspires innovation and bold thinking; it's a place where you can collaborate, feel valued, develop skills and directly impact the real estate economy. We know our people are our greatest asset. At Cotality, you can be yourself, lift people up and make an impact. By putting clients first and continuously innovating, we're working together to set the pace for unlocking new possibilities that better serve the property industry.

Job Description:

We are seeking a visionary Principal BI Engineer to architect and lead our Reporting and Business Intelligence (BI) engineering efforts. In this high-impact role, you will move beyond simple report generation to design the underlying software ecosystems, data models, and scalable platforms that power our organization's decision-making.

You will act as the technical authority for our reporting infrastructure, bridging the gap between raw data engineering and front-end business insights. You will drive the technical strategy for self-service analytics, embedded reporting, and high-performance data delivery, ensuring our systems are robust, secure, and infinitely scalable.


Key Responsibilities


Technical Strategy & Architecture

• Own the long-term technical roadmap for the company's Reporting and BI stack, selecting the right mix of "build vs. buy" technologies.
• Act as the Subject Matter Expert (SME) and main liaison for Smart Fees and OM billing, reporting, and data warehousing initiatives.
• Architect scalable, fault-tolerant solutions for data delivery, moving from legacy reporting to modern, automated, and real-time data experiences.
• Design and maintain a unified semantic layer (e.g., via dbt, LookML, or custom APIs) to ensure "single source of truth" consistency across all reporting endpoints.
• Proactively identify bottlenecks in query performance and data pipelines; optimize data models, indexing strategies, and caching layers for sub-second report rendering.

Engineering & Development

• Write high-quality, maintainable code to automate data workflows, effectively treating "Infrastructure as Code" for BI assets.
• Lead the engineering effort to integrate analytical dashboards and reporting features directly into customer-facing software products (White-labeling/Embedded BI).
• Gather requirements directly from clients and manage project tracking/ticket resolution via Jira
  .
• Execute hands-on technical fixes and coordinate with DBAs on deployments and RQM/CGM access requests.
• Expertly design dimensional models (Star/Snowflake schemas) and wide-table architectures that support diverse analytical use cases.

Leadership & Collaboration

• Serve as a technical mentor to Senior and Staff engineers, fostering a culture of technical excellence and code quality.
• Provide technical leadership for onsite staff and a 3-member offshore team, including task assignment and daily stand-ups.
• Partner with Product Managers, Data Scientists, and C-level executives to translate complex business requirements into technical specifications.
• Establish and enforce standards for data governance, security (RBAC/RLS), and privacy (GDPR/CCPA/PII) within the reporting ecosystem.
• Bridge the gap between business stakeholders (Finance/Product) and Engineering to ensure data accuracy in Rev. Share and BI reports.

Job Qualifications:

Required Technical Skills

• Experience: 10+ years in Software Engineering or Data Engineering, with at least 5 years dedicated to BI/Analytics platforms.
• Core
  
  Languages:
  
  Expert-level proficiency in SQL (complex window functions, CTEs, optimization) and strong programming skills in Python, Java, C# or Scala
  .
• Modern…