At Bitly, we believe in the power of the link or scan - to start a conversation, build a relationship or grow a business. Our mission is to turn every interaction into a catalyst for connections. It’s what motivates us to help people share, promote and engage everywhere on the Internet. We do this by being relentlessly product-focused, fostering the free-flowing exchange of ideas, and inspiring people around the world to dream up new ways of using Bitly.

As a Data Modeler at Bitly, you will architect, build, and maintain a data warehouse and analytics infrastructure in support of our business analytics and data reporting. The infrastructure created by this team is critical in the team’s mission to support and provide insights to Bitly.

Bitly supports every country in the world and every platform imaginable. Our systems are built to process an enormous amount of data. The Business Intelligence and Analytics team takes this challenge seriously and aims to create a platform that makes data easily accessible to answer even the thorniest business questions.

What You'll Do

• In collaboration with others, architect the data warehouse
• Work with various teams to identify the source of truth for data needed for dashboards and analysis
• Analyze source data, understands the needs of dashboards and analysis to design data models
• Create specs to implement data models and maintain metric definitions
• Understand and document data quality issues
• Develop and maintain data warehouse standards
• Assist business analysts with questions as needed

Who You Are

• You have 3+ years of data modeling experience
• You are an expert in SQL and have experience with at least one cloud SQL platform preferably BigQuery
• You are an expert on profiling data and uncovering data quality issues that impact analysis and dashboards
• You design data models with a deep understanding of how the data will be used by the BI tool and analysis 
• You look to understand the business processes behind the data
• You are familiar with Looker and dbt
• You can communicate technical concepts and ideas within the BI team and to other parts of the organization.
• You take initiative in addressing issues or seeking support from fellow team members.
• You’re passionate about using data to add value to business decisions

Our Values

• Customer First. We are fiercely committed to our customers' success. Our Job is to ensure that our trusted platform, performance, and people help customers achieve their goals
• Growth Focused. We are building a fast growing, healthy business powered by quick learning, constant optimization, and data driven decisions
• R.E.S.P.E.C.T. We are a team that respects each other and values diversity and inclusion. We treat others as we’d want to be treated and uphold the highest levels of integrity in everything we do
• >(!=) Greater than, not equal to. We are driven to win, bring our “A Game” to work each day and deliver exceptional results
• Do or Do Not, There is No Try. We say what we are going to do and we do it

Employee Benefits

• Competitive Salary
• Medical, dental, and vision insurance
• 401k 

Applicants must be currently authorized to work in the United States on a full-time basis.

If you are based in California, we encourage you to read this important information for California residents linked here. (https://bitly.is/CCPACandidates)

In keeping with our beliefs and goals, no employee or applicant will face discrimination or harassment based on: race, color, ancestry, national origin, religion, age, gender, marital domestic partner status, sexual orientation, gender identity, disability status, or veteran status. Above and beyond discrimination/harassment based on “protected categories,” Bitly also strives to prevent other, subtler forms of inappropriate behavior (e.g., stereotyping) from ever gaining a foothold in our office. Whether blatant or hidden, barriers to success have no place at Bitly.