Fast Facts

Join Macmillan Publishers as a Senior BI Developer, where you'll lead the transition from Cognos to Power BI while modernizing the data platform to enhance analytics capabilities across the organization.

Responsibilities: Key responsibilities include collaborating with teams to optimize Power BI solutions, architecting reporting frameworks, maintaining semantic data models, and ensuring data quality and security standards are upheld.

Skills: Candidates must have extensive experience with Power BI, data modeling, SQL, and collaboration skills across various business functions.

Qualifications: Preferred qualifications include proficiency in Microsoft Fabric, experience with production pipelines for data refreshes, and familiarity with agile project management.

Location: The position is located in New York, New York, United States, with no specified travel requirements.

Compensation: $139000 - $150000 / Annually

We are seeking a Senior BI Developer to join our Central Analytics team and play a key role in transitioning from a legacy Cognos business intelligence (BI) platform to Power BI for reporting and self-service analytics across the organization. We are currently modernizing our data platform from an on-premise Oracle data warehouse to a dbt/Snowflake cloud solution. The candidate will leverage this new data warehouse to service analysts across the company and by working with our Data Analytics team to help identify data model and other Snowflake changes required to optimize Power BI solutions. This role will orchestrate the transition to the new BI toolset and possess a deep technical understanding of Power BI Pro, Premium, semantic models, DAX, query methods, and tools in the Microsoft Fabric space, including DataFlows, Pipelines, and the DirectLake query method.

The Senior BI Developer will drive technical decisions with our Data Platform team and IT regarding Power BI configuration and administration, including workspaces, security, and portal architecture. They will also assist in driving innovation of our self-service deployment strategy, empowering and enhancing the user experience for our community of over 1,000 users. 

What you'll do:

• Collaborate with analysts, Data Engineers, and users to transform data into actionable information and drive our self-service strategy using Power BI. 
• Translate business requirements into design specifications and architect reporting solutions. 
• Optimize the performance of BI solutions, including data modeling, system architecture, and report refresh efficiency. 
• Build and maintain complex semantic data models in Power BI/Microsoft Fabric.
• Collaborate with the Data Analytics and Data Platform teams to ensure high data quality, availability, and freshness. 
• Guide the configuration and design of security roles and workspaces to ensure proper access control and security. 
• Establish best practices and designs to support semantic models for both BI team and self-service reporting, including optimal data loading and refresh strategies.
• Set up monitoring tools to track performance, lineage, usage, and issues within the Power Platform environment. 
• Conduct code reviews and mentor teammates, analysts, and users. 
• Stay current on Power BI features, updates, and industry best practices.

What you'll bring:

• Extensive experience building and maintaining global data reporting environments for a large user deployment. 
• Proven ability to develop and maintain production semantic models. 
• Experience managing production pipelines and logic apps for data refreshes and self-serve reporting. 
• Strong collaboration skills with various business areas (C-Suite, Finance, PubOps, Sales, Data Analytics, Data Science). 
• Experience with agile project environments, ceremonies, and meetings. 
• Experience with performance testing on Power BI production reporting. 
• Proficient in writing and analyzing SQL for both reporting and troubleshooting data issues. 
• Experience working with a broad range of technology department roles and collaborating with various business teams. 
• Technical Skills: Power BI, Fabric, Tabular Editor, DAX Studio, Microsoft Excel, Python (preferred). 
• Experience with both internal and external publishing industry data is a plus.

This role will have an annual salary of$139,000-$150,000.

Macmillan Publishers is the U.S. trade company that is part of the Holtzbrinck Publishing Group, a large family-owned group of media companies headquartered in Stuttgart, Germany. Holtzbrinck Publishing Group's publishing companies include prominent imprints around the world that publish a broad range of award-winning books for children and adults in all categories and formats.

U.S. publishers include Celadon Books, Farrar, Straus and Giroux, Flatiron Books, Henry Holt & Company, Macmillan Audio, Macmillan Children’s Publishing Group, The St. Martin's Publishing Group, and Tor Publishing Group. In the UK, Australia, India, and South Africa, companies in the Holtzbrinck Publishing Group publish under the Pan Macmillan name. The German publishing company, Holtzbrinck Deutsche Buchverlage, includes among its imprints S. Fischer, Kiepenheuer & Witsch, Rowohlt, and Droemer Knaur.

We are an Equal Opportunity Employer. We are actively seeking job applicants who reflect a broad representation of differences, including race, ethnicity, religion, sex, sexual orientation, gender identity/expression, physical ability, neurodiversity, age, family status, economic background and status, geographical background and status, and perspective. We believe that the best companies reflect the incredible diversity in viewpoints, backgrounds, and identities of the world in their staffs, and are committed to inclusive hiring across departments and levels. The successful candidate for this position will be an employee of Macmillan Publishing Group, LLC.