Senior Business Intelligence (BI) Analyst

Posted Yesterday
Be an Early Applicant
Columbus, OH, USA
In-Office
180K-180K Annually
Senior level
Software
The Role
Design, build, and maintain SQL-based reporting and BI features; create test plans and documentation; optimize report performance; perform triage and bug fixes; lead technical improvements; mentor junior staff; collaborate with product and cross-functional teams to deliver customer-facing analytics and reporting solutions.
Summary Generated by Built In

About impact.com

impact.com is the world’s leading commerce partnership marketing platform, transforming the way businesses grow by enabling them to discover, manage, and scale partnerships across the entire customer journey. From affiliates and influencers to content publishers, brand ambassadors, and customer advocates, impact.com empowers brands to drive trusted, performance-based growth through authentic relationships. Its award-winning products - Performance (affiliate), Creator (influencer), and Advocate (customer referral) - unify every type of partner into one integrated platform. As consumers increasingly rely on recommendations from people and communities they trust, impact.com helps brands show up where it matters most. Today, over 5,000 global brands - including Walmart, Uber, Shopify, Lenovo, L’Oréal, and Fanatics - rely on impact.com to power more than 350,000 partnerships that deliver measurable business results.

What you'll  do: 

  • Develop, test and maintain SQL-based reporting features for the platform and complete advanced reporting tasks. 
  • Create test plans for new features, including identifying relevant data to cover all testing cases. 
  • Collaborate with a distributed team to fulfill the department’s quarterly objectives. 
  • Develop code both independently and while pair programming. 
  • Write and maintain design, user, and test documentation. 
  • Create well-performing SQL code within the impact.com data platform leveraging best practices.
  • Perform triage activities through verification and bug fixes. 
  • Independently build customer-facing code. 
  • Support software testing and quality assurance processes to ensure high-quality deliverables.
  • Independently complete bug and minor enhancement ticket and complete designs for new feature requests. 
  • Analyze reporting requirements, monitor report usage and performance to ensure optimal runtime performance, and diagnose performance issues within SQL. 
  • Perform code reviews.
  • Initiate and lead technical approaches and process improvements, and introduce and lay the foundation for new technologies in the stack. 
  • Perform root cause analysis for multiple systems and provide insights and recommendations. 
  • Mentor and provide guidance to junior staff members. 
  • Develop epics, tasks, and sub-tasks and work with Product Managers and cross squad planning. 
  • Provide growth and stability projections.

What you bring: 

  • Bachelor’s degree (or equivalent foreign education) in computer science, computer engineering, information technology or related field 
  • 5 years of business Intelligence (BI) experience in the marketing datasets or web analytics datasets domain leveraging PowerBI, MicroStrategy, Tableau, Domo Google Data Studio, Looker, or Qlik Sense.

Special Skills Required:

  • Demonstrated expertise leveraging PowerBI, MicroStrategy, and Tableau BI tools in the data analytics and visualization landscape.  
  • Demonstrated expertise  developing queries leveraging 2 or more of the following database platforms: MySQL, Oracle, SQL Server, or Impala. 
  • Demonstrated expertise  performing dimensional modeling leveraging the core principles of Ralph Kimball, including Star Schema, Conformed Dimensions, Business Driven Design, Bottom-Up Approach, and Data Quality and Metadata.

Benefits (Perks):

  • Medical, Dental, and Vision insurance
  • Unlimited responsible PTO
  • Flexible work hours
  • Parental Leave
  • Free Affiliate & Partnerships Industry Fundamentals Certification by PXA.
  • Catered lunch every Friday, a healthy snack bar, and great coffee to keep you fueled 
  • Flexible spending accounts and 401(k)
  • An employee-led culture team that plans inclusive events- meaning time together and other events to celebrate our many successes!
  • An established company with a cool, high-velocity work ethos, where each person can make a difference!

Offered Salary: $180,000/year 

We are an equal-opportunity employer and value diversity at our company. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.


Skills Required

  • Bachelor's degree in computer science, computer engineering, information technology, or related field (or equivalent)
  • Minimum 5 years business intelligence experience in marketing or web analytics datasets
  • Experience developing SQL-based reporting and writing well-performing SQL code
  • Demonstrated expertise using PowerBI, MicroStrategy, and Tableau
  • Experience with BI/visualization tools such as Domo, Google Data Studio, Looker, or Qlik Sense
  • Demonstrated expertise developing queries on 2 or more of: MySQL, Oracle, SQL Server, Impala
  • Demonstrated expertise in dimensional modeling using Ralph Kimball principles (Star Schema, Conformed Dimensions, etc.)

impact.com Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about impact.com and has not been reviewed or approved by impact.com.

  • Parental & Family Support Paid family leave is described as generous for both birthing and non-birthing parents, with policies applied globally. Extended fully paid leave is highlighted as a standout element of the package.
  • Leave & Time Off Breadth A flexible, unlimited time-off policy allows employees to take leave as needed. Flexible working, including remote options, is emphasized to support work-life balance.
  • Wellbeing & Lifestyle Benefits Wellbeing support includes fully covered therapy/coaching sessions and gym reimbursement. Employees also receive home-office and internet stipends, with office-based perks like weekly catered lunches in some locations.

impact.com Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Santa Barbara, CA
824 Employees
Year Founded: 2008

What We Do

Impact is transforming the way enterprises manage and optimize all types of partnerships. Our Partnership Cloud™ is an integrated end-to-end solution for managing an enterprise’s partnerships across the entire partner life cycle to activate rapid growth through the emerging Partnership Economy™. Impact was founded in 2008 by a team of Internet marketing and technology experts who previously founded Commission Junction, Savings.com and LeadPoint. From the beginning, we disrupted the industry by moving away from the traditional affiliate network model and instead introducing a SaaS technology platform for performance marketing professionals to better grow and manage all their revenue generating partnerships.

Similar Jobs

OpenX Technologies Logo OpenX Technologies

Senior Data Analyst

AdTech • Enterprise Web • Information Technology • Machine Learning • Marketing Tech • Sales
Easy Apply
Remote or Hybrid
US
420 Employees
106K-125K Annually
In-Office
Cincinnati, OH, USA
4738 Employees

Similar Companies Hiring

Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account