Data Insights and Infrastructure Lead

BSM Partners is the world's largest consultancy focused on the pet care industry. BSM Partners engineers the infrastructure the pet care industry runs on — science, nutrition, regulatory affairs, veterinary medicine, engineering, supply chain, consumer intelligence, and media operating as one integrated system, staffed by domain experts who have spent their careers building the standards the industry now follows.

Our research program and partnerships with leading industry organizations give us a unique view of the market. We combine deep industry expertise with data, technology, and strategic thinking to help our clients make better decisions and build better businesses.

BSM Partners is seeking a Data Insights and Infrastructure Lead to build and manage the infrastructure that enables data to flow efficiently across the organization and ultimately become actionable business intelligence.

This role will be responsible for building the pipelines, integrations, connections, tools, and systems that collect and organize data from multiple sources and make it reliable, accessible, and ready for analysis.

A major focus will be BSM Partners' expanding NIQ reporting initiative, including web-enabled dashboards and automated reporting capabilities. The Data Insights and Infrastructure Lead will play a critical role in building, operating, and maintaining the systems that support this effort — ensuring that data is reliable, accessible, well-governed, and ready to be transformed into insights.

This is a hands-on role for someone who enjoys solving complex data challenges, building systems from the ground up, and partnering with analysts and business leaders to turn data into useful information.

• Design, build, and maintain scalable data pipelines, databases, integrations, and data infrastructure.
• Connect internal systems with external data sources, APIs, and third-party platforms.
• Build reliable processes for ingesting, transforming, validating, and organizing data.
• Establish systems that allow data to flow efficiently from source systems into analytical and reporting environments.
• Monitor data pipelines and integrations to identify and resolve errors, inconsistencies, and performance issues.
• Automate manual data collection, transformation, reporting, and administrative workflows.
• Build infrastructure that can scale as BSM Partners' data needs and client requirements grow.
• Evaluate and implement technologies and tools that improve data infrastructure, automation, and analytical capabilities.

• Build and maintain dashboards, reporting tools, and data products used across the organization.
• Support the development of web-enabled dashboards, particularly as part of the NIQ reporting initiative.
• Develop automated reporting solutions that reduce manual work while maintaining data accuracy and integrity.
• Create repeatable processes for turning raw data into analysis-ready datasets.
• Work closely with analysts to understand their data requirements and build the infrastructure necessary to support them.
• Help establish KPIs, data definitions, measurement frameworks, and standardized reporting methodologies.
• Identify opportunities to improve how the organization accesses, interprets, and uses data.

• Establish and maintain data governance standards, documentation, definitions, and best practices.
• Develop processes that improve data accuracy, consistency, completeness, and reliability.
• Establish appropriate controls for data access, security, and integrity.
• Document data sources, pipelines, transformations, business rules, and dependencies.
• Develop systems and processes that create confidence in the data being used for…