Okay, I've searched for Data Analyst positions in New York City that require strong SQL skills and experience with Tableau. Filtering for full-time opportunities with a salary of at least $100,000, I've found 27 relevant positions for you.

Sure. Here's the analysis:

Job Analysis:

The Data Analyst role at New York Public Radio is fundamentally centered on transforming raw data into actionable insights that inform content strategies and audience engagement. This means that the individual will not only collect and analyze data from various sources, including listening metrics and audience interactions, but they will also be responsible for creating easily interpretable datasets and dashboards that empower cross-functional teams to make data-driven decisions. The ideal candidate must understand the nuances of audience behavior in the media landscape, as they will bridge data engineering and analytics to influence how the organization tailors its programming and services. Success in this role will hinge on the ability to convey complex findings to non-technical stakeholders and drive a culture of data-informed decision-making, which requires both technical prowess and strong communication skills. The candidate will face challenges such as aligning diverse team objectives with data insights, ensuring data integrity, and maintaining up-to-date dashboards that reflect shifting KPIs in the fast-paced media environment. Performance expectations may include the timely delivery of dashboards, active engagement in collaborative discussions, and a demonstrable impact on audience engagement metrics.

Company Analysis:

New York Public Radio occupies a unique space in the public media industry, known for its innovative approaches to storytelling and audience engagement. As a cornerstone of public media, NYPR is positioned as both a leader and a trendsetter in reshaping radio for a contemporary audience. This positioning supports a culture that values creativity and responsiveness, which will significantly impact how a Data Analyst fits into the organization. The company's commitment to diversity, equity, and inclusion is critical, fostering an environment that encourages diverse perspectives in journalistic storytelling, which will likely influence collaborative dynamics within the team. As part of the Audience Team, the Data Analyst will engage in a cross-functional capacity, working with various departments that possess distinct objectives yet share a common goal of cultivating deeper relationships with listeners. The role's strategic alignment suggests that the Data Analyst is vital for enhancing data literacy across the organization and driving growth through informed decisions that resonate with community needs. This context signifies a need for proactive engagement, adaptability, and a passion for public media, all of which are important for long-term success within NYPR.

Absolutely. Here are some mock interview questions that could come up:

• Tell me about a time when you had to translate complex data insights into actionable recommendations for a non-technical audience.
• Describe a project where you used SQL to analyze data. What challenges did you face and how did you overcome them?
• Can you share an experience where you identified a significant trend in audience behavior? How did that influence decision-making?
• How do you approach creating dashboards in Tableau or other BI tools to ensure they are both impactful and user-friendly?
• Explain your experience working with AWS Redshift or cloud-based data warehousing. How have you managed data pipelines in the past?
• What steps would you take when starting a new analytics project to ensure the datasets are clean and analysis-ready?
• Imagine you are tasked with defining KPIs for a new podcast series. What factors would you consider in establishing these metrics?
• If you discover that listener engagement is declining in a specific segment, how would you approach analyzing the issue and communicating it to the team?
• Why are you interested in working at New York Public Radio specifically, and how do your values align with our mission?
• How do you see your role as a Data Analyst contributing to the overall objectives of NYPR?
• What excites you the most about using data in a media organization, and how would you leverage data to enhance audience experiences?
• What questions do you have about the current challenges facing NYPR's audience engagement strategies?
• How do you prioritize your workload when you have multiple requests from different teams requiring data insights?
• Describe a time when you had to balance rigorous data analysis with the need for accessibility and storytelling. How did you approach it?
• What do you believe is the most critical aspect of fostering a culture of data-informed decision-making within an organization?