Senior BI Developer

The Position & Team

This role will report to the Director of Business Intelligence and is responsible for designing and developing data solutions within the DW environment(backend) as well as in the semantic reporting layer(frontend). You will also allocate 25% of your time to building and maintaining ETL pipelines that collect data from multiple sources in the warehouse. You will work closely with our data architect, frontend development team, as well as various internal stakeholders.

What You'll Do 

  • Work in the data warehouse environment which includes data structures (schemas and tables), SQL and ETL code, data logic, security, performance, DR, processes, and documentation
  • Design and develop dimensional, tabular, and relational data models utilizing various data sources and business domains (knowledge of dimensional modeling is required)
  • Build out the semantic reporting layer
  • Advise management on tools and technologies
  • Create technical documentation for system operations and processes
  • Design, develop, and own ETL jobs utilizing tools and custom scripting
  • Understand business use cases, gather requirements, and create comprehensive documentation and plans

Desired Skills and Experience

  • 5+ years of experience in business intelligence and data warehousing 
  • Deep expertise in data integration, highly skilled in at least 1 ETL tool
  • Database tuning and Cloud experience
  • Experience working with DBT, LookML, Fivetran, and Amazon Redshift is a plus
  • Expert in SQL (Data Modeling, Functions, Stored Procedures, Query Optimizations, etc.)
  • In-depth understanding of data modeling and design principles: conceptual, logical, and physical
  • Strong verbal/written communication and presentation skills; ability to effectively communicate with business and technical teams.

Additional Perks

  • 100% paid medical insurance for employees
  • HSA match
  • 401(k) match
  • Charitable giving match
  • Flexible PTO Policy
  • Continuing Education benefit
  • Stock Options
  • Generous parental leave policy
  • Home office stipend 
  • Commuter benefits

Learn more: 

You Are Welcome Here

CallRail understands that valuing diverse creative practices and forms of knowledge are crucial to and enrich the company's core mission. We encourage applications from everyone, including members of all equity-seeking communities, such as (but certainly not limited to) women, racialized and Indigenous persons, persons with disabilities, and persons of all sexual orientations and gender identities and expressions. In your application, please feel free to note which pronouns you use (For example - she/her/hers, he/him/his, they/them/theirs, etc).

Submit your application