SIGN IN
Principal, BI Engineer jobs in United States
cer-icon
Apply on Employer Site
company-logo

Cotality · 22 hours ago

Principal, BI Engineer

Cotality is a leading company in the property intelligence sector, dedicated to enhancing the property industry through innovative technology. They are seeking a Principal BI Engineer to architect and lead their Reporting and Business Intelligence efforts, focusing on designing software ecosystems and scalable platforms for decision-making.
Real EstateSoftwareProperty & Casualty InsuranceProperty Insurance

Responsibilities

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 SmartFees 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
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
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

Qualification

SQLPythonCloud data warehousesSemantic layer designJavaC#ScalaDbtLeadershipCollaboration

Required

10+ years in Software Engineering or Data Engineering, with at least 5 years dedicated to BI/Analytics platforms
Expert-level proficiency in SQL (complex window functions, CTEs, optimization) and strong programming skills in Python, Java, C# or Scala
Deep hands-on experience with cloud data warehouses (Snowflake, BigQuery, or Redshift) and transformation tools (dbt)
Proven track record of designing semantic layers and high-concurrency reporting architectures

Benefits

Generous PTO and 11 paid holidays, plus well-being and volunteer time off.
Up to 16 weeks of fully paid parental leave and a baby stipend.
Multiple medical plan options with mental health and wellness support offerings.
401(k) with company match and vesting after one year.
$400 annual well-being stipend and tuition assistance up to $5,250.
Recognition Rewards, Referral bonuses, exclusive discounts and more!

Company

Cotality

twittertwittertwitter
company-logo
Cotality is a technology firm helping property professionals with data, valuations, surveys and retrofit solutions.

Funding

Current Stage
Late Stage
Total Funding
$1.63M
Key Investors
Finance Birmingham
2018-02-12Acquired
2016-07-05Series Unknown· $1.63M
Company data provided by crunchbase