Business Intelligence (Bi) Developer / Analyst

MediaRadar offers comprehensive advertising analysis for over 3.1 million brands across multiple media platforms including TV, digital, mobile, email, events, social media, and print. Our 2200+ ad tech & media company clients enjoy the unmatched quality and award-winning customer service that helps them identify sales opportunities, create bulletproof pitches, and get the most from every sale.

We are seeking a highly skilled and knowledgeable individual to join our team as a Business Intelligence (BI) Developer / Analyst. This role requires someone with a deep expertise in SQL and a strong proficiency in using Looker for intricate data analysis and reporting. As a part of our team, you will play a pivotal role in developing, maintaining, and managing advanced reporting, analytics, dashboards, and various other BI solutions. Your keen attention to detail, analytical mindset, and ability to deliver accurate insights will be key in driving data-driven decision making within our organization.

What You'll Do:

• Design, develop, and maintain BI solutions, including data models, dashboards, and reports using SQL and Looker.
• Collaborate with cross-functional teams to gather and translate business requirements into technical specifications.
• Ensure the accuracy and integrity of data used for BI reporting.
• Perform complex data analysis to extract insights and support business decisions.
• Optimize and maintain database, query, and dashboard performance.
• Provide training and support to users on Looker and other BI tools.
• Keep abreast of the latest trends and best practices in BI technology.

Requirements

What You've Done:

• Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field.
• Minimum of 3 years of experience in a BI Developer/Analyst role.
• Strong proficiency in SQL for complex queries, data manipulation, and analysis.
• Familiarity with data warehouse design (e.g., dimensional modeling) and data mining.
• Excellent analytical, problem-solving, and decision-making skills.
• Ability to work in a fast-paced environment and manage multiple projects simultaneously.

Preferred Skills:

• Experience with other BI tools (e.g., Tableau, Power BI) is a plus.
• Knowledge of ETL processes and experience with ETL tools.
• Experience working with cloud data platforms (e.g., AWS, Azure, Google Cloud).
• Programming experience in Python or R for data analysis.
• Experience with SQL Server, Postgres, Redshift, Databricks
• Extensive experience with Looker, including LookML development.

While we have outlined certain minimum requirements for this role, please don't let that deter you if you feel you can excel in this position. We understand that diverse experiences and backgrounds can bring fresh perspectives to our team, and we welcome applications from individuals who may not check off all the boxes.

At MediaRadar, we are committed to creating a diverse, inclusive, and welcoming environment for all employees, living our core values every day. We are Good People, valuing the unique perspectives and experiences that each team member brings to our organization. We love Data and believe that diverse experiences and talents contribute to a richer, data-driven decision-making process.

Our inclusive culture promotes respect, equality, and opportunity at every level, reflecting our value of being Teammates and working together harmoniously. We Listen to the diverse voices within our team, fostering curiosity and an environment where everyone's opinions matter. We are Transparent in our commitment to equality and inclusion.

Benefits

In addition to career progression, training and development, and an excellent work/life balance, future Radarians can expect a great benefits package that includes:

• Medical, Dental & Vision Insurance
• 401k with Company Match
• Paid Vacation, Sick Time, and Holidays
• Transit Discounts
• Summer Fridays
• Salary compensation for this role is up to $125k

At MediaRadar, employees are encouraged to work hard, have fun and develop strong relationships with their peers. While working remotely through the pandemic, we've grown closer and stronger by sharing our new home offices & home office coworkers (both human and animal!), as well as being open and discussing mental wellness and self-care during a challenging time. Employees love to connect with virtual happy hours, themed parties, talent shows and bingo nights. Our engaged Diversity, Equity, & Inclusion Team meets frequently to create and roll out initiatives, events, and strategies to keep MediaRadar a welcoming and inclusive place. We've won Stevie Awards for Client Service and have been named to Mogul's Best Places for Millennial Women to Work for the past two years

Check out what it's like to work with our awesome team here: http://muse.cm/1Mt0NCg

Every Radarian comes with a unique set of talents and experiences. Diversity, in all forms, makes us a smarter, more creative and more agile organization. We are proud to be an equal opportunity employer.

If you need assistance or an accommodation, you may contact us at HR@mediaradar.com