
Principal BI Engineer
Cotality
full-time
Posted on:
Location Type: Office
Location: Dallas • Mississippi • Texas • United States
Visit company websiteExplore more
Salary
💰 $135,000 - $135,300 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.
- Act as the Subject Matter Expert (SME) for SmartFees and OM billing, reporting, and data warehousing initiatives.
- Architect scalable, fault-tolerant solutions for data delivery.
- Design and maintain a unified semantic layer to ensure 'single source of truth' consistency across all reporting endpoints.
- Optimize data models, indexing strategies, and caching layers for sub-second report rendering.
- Write high-quality, maintainable code to automate data workflows.
- Lead the engineering effort to integrate analytical dashboards into customer-facing software products.
- Gather requirements directly from clients and manage project tracking and ticket resolution via Jira.
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 & Tools
SQLPythonJavaC#Scaladata warehousingsemantic layer designreporting architecturedata modelingautomation
Soft Skills
leadershipclient requirements gatheringproject managementcommunication