Business Intelligence (BI) Developer / Analyst
MediaRadar, United States
Job Description
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 amp; 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 amp; 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 amp; 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, amp; Inclusion Team meets frequently to create and roll out initiatives, events, and s