Sr Business Insights Analyst (70002633)

About the role

Optimum Media LLC in Long Island City, NY seeks a Senior Business Insights Analyst to serve as a strategic and technical leader within the Business Reporting/Insights team, responsible for advancing the development, strategy, and execution of revenue reporting and data products that empower decision-making across the News, Programming & Business Services division.

Responsibilities

• Play a pivotal part in shaping the roadmap and user experience of our core data product, leading high-impact dashboard and reporting initiatives, and ensuring alignment between data architecture, business reporting, and organizational strategy.
• Translate data into actionable and timely insights and visuals which will be used to drive strategic decisions.
• Act as project lead for complex ad-hoc requests, cross-functional initiatives, and AI/ML driven revenue analysis, collaborating with senior leadership and business partners from internal teams to ensure solutions are insightful, scalable, and strategically aligned with business goals.

Qualifications

• Master's degree in Business Intelligence Analytics, Finance, Statistics, Computer Science, or related field + 3 years of experience.
• Domo platform development, including advanced dataflow architecture and ETL pipeline construction.
• Magic ETL dataflow design, utilizing multi-stage transformations, rank/window tiles, and Python/R scripting tiles.
• Experience configuring Domo Writeback to enable bi-directional data pipelines that push transformed outputs back into data warehouses for real-time access.
• Writing performance-optimized SQL queries with window functions, CTEs, and complex multi-table joins across large-scale datasets.
• Google Apps Script development for macro automation, custom function building, and dynamic data transformation pipelines.
• Employer will accept any combination of education, training, or experience.

Pay

$126,610/yr. 40 hrs./wk, 9:00-5:00, M-F.