The Role
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.
Summary Generated by Built In
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.
Skills Required
- 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
- SQL skills for querying, combining, and validating data
- Familiarity with data preparation and transformation
- Ability to understand, troubleshoot, and improve existing code and analytical workflows
- Practical experience using AI tools for analytical or technical work
- Analytical judgment and attention to detail when investigating discrepancies
- Clear communication, collaboration, deliverable management, and documentation skills
- Two to five years of analytics experience in book publishing or comparable entertainment or content businesses
- Advanced Power BI experience, including DAX, data modeling, and report performance
- Experience with Python or another analytical scripting language
- Experience with Git, Microsoft Fabric, PBIP, PBIR, or programmatic Power BI development
- Familiarity with retailer sales and inventory data or digital advertising measurement, particularly Amazon or Target
Sourcebooks Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Sourcebooks and has not been reviewed or approved by Sourcebooks.
-
Leave & Time Off Breadth — Generous PTO, paid holidays and sick days, and a sabbatical program are highlighted, with additional closure between Christmas and New Year’s. These elements collectively indicate a wide range of time‑off options.
-
Parental & Family Support — Generous parental leave includes six weeks paid for both parents that can be combined with FMLA, alongside family medical leave. This reflects structured support for caregiving needs.
-
Healthcare Strength — Medical, dental, and vision coverage are provided along with life insurance, short‑ and long‑term disability, FSAs, and mental‑health benefits. The package spans core health protections and ancillary supports.
Sourcebooks Insights
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
“Sourcebooks, a legitimate contender for the title of ‘most innovative company in book publishing.’”—Mike Shatzkin, Idealog Innovators. Always looking for ways to bring new experiences to our readers, data is the backbone that gives direction to our creativity and informs our innovative spirit. Put Me In The Story, now the #1 personalized book platform in the U.S., is one of three e-commerce businesses we operate. We are committed to innovative publishing and to exploring new publishing platforms and models. Owners and Entrepreneurs. We take pride in being pioneers. Each of us is a leader invested in creating breakthrough for ourselves, our company, and readers everywhere. Starting with just one book in 1987, we now publish more than 300 new titles each year. With millions of books sold and more than 80 New York Times and USA Today bestsellers—and more—Sourcebooks publishes authors, not books. Constantly Learning. Not content to rely on yesterday’s knowledge, we know tomorrow’s opportunities can be discovered only with a passionate desire to explore new ideas. We Create Amazing. Every book and product we create and every life we touch is an opportunity to deliver the unexpected and the extraordinary. Our award-winning books earn accolades from Parenting Media Awards, YALSA Lists, Texas Bluebonnet, state awards, the Society of Illustrators Gold Medal Award, and more. Book Business Magazine named Sourcebooks 2013 Publishing Innovator of the Year. From children’s, young adult, fiction, and memoir to personalized books, inspirational gifts, reference, poetry, and beyond, we believe books change lives. It is the heart of all that we do. We are excited to work with passionate authors, booksellers, librarians, designers, media, brand partners, and others to create a vibrant future for books. FIND US ONLINE www.sourcebooks.com www.putmeinthestory.com www.simpletruths.com www.123magic.com
