Penguin Random House seeks a highly skilled and detail-oriented Developer to join our team.

We are seeking a Power BI Semantic Modeler and Developer to join our IT Business Intelligence team. This role will work in close collaboration with cross-functional departments including Finance, Sales, and Operations, to design, build, and optimize scalable data models and reporting solutions.

As part of PRH’s digital transformation efforts, you will play a critical role in advancing our data-driven decision-making capabilities, ensuring our stakeholders have accurate, well-modeled, and accessible insights through Power BI and Azure data services.

Penguin Random House is home to genre-defining children’s literature, from Dragons Love Tacos to The Phantom Tollbooth; best-in-class storytellers including Margaret Atwood, Tommy Orange, Celeste Ng, and Jasmine Guillory; and culture-shaping works such as Becoming by Michelle Obama and Daisy Jones & the Six by Taylor Jenkins Reid.

The Business Intelligence Developer will work closely with Power BI and the Azure platform. The developer will be responsible for the development & creation of Power BI reports & applications, as well as creating new & enhancing existing Azure Tabular models.

The Business Intelligence Developer will be responsible for designing, developing, and maintaining the Power BI semantic layer (including tabular data models and data marts), as well as developing enterprise-grade Power BI dashboards and reports. The ideal candidate will have technical experience in Power BI, Azure Analysis Services, and SQL-based data engineering, along with the ability to translate complex data requirements into meaningful, performant, and maintainable BI solutions.

Specific responsibilities include:

• Design, develop, and optimize Power BI semantic models (tabular models and datasets) supporting enterprise reporting.
• Build new and enhance existing Power BI applications and reports for internal business units.
• Create and enhance Azure Analysis Services (AAS) and Azure SQL models used by Power BI.
• Develop and maintain views, stored procedures, and ETL logic to support efficient data retrieval.
• Partner with business stakeholders to refine data requirements and ensure alignment between reporting outputs and business needs.
• Ensure data model performance, scalability, and security within the Power BI and Azure ecosystems.
• Collaborate with IT peers to align BI solutions with enterprise architecture and data governance standards.
• Contribute to best practices documentation and the continuous improvement of BI development processes.       
• Build new and enhance existing Power BI applications & reports
• Responsible for creating & enhancing Azure Analysis Services Tabular Models, used by Power BI
• Communicate with business stakeholders and refine product requirements
• Responsible for creating views and stored procedures to support applications

Please apply if you meet the following qualifications:

• A minimum of 2 years of experience with:
  • Working with Microsoft Power BI (Desktop and PowerBI.com)
  • Developing and managing data models or solutions within cloud-based platforms such as Microsoft Azure or Fabric
• A minimum of 1 year of experience with:
  • Working with Microsoft SQL Server to build views, stored procedures, and complex queries
  • Integrating Power BI with SSAS tabular cubes and Direct Queries to databases
  • Understanding Tabular Cube development and model optimization techniques
  • Working within an Agile development framework to deliver iterative BI solutions
• Creating content with Power BI Desktop and PowerBI.com (dashboards, reports, datasets, and workspaces).
• Designing and maintaining semantic models using Power BI and Azure Analysis Services.
• Implementing row-level security, DAX measures, and data modeling best practices.
• Developing interactive visualizations and data-driven stories in Power BI.
• General skills to succeed:
  • A collaborative mindset that remains solutions-focused when problem-solving
  • Excellent written and verbal communication skills
  • Strong organizational skills and detail-oriented
  • Ability to prioritize and multitask
  • Ability to work well independently and as part of a team

The salary range for this position is $100,000 and $115,000.  All positions are currently eligible for annual profit award or bonus, subject to Company results.

Please apply using our ATS system by December 4, 2025, and include your resume and cover letter for consideration. Before applying for any role at Penguin Random House, we recommend you review our applicant resources page and look over our hybrid and open-to-remote guidelines on our FAQs page.

Penguin Random House job postings include a good faith compensation range for each open position. The salary range listed is specific to each particular open position and takes into account various factors including the specifics of the individual role, and candidate's relevant experience and qualifications.

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, Pre-Tax and Roth 401(k), Short and Long-Term Disability Insurance, Life/AD&D Insurance, Commuter Benefits, Student Loan Repayment Program, Educational Assistance & generous paid time off.

Penguin Random House is the leading adult and children's publishing house in North America, the United Kingdom and many other regions around the world. In publishing the best books in every genre and subject for all ages, we are committed to quality, excellence in execution, and innovation throughout the entire publishing process: editorial, design, marketing, publicity, sales, production, and distribution. Our vibrant and diverse international community of nearly 300 publishing brands and imprints include Ballantine Bantam Dell, Berkley, Clarkson Potter, Crown, DK, Doubleday, Dutton, Grosset & Dunlap, Little Golden Books, Knopf, Modern Library, Pantheon, Penguin Books, Penguin Press, Penguin Random House Audio, Penguin Young Readers, Portfolio, Puffin, Putnam, Random House, Random House Children's Books, Riverhead, Ten Speed Press, Viking, and Vintage, among others. More information can be found at http://www.penguinrandomhouse.com/.<http://www.penguinrandomhouse.com/>

Penguin Random House 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.

Company: Penguin Random House LLC 

Country: United States of America 

State/Region: New York 

City: New York 

Postal Code: 10019 

Job ID: 283421