
Principal, BI Developer
Cotality
full-time
Posted on:
Location Type: Office
Location: Dallas • Texas • United States
Visit company websiteExplore more
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