Business Intelligence Analyst

Aditude is a technology company focused on ad operations, aiming to help publishers maximize revenue through innovative solutions. They are seeking a Business Intelligence Analyst to transform data into actionable insights by writing SQL, building dashboards, and collaborating with various teams to address complex business questions.

Responsibilities:

• Write and optimize SQL queries against our Snowflake data warehouse to answer business and customer questions
• Build and maintain dashboards and visualizations in tools like Looker, Mode, or Tableau
• Design and develop data models that make analysis faster and more reliable for the whole team
• Partner with internal teams and external customers to gather requirements, scope analyses, and deliver polished reporting
• Debug data issues — trace unexpected numbers back to their source, validate pipelines, and communicate findings clearly
• Document your work so others can build on it
• Juggle multiple requests and prioritize based on impact

Requirements:

• Bachelor's degree in Computer Science, Engineering, or related field
• 2-4 years of experience in a BI, analytics, or data analyst role
• Strong SQL skills — you're comfortable with joins, window functions, CTEs, and writing performant queries against large datasets
• Hands-on experience with a BI/visualization tool — Tableau, Looker, Mode, or similar
• Solid grasp of data modeling concepts — star schemas, fact vs. dimension tables, grain, normalization trade-offs
• Strong attention to detail — you care about whether a number is right, whether a chart is formatted well, and whether a stakeholder will actually understand what you've built
• Comfort working independently — you can take a vague question, figure out what's really being asked, and come back with a clear answer
• Great communication — you can explain a technical finding to a non-technical audience without losing the nuance
• Genuine curiosity — you want to understand not just the data but the business behind it
• Excellent problem-solving skills and ability to thrive in a fast-paced, dynamic environment
• Strong communication skills and ability to collaborate effectively with team members of varying technical backgrounds
• Experience with a cloud data warehouse (Snowflake, BigQuery, Redshift)
• Light Python or scripting experience for automation and one-off analysis
• Exposure to programmatic advertising, ad tech, or related domains (SSPs, DSPs, Prebid, Google Ad Manager, OpenRTB) — or strong interest in learning
• Familiarity with Git and version-controlled analytics workflows (dbt, LookML, etc.)
• Comfort working with APIs to pull data from third-party platforms