Cotality

Principal, BI Developer

Cotality

full-time

Posted on:

Location Type: Office

Location: DallasTexasUnited States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $121,700 - $135,000 per year

Job Level

About the role

  • Own the long-term technical roadmap for the company's Reporting and BI stack, selecting the right mix of "build vs. buy" technologies.
  • 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).
  • 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.
  • 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.

Requirements

  • 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!

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
SQLPythonJavaC#ScaladbtSnowflakeBigQueryRedshiftdimensional modeling
Soft skills
technical mentorshipcollaborationcommunicationproblem-solvingleadership