Senior Business Intelligence (BI) Analyst

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.

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

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

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