Senior Business Intelligence BI Analyst

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

Alliance/Partner Management, Alliance/Partner Marketing, Analysis Skills, Best Practices, Business Growth, Business Intelligence, Business Intelligence Software, Code Reviews, Computer Engineering, Computer Science, Consumer Branding, Customer Relations, Data Analysis, Data Quality, Data Visualization, Dental Insurance, Dimensional Modeling, Diversity, Global Branding, Identify Issues, Information Technology & Information Systems, Lead Generation, Mentoring, Metadata, MicroStrategy, Microsoft SQL Server, MySQL, Oracle Database, Patient Assessment, People Management, Performance Analysis, Performance Tuning/Optimization, Power BI, Process Improvement, Quality Assurance Methodology, Referenceable Customers, Requirements Management, Root Cause Analysis, SQL (Structured Query Language), Software Administration, Software Testing, Star Schema, Systems Analysis, Tableau, Technical Leadership, Test Case, Test Data, Test Plan/Schedule, Testing, User Documentation, Vision Plan

About the Company

Impact Tech Inc