Audience Insights Coordinator

Job Summary The Audience Insights Coordinator works within the Digital Services Bureau, a group of digital and data professionals that supports departments across Connecticut Public. The coordinator helps turn audience and media data into useful information that supports programming, distribution, marketing, and digital decision-making. The Audience Insights Coordinator supports research and analysis of media consumption and audience behavior, identifies trends, and helps communicate actionable insights. This work helps Connecticut Public better understand and serve existing audiences, reach new audiences, and advance organizational goals. Essential Functions Assists in identifying patterns, trends, and actionable insights in the data and helps communicate findings and recommendations. Collects and analyzes data on internal and external marketing campaigns, such as on-air promotions, social media, email, podcast, and advertisements promoting Connecticut Public’s programs, services, events, donations. Ensures our data is available, complete, consistent, and in the formats needed for our digital team to develop insights and strategies that drive product and content development and distribution. Supports the development and maintenance of analytics tracking for website features and functionality, and helps identify insights that can improve the user experience. Works closely with the Director, Data Strategy and Audience Insights to determine what data and research is needed and how it should be collected and analyzed, in order to monitor audience trends and answer specific content and audience inquiries. Responsibilities Additional duties may, at times, be assigned and required. Assists in establishing consistent processes and standards for data collection and cleansing. Collects, cleans , and analyzes data from multiple sources. Cleans and transforms data in Microsoft Excel and other tools to support efficient analysis of large data sets. Communicates with the Digital Services Bureau about project scope, timelines, progress, and key findings Coordinates with PBS and NPR partners, vendors, and data providers such as Nielsen, Triton, and mobile app developers regarding data availability and accuracy. Identifies critical data issues and facilitates resolution. Maintains methodology documentation and source mapping and assists in developing data workflows. Provides quarterly , monthly , and ad hoc tracking, dashboards, and reporting for multiple audiences. Translates data into Looker Studio dashboards to showcase trends and insights through data visualization. Knowledge, Skills, and Abilities Knowledge of: Basic data administration and management functions, including collection, analysis, and reporting. Databases, CRM systems, or customer data platforms Microsoft Excel, including working with large data sets, formulas, pivot tables, and data cleaning. Looker Studio and Google Analytics, or similar analytics and reporting tools. Skill in: Analyzing digital or media-related data; experience with broadcast media data is helpful but not required . Attention to detail, scheduling and strong organizational skills. Building positive working relationships across departments and contributing as a team member. Clear written and verbal communication and collaboration. Data organization, attention to detail, and problem-solving. Managing time and priorities across multiple projects and meeting deadlines. Organizing projects, tracking tasks, and following through on deliverables. Tools or data sources such as Nielsen, Triton, or Brightcove is a plus, but not required . Working with data in different formats and supporting teams with data analysis and reporting. Ability to: Apply analytical thinking and practical problem-solving skills. Ask questions, clarify needs, and work effectively when requirements are not fully defined. Develop an understanding of and interest in public media and Connecticut Public’s mission. Take initiative, manage priorities, and follow through on assigned work. Work collaboratively across departments and communicate data findings to colleagues with different levels of technical experience. Physical Requirements The physical activities of this position include frequent virtual interactions. Must be able to remain at a desk/computer workstation for prolonged period. Must have close visual acuity to perform an activity, such as preparing and analyzing data and figures, transcribing, viewing a computer terminal, or extensive reading. The typical physical requirements are: light work—exerting up to 15lbs of force occasionally and may include climbing, pushing, standing, hearing, walking, reaching, grasping, kneeling, stooping, and repetitive motion. Working Conditions The position is almost fully remote and j ob functions are typically performed under conditions similar to those found in general or home office work. This position is not substantially exposed to adverse environmental conditions. Duties are routinely performed Monday through Friday between the hours of 9:00 a.m. and 5:00 p.m.; however, evening and weekend support may be necessary. Education and Experience Bachelor’s degree in Information Science, Marketing, Business Administration, Communications, or a related field from an accredited university OR an equivalent combination of education, training, and experience. One to three (1 to 3) years of direct and sustained relevant experience working with data, analytics, research, reporting, or digital media is preferedr AND/OR a satisfactory equivalent combination of education, training, and experience.