Ibotta is looking for a Staff Business Intelligence Developer to join our Core Data & Analytics team who will help empower our company to make data-driven decisions by providing the right data at the right time to the Client Partnership and Client Sales teams. 

This position is located in Denver, Colorado as a hybrid position requiring 3 days in office (Tuesday, Wednesday, and Thursday). Candidates must live in the United States. Not based in Denver? We will offer a relocation bonus to help make your move to the Mile High City a smooth one

What you will be doing:

• Partner with key internal stakeholders within the organization to collect feedback and evolve our reporting capabilities

• Provide support across Client teams through reporting, monitoring, tracking, and analyzing business performance and results

• Analyze requirements and architect appropriate solutions, with detailed design documents

• Continuously seek the improvement of our reporting including, but not limited to, analysis, data, tools, process, performance, and data quality.

• Leverage reporting best practices to automate reports and find creative solutions to maximize reporting output

• Create and refine visual representation and communication of complex data

• Develop a logical, structured approach to conduct ad-hoc analyses and work backwards from hypotheses

• Design, develop, maintain, and optimize ETL and pipelines related to Business Intelligence

• Participate in the process improvements, and lead efforts around enablement and training of internal BI solutions to Client teams.

• Review the work of other team members and provide coaching on approaches to analytics and visualization requirements.

• Embrace and uphold Ibotta’s Core Values: Integrity, Boldness, Ownership, Teamwork, Transparency, & A great idea can come from anywhere.

Sample projects:

• Extract, wrangle, and automate large data transfers (on the order of trillions of rows) to democratize data and empower data-driven decision making across the company

• Manage, monitor, and provide recommendations on the quality of various data streams

• Design and create aggregate and summary tables for reporting efficiency purposes

• Analyze and deliver data to provide actionable insights about the effectiveness of the business above and beyond standard analysis

What we are looking for:

• 8+ years of practical work experience in Analytics; experience in mobile, retail, or CPG a plus 

• At least 4 years of in-depth experience with data warehousing and business intelligence platforms; experience with Looker business intelligence platform preferred 

• At least 6 years of expert level SQL and proven data wrangling skills with the ability to provide creative, actionable solutions/insights

• At least 2 years of strong knowledge of Python, Git; experience with Airflow, AWS, event-driven architecture preferred

• Bachelor’s degree in Computer Science, Engineering, Analytics or a related field required; advanced degree preferred 

• Consistent ability to clearly and professionally communicate data, processes, and results to senior leadership

• Proven ability to develop, maintain, automate, visualize, and communicate reporting for internal and external clients

• Detailed-Oriented team player with an ownership mindset and excellent communication skills 

• Understands the tradeoffs between technical, analytical and product needs and leads to solutions that take all of these needs into account

• Proven ability to set short to medium-term strategic analytical direction for key projects or products