Business Intelligence Developer, Power BI, IT, Penguin Random House (Open to Remote)

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 PRHs 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 childrens literature fromDragons Love TacostoThe Phantom Tollbooth; best-in-class storytellers including Margaret Atwood Tommy Orange Celeste Ng and Jasmine Guillory; and culture-shaping works such asBecomingby Michelle Obama andDaisy Jones & the Sixby 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 newand enhance existingPower 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 )
  • 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 (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 $100000 and $115000. 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 candidates 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 childrens publishing house in North America the United Kingdom and many other regions around the 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 Childrens Books Riverhead Ten Speed Press Viking and Vintage among others. More information can be found at 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