Build and maintain Power BI reports, HTML dashboards, data models, forecasting workflows, retailer sales and inventory reporting, and advertising analytics. Partner with Sales, E-commerce, Finance, Marketing, and Publishing teams to interpret results and support decisions. Use SQL, scripting, and AI-assisted tools to develop reliable analytical products, troubleshoot issues, validate outputs, document methods, and improve reporting workflows.
Sourcebooks is seeking a Business Analyst II to partner with Sales, E-commerce, Finance, Marketing and Publishing teams on the business questions that shape our publishing performance. You will translate those questions into useful reporting, forecasts, and analytical tools, working collaboratively with colleagues across Sourcebooks to interpret results and put insights to use.
Reporting to the Senior Director of Analytics, you will take ownership of select analytical products from development through ongoing operation. Initial work will include forecasting, retailer reporting and advertising analytics, supported by collaboration with Power BI and data engineering colleagues. This hands-on role also offers the opportunity to apply AI-assisted and programmatic approaches to make analytical work more useful, reliable, and efficient.
The location for this position can be hybrid or remote in New York or Naperville, Illinois or remote based in any of the following states: Arizona, Connecticut, Illinois, Louisiana, Maryland, Massachusetts, Michigan, Minnesota, Montana, New Jersey, New York, Ohio, Oregon, Pennsylvania, Tennessee, Texas, Virginia, Washington, Washington D.C., and Wisconsin.
This an exempt salaried position with a range of $72,000 – $78,000/annually. We determine starting pay based on a thorough evaluation of job-related factors, including geographic location, market conditions, relevant experience, training, and education. This process ensures a fair and competitive salary that aligns with both the company and the candidate’s qualifications. What you’ll do:Reporting and analytical tools
Full-time employees are eligible for our comprehensive benefits program. Our range of benefits include, but are not limited to, Medical/Prescription drug insurance, Dental, Vision, Health Care/Dependent Care Flexible Spending Account, Health Savings Account, 401(k), Short and Long-Term Disability Insurance, Life/AD&D Insurance, & generous paid time off.
Sourcebooks values the array of talents and perspectives that a diverse workforce brings. All qualified applicants will receive consideration for employment without regard to race, national origin, religion, age, color, sex, sexual orientation, gender identity, disability, or protected veteran status.
Reporting to the Senior Director of Analytics, you will take ownership of select analytical products from development through ongoing operation. Initial work will include forecasting, retailer reporting and advertising analytics, supported by collaboration with Power BI and data engineering colleagues. This hands-on role also offers the opportunity to apply AI-assisted and programmatic approaches to make analytical work more useful, reliable, and efficient.
The location for this position can be hybrid or remote in New York or Naperville, Illinois or remote based in any of the following states: Arizona, Connecticut, Illinois, Louisiana, Maryland, Massachusetts, Michigan, Minnesota, Montana, New Jersey, New York, Ohio, Oregon, Pennsylvania, Tennessee, Texas, Virginia, Washington, Washington D.C., and Wisconsin.
This an exempt salaried position with a range of $72,000 – $78,000/annually. We determine starting pay based on a thorough evaluation of job-related factors, including geographic location, market conditions, relevant experience, training, and education. This process ensures a fair and competitive salary that aligns with both the company and the candidate’s qualifications. What you’ll do:Reporting and analytical tools
- Build, improve and maintain Power BI reports, HTML dashboards and data models that turn business requirements into clear, usable information.
- Develop reliable measures and reusable reporting components, working with data colleagues on modeling, performance, and development standards.
- Help develop programmatic, version-controlled reporting approaches, with opportunities to learn and apply Power BI Project and PBIR workflows.
- Build out, improve and maintain forecasting models and workflows.
- Monitor forecast outputs and accuracy, investigate unexpected results and explain meaningful changes, assumptions, and limitations.
- Work closely with the business teams that use forecasts to understand their needs, gather feedback, and refine outputs for planning and decision-making.
- Develop and maintain reporting on retailer sales, inventory, and ordering, including Amazon dashboards, and help users interpret performance and identify opportunities.
- Analyze advertising performance across platforms such as Amazon and Target, connecting campaign results with relevant sales and business measures.
- Translate findings into clear recommendations and explanations that support business partners' commercial and campaign decisions.
- Use AI tools to support coding, analysis, documentation and troubleshooting, validating generated work and handling data responsibly.
- Test and reconcile outputs, document methods, and run instructions, and maintain the quality and reliability of assigned reports and recurring workflows.
- Troubleshoot issues with business users and technical partners, escalate source or platform problems appropriately, and support adoption through practical guidance.
- A proactive approach, a can-do spirit, and a willingness and ability to grow and learn.
- Demonstrated experience building reports and analytical tools in Power BI, Tableau, or a comparable business intelligence platform.
- Experience working with forecasting models and communicating results to business stakeholders in clear, practical terms, including what has changed and what it means for their planning.
- SQL skills for querying, combining, and validating data, and familiarity with data preparation and transformation.
- Comfort working with code and analytical scripts, including the ability to understand, troubleshoot and improve existing workflows.
- Practical experience using AI tools for analytical or technical work, with the judgment to test outputs, identify errors and protect sensitive information.
- Analytical judgment and attention to detail, including the ability to investigate discrepancies and explain what data does and does not show.
- Clear communication and collaboration skills, with the ability to work with business users, manage agreed deliverables and document work so others can use and maintain it.
- 2-5 years of analytics experience in book publishing, or in comparable entertainment or content businesses where demand varies by title, release cycle, catalog age, seasonality, and promotion.
- Deeper Power BI experience, including DAX, data modeling, and report performance.
- Experience with Python or another analytical scripting language, Git, Microsoft Fabric, or programmatic Power BI development using PBIP and PBIR.
- Familiarity with retailer sales and inventory data or digital advertising measurement, particularly Amazon or Target.
Full-time employees are eligible for our comprehensive benefits program. Our range of benefits include, but are not limited to, Medical/Prescription drug insurance, Dental, Vision, Health Care/Dependent Care Flexible Spending Account, Health Savings Account, 401(k), Short and Long-Term Disability Insurance, Life/AD&D Insurance, & generous paid time off.
Sourcebooks values the array of talents and perspectives that a diverse workforce brings. All qualified applicants will receive consideration for employment without regard to race, national origin, religion, age, color, sex, sexual orientation, gender identity, disability, or protected veteran status.
Sourcebooks Naperville, Illinois, USA Office
1935 Brookdale Road, Ste. 139,, Naperville, IL, United States, 60563
Similar Jobs
Healthtech
Supports and configures Oracle Fusion ERP enterprise performance management applications for planning, budgeting, forecasting, reporting, and business performance. Leads application design, testing, implementation, troubleshooting, workflow analysis, and process improvements while collaborating with finance, IT, and business partners. Provides training, mentoring, documentation, system administration, and cross-functional project support.
Top Skills:
Enterprise Performance ManagementErp ConfigurationErp IntegrationsErp ReportingOracle Fusion CloudOracle Fusion ErpSaas Erp
Hardware • Security • Software • Cybersecurity
Business Analyst II translates business needs into technical requirements for enterprise ordering and product configuration systems. The role manages BOM simplification, SKU rationalization, CPQ and PLM workflows, AI-agent governance, test planning, configuration validation, and Agile backlog activities. It partners with product, sales, engineering, IT, supply chain, and operations teams to improve orderability, reduce errors, and accelerate product launches.
Top Skills:
Agent OrchestrationChatgptGoogle Apps ScriptGoogle GeminiOracle CpqOracle EbsOracle PlmPl/SqlSQL
Logistics • Transportation • Industrial
Analyzes business systems and processes, develops requirements and functional designs, translates stakeholder needs into backlog items, and supports Agile development. Responsibilities include maintaining process documentation, defining acceptance criteria, coordinating testing and defect remediation, facilitating user acceptance testing, verifying production changes, supporting demos and training, and collaborating with technical teams. Provides business analysis guidance, recommends process improvements, and mentors less experienced analysts.
Top Skills:
AgileAutomated TestingMS OfficeSdlc
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
