Business Intelligence Developer, Channel Performance

Job Description

What makes this role important at Ipsos?

The Business Intelligence Engineer will deliver forward-thinking, innovative build and deploy solutions as we are experiencing significant growth within our BI technologies. The Business Intelligence Developer will design, develop and support the data structures underpinning our Ipsos data repositories to support both internal business decisions and data-driven solutions for our many end clients. This role will provide support in the following areas:

• Business intelligence tools
• ETL tools and best practices
• Data cleaning best practices
• API Data calls

What you can expect to be doing:

• Gather and transform business requirements into innovative Business Intelligence solutions that effectively support our business.
• Drive data model design
• ETL processes for multiple data repositories.
• Interact with business users and technical teams throughout the development life-cycle; analyzing problems and clearly articulating solutions.
• Design data table structure
• Responsible for general debugging and query optimization
• Custom Scoring code
• Assist in survey design and programming when needed
• Complex client locations list / sample transformations
• Bulk session creation and management

Required Technical Skills

• 2-3+ years of experience with data processing, dashboards and report development
• A Bachelor's Degree in Computer Science, Management Information Systems, or closely related field.
• Some experience in SQL, SSIS
• Preferred experience with BI and Reporting tools such as SSRS, Tableau, Qualtrics
• Reliability and consistency in ability to deliver on commitments; meeting timelines, attention to detail, and anticipating business teams' needs.
• Experience with web development technologies is a plus, but not required.
  • Trusted advisor for complex technical solutions

Other Required Skills

• Ability to collaborate across disciplines
• Balance competing priorities in a fast-paced environment
• Analytical and problem-solving
• Leadership & Collaboration skills
• Process improvement and automation leadership skills

What success in this role looks like:

Our CHP service line specializes in all matters relating to measuring, managing and improving customer relationships and the overall customer experience. We help our clients manage the experiences they deliver in a way that maximizes the value of both customers and employees to their organization.

The Business Intelligence role is a key role in the CHP organization as we expand and grow our technology focused portfolio of offerings and services. This role is intended to be a hybrid between a traditional Saas solutions and custom solutions management, where clients have technology platforms at the core of the solution. The Business Intelligence Developer will be responsible for maximizing data driven models to meet defined business requirements and become proficient in data table structure and ETL processes.

What's in it for you:

At Ipsos you'll experience opportunities for Career Development, an exceptional benefits package (including generous PTO, healthcare plans, wellness benefits), a flexible workplace policy, and a strong collaborative culture.

To find out more about all the great reasons to work at Ipsos, how we're making an impact around the world, and more about our benefits and employee programs, please visit: US - https://www.ipsos.com/en-us/careers/opportunities-ipsos

Commitment to Diversity

Ipsos recognizes the necessity of building an inclusive culture that values each employee's individuality and diverse perspectives. For more than 40 years, our mission has been to generate and analyze data about society, markets, brands, and behaviors to provide our clients with the insights that elevate their understanding of the world. This could not be fulfilled without Ipsos' diverse employees who compile and analyze this data-they are the essence of who we are and what we do.

We are committed to providing equal opportunity to all employees, creating an environment that promotes inclusion, and enabling employees from all walks of life to flourish. Ipsos encourages our employees to act in a respectful and responsible manner, in line with code of best practices concerning diversity and inclusion, human rights, equality, and civility for every individual.

Ipsos is An Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or any other protected class and will not be discriminated against on the basis of disability.

#LI-AA1

#LI-Hybrid

About Us

Ipsos is one of the world's largest research companies and currently the only one primarily managed by researchers, ranking as a #1 full-service research organization for four consecutive years. With over 75 different data-driven solutions, and presence in 90 markets, Ipsos brings together research, implementation, methodological, and subject-matter experts from around the world, combining thematic and technical experts to deliver top-quality research and insights. Simply speaking, we help the biggest companies solve some of their biggest problems, serving more than 5000 clients across the globe by providing research, data, and insights on their target markets. And we're proud to share we've received our Great Place to Work Certification in 2022 & 2023!

About the Team

The Channel Performance Service Line is home to the largest mystery shopping agency in the world. We complete over one million shops every year in 100+ countries across all industry segments and organization sizes. We also offer Geolocation Surveys, Site Audits & Installations, and foundational research within our portfolio of services. Our purpose is to help our clients improve their business performance across all channels in which they serve their customers - brick and mortar retail, digital e-commerce, and contact centers. We do this by helping them size channel opportunities, measure the delivery of brand promises, and drive compliance and sales conversion across these channels.