Senior Business Intelligence (BI) Analyst

Columbus, United StatesOn-site

Responsibilities

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.
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.

Bachelor’s degree (or equivalent foreign education) in computer science, computer engineering, information technology or related field
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.
Free Affiliate & Partnerships Industry Fundamentals Certification by PXA.

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
Flexible spending accounts and 401(k)
Offered Salary: $180,000/year

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.
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.

Its award-winning products - Performance (affiliate), Creator (influencer), and Advocate (customer referral) - unify every type of partner into one integrated platform.
Independently complete bug and minor enhancement ticket and complete designs for new feature requests.
Catered lunch every Friday, a healthy snack bar, and great coffee to keep you fueled
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!
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.