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.

Bitly is looking for an Analytics Engineer who is passionate about data, analytics, and business intelligence. Our Business Intelligence team believes in the power of information, and we work hard to make data available and actionable by everyone in the company. As an Analytical Engineer, it will be your job to design and build our data warehouse, maintain dbt models feeding this warehouse, become an expert on Bitly’s massive data sets, and assist analysts in answering critical business questions.

 

If you want to create the foundation for data-driven transformation at a growing company, we would love to meet you.

 

This role reports to the Director of Business Intelligence on the Business Intelligence and Analytics team.

What You'll Do

• Design and build dbt data models to ensure that relevant data is available in the data warehouse for dashboards and analysis.
• Analyze data when building data models to identify data quality issues
• Monitor data models to ensure data is loaded into the data warehouse every day. Correct issues preventing data from being loaded.
• Create and maintain documentation on dbt models, data assessment, and other data work
• Create, maintain, and adjust testing for all data processes
• Assist business analysts with questions as needed.
• Care deeply about enabling all employees at Bitly to do their best work.

Who You Are

• 3+ years of experience as a data or analytics engineer.
• You are fluent in dbt and familiar with reverse ETL tools such as Census. You also stay up to date with ongoing changes and advancements.
• Ability to write and optimize complex SQL queries.
• Familiarity with at least one cloud SQL platform, such as BigQuery or Redshift.
• Experience creating or maintaining a data warehouse.
• Ability to communicate technical concepts to audiences with varying levels of technical background.
• Comfortable supporting business analysts on high-priority projects and investigations.
• You take initiative in addressing issues or seeking support from fellow team members.
• You have experience using a flavor of version control—we use Git and GitHub to collaborate and manage pull requests.

Company 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 + Stock Options 
• Comprehensive and competitive medical, dental, and vision insurance (all LGBT friendly) 
• 401k with up to 4% employer match 
• One Medical membership: Doctors you can text, call or email 24/7 and receive access to expert insurance guidance where available
• Wellness reimbursement program
• Partial cell phone service reimbursement 
• Voluntary LegalShield for legal services and IDShield for identity theft protection
• Unlimited vacation, personal time, and flexible work from home policies 
• Full support for remote work during COVID-19, including a home office and separate WiFi stipend 
• Generous parental leave policies; maternity and parental leave for growing families
• Budget for professional development opportunities, including courses and conference attendance 
• Company sponsored volunteering opportunities (when it is safe to do so) 

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.