Business Intelligence Developer - Data Solutions and Technology

Business Overview 

Orion Worldwide is a global media company that generates value for our business partners. As the industry has evolved over the past two decades, so have we — expanding our global reach and product offering to deliver value for the world’s best brands, across nearly every category. The very best ideas are developed by people with diversity of background, thought and experience working together to develop customized solutions that best address our partners’ needs. A five-time winner of “Most Inclusive Climate” at the IPG Inclusion Awards, we scale our recruiting efforts beyond the traditional advertising candidate pool to find people who possess the passion, innovative thinking and collaborative skills needed to achieve our business goals and assist in cultivating a culture in which we can all be proud.

We are seeking a skilled and enthusiastic Business Intelligence Dashboard & Report Developer to join our team and help us harness the power of data to drive impactful decisions.

Responsibilities

• Collaborate with stakeholders to understand their needs and translate them into impactful visualizations
• Design, develop, and maintain interactive dashboards and reports using business intelligence tools (e.g., Tableau, Power BI, Qlik Sense), ensuring seamless access and user experience
• Craft visually compelling and interactive dashboards and reports using Power BI Desktop or Tableau, incorporating a wide range of visualization types, including charts, maps, tables, and custom visuals
• Deploy the solution to production environments following established procedures
• Participate in code reviews and knowledge sharing sessions
• Provide technical support and troubleshooting for data-related issues
• Optimize your Power BI solutions for speed and efficiency, using techniques like data compression, query optimization, and efficient data loading strategies
• Design and implement robust data models and visualizations that are user-friendly, insightful, and visually appealing
• Contribute to the development and maintenance of data pipelines and data warehouses
• Ensure data accuracy, consistency, and integrity across all dashboards and reports
• Develop and maintain documentation for data models, data pipelines, and ETL processes
• Implement best practices for data governance and security, ensuring data integrity and compliance with company policies
• Continuously learn and adapt to the latest features and functionalities of Power BI, exploring innovative ways to leverage its power for data exploration and analysis

Required Skills & Experience

• Bachelor's or Master's degree in a related field such as Data Visualization, Statistics, Mathematics, or Computer Science preferred
• 5+ years of experience in data analysis and developing visualizations in Power BI, Tableau or similar BI reporting tool, with a minimum of 3 years specific to Power BI
• Proven experience in developing and deploying Power BI dashboards and reports, demonstrating a deep understanding of Power Query, Power Pivot, and DAX
• Proficiency in SQL and data manipulation techniques, with experience in data modeling and designing efficient data structures. 3+ years working with SQL with ability to utilize SQL to perform exploratory data analysis
• Strong understanding of data visualization principles and best practices, with a knack for creating engaging and impactful narratives through data
• Excellent analytical and problem-solving skills, with a keen eye for detail and the ability to identify patterns and trends in data
• Strong communication and interpersonal skills, with the ability to effectively collaborate with stakeholders and communicate complex data insights in a clear and concise manner
• Familiarity with software development concepts and agile methodologies
• Experience with Snowflake, AWS, Azure or other cloud-based data solutions
• Ability to work independently and as part of a team.

Desired Skills & Experience

• Experience with 3rd party data providers, DSPs, SSPs is a plus
• Programmatic, Digital or Media Operations experience desired (we welcome candidates from across agency, client and supply side)
• Knowledge of marketing or advertising industry data and best practices

We See You  

At IPG Mediabrands, we are unified behind a commitment to fostering a culture of inclusion and belonging. Together, we shine through a set of shared values and behaviors. We take pride in our responsibility to our clients, communities, and to each other. We embrace differences and recognize the unique value that each of us brings to our community.  

We encourage you to apply, as unique backgrounds, perspectives, and lived experiences are welcomed.   

We See You at IPG Mediabrands. 

Wage and Benefits

We offer a Total Rewards package that includes medical and dental coverage, 401(k) plans, flex spending, life insurance, disability, employee discount program, employee stock purchase program and paid family benefits to support you and your family. To give you the ability to better meet your personal needs, and in support of your physical and emotional well-being, you will receive discretionary time off days and company-wide Appreciation Weeks and Wellness Days. 

We also offer a competitive Total Compensation package, including a competitive salary and eligibility for an annual discretionary incentive award or a relevant incentive award. 

The salary range for this position is posted below.  Where an employee or prospective employee is paid within this range will depend on, among other factors, actual ranges for current/former employees in the subject position, market considerations, budgetary considerations, tenure and standing with the Company (applicable to current employees), as well as the employee’s/applicant’s skill set, level of experience, and qualifications.   

Employment Transparency

It is the policy of Mediabrands, division of the Interpublic group, to provide equal employment opportunities to all employees and applicants for employment without regard to race, color, ethnicity, gender, age, religion, creed, national origin, sexual orientation, gender identity, marital status, citizenship, genetic information, veteran status, disability, or any other basis prohibited by applicable federal, state, or local law. 

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice. 

The employer will make reasonable accommodations in compliance with the American with Disabilities Act of 1990. The job description will be reviewed periodically as duties and responsibilities change with business necessity. Essential and other job functions are subject to modification. Reasonable accommodations may be provided to enable individuals with disabilities to perform the essential functions.  

For applicants to jobs in the United States: In compliance with the current Americans with Disabilities Act and state and local laws, if you have a disability and would like to request an accommodation to apply for a position with Mediabrands, please email [email protected].

About IPG Mediabrands 

IPG Mediabrands is the media and marketing solutions division of Interpublic Group (NYSE: IPG). IPG Mediabrands manages over $47 billion in marketing investment globally on behalf of its clients across its full-service agency networks UM, Initiative and Mediahub and through its award-winning specialty business units Healix, Kinesso, MAGNA, Mediabrands Content Studio, Orion Holdings, Rapport, and the IPG Media Lab. IPG Mediabrands clients include many of the world’s most recognizable and iconic brands from a broad portfolio of industry sectors including automotive, personal finance, consumer product goods (CPG), pharma, health and wellness, entertainment, financial services, energy, toys and gaming, direct to consumer and e-commerce, retail, hospitality, food and beverage, fashion and beauty. The company employs more than 18,000 diverse marketing communication professionals in more than 130 countries. Learn more at www.ipgmediabrands.com.