Business Intelligence (BI) Developer

FLSA Status: Exempt
Reports to: Director of IT
Employment Status: Full-time

Overview

Independent Publishers Group is looking for a talented Business Intelligence (BI) Developer to develop and maintain our data warehouse and its data sources and outputs.

Responsibilities include the maintenance and refactoring of our sales focused OLAP cube, expansion and revisions to the tables, stored procedures, views etc. behind the data warehouse, and similar responsibilities for importing data into the system via ETLs / SSIS and reporting data out in the form of XML data feeds and reports and BI dashboards facilitated via SSRS.

As the data warehouse is heavily involved in our automated accounting practices, familiarity with sales, royalties, and the general accounting domain is a major plus. The successful candidate will spend time devising further automations on the accounting side, then delegate the execution of newly coded routines to accounting and / or technical support staff as necessary

This position requires proven experiential and academic foundations in database design and databaseoriented programming languages. While many projects will include the support of a project manager, some may also require the candidate to conduct requirements gathering exercises on their own to ensure that the programming conclusively solves the business need. Interpersonal skills, communication skills, and experience in the business analyst role are required.

Responsibilities and Duties

Analyze incoming data feeds (especially sales data) and construct and maintain ETLs designed for the Data Warehouse
Refactor and maintain our sales oriented OLAP cube
Write and maintain client and internal-facing business intelligence / reporting using SSRS
Architect new and maintain existing capabilities of the data warehouse
Communicate with project managers and internal staff on project requirements and deliverables
Support and innovate on a variety of autonomous and semi-autonomous procedures employed by the accounting department, including the execution of routine monthly accounts payable tasks (how IPG pays its client publishers).
Document procedures and train support staff on the use of new and changed software
Collaborate with the IT team using agile-oriented project management tools including JIRA, Confluence, and Slack
Carry out monitoring, tuning, and database performance analysis
Ensure all data warehouse architecture codes are maintained in a version control system.
Remain current on new technologies and available vendor packages; evaluate and make recommendations as necessary.
Ensure system documentation is complete and accurate – including a backup strategy and business continuity plan.
Collaborate with IT administrators on hardware requirements and upgrades
Apply best practices and standard operating procedures.

Qualifications

Possess Bachelor’s degree in an analytical related field, including information technology, science, and engineering discipline
Three to five years’ experience performing business intelligence development
Experience with technologies such as SQL Server, Power BI, and Azure Data Factory
Exceptional experience developing SQL code, testing for quality assurance, administering RDBMS, and monitoring of database
High proficiency in dimensional modeling techniques and their applications
Strong analytical, consultative, and communication skills; as well as the ability to make good judgment and work with both technical and business personnel
Exceptional problem-solving skills with the ability to analyze existing RDBMS applications
Excited to take on challenging tasks with a small, highly motivated and talented scrum team
Reliable, self-motivated team player with positive attitude and excellent communication skills
Comfortable working as part of a distributed team
Physical abilities. Ability to sit and/or stand for long periods of time.
Travel requirements. Up to one week of travel annually.

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

About the Company

IPG is the original independent distributor of books, ebooks, and audiobooks from publishers around the world, and a top 10 supplier of book content to Amazon.com, Barnes & Noble, independent bookstores, libraries, and specialty markets, in addition to thousands of retailers globally.

Established in 1971, Independent Publishers Group (IPG) was the first organization specifically created for the purpose of marketing titles from independent presses to the book trade. IPG was acquired by Chicago Review Press in 1987. In the fall of 2006, Chicago Review Press, Inc., the parent company of IPG, bought Trafalgar Square Publishing, Inc., the leading North American distributor of UK publishers. Trafalgar Square Publishing was founded in 1973 and as a division of IPG, now distributes products from clients such as Penguin Random House UK, Australia, New Zealand, and China; Allen & Unwin; The History Press UK; Amberley Publishing; HarperCollins UK; Pan Macmillan; and John Blake. IPG acquired International Specialized Book Services (ISBS) a premier distributor of over sixty publishers of academic, scholarly and professional publishers in April of 2018. Continuing its trajectory of growth in August of 2018, IPG acquired Midpoint Trade Books, a full-service book distribution company that was founded in 1996, located in the Flatiron District of New York City, Midpoint’s distribution clients are made up of independent book publishers from across the US, the UK, Australia and Canada.

With consistent growth each year, IPG’s success has come from supporting and encouraging the growth of its client publishers in the United States and worldwide. IPG has a wide reach in the market with its distribution of publishers with academic, Spanish-language, children, and general nonfiction and fiction titles.