Job Openings

AR Specialist - Temporary

FLSA Status: Non-Exempt
Reports to: Chief Financial Officer

Job Summary

IPG is currently seeking a temporary Accounts Receivable Specialist for a three month project. The AR Specialist is responsible for maintaining and reconciling customer accounts as well as ensuring prompt payment from our customers. This position requires great attention to detail, organizational skills, and outstanding customer service skills. It is our duty to provide our customers with the best service possible while keeping our cash flow current. This position does not provide health benefits due to the temporary status.

Primary Responsibilities

  • Process customer payments
  • Reconcile customer accounts
  • Generate daily payment summary report
  • Print monthly customers statements
  • Prioritize and handle customer collection calls
  • Maintain records and process payments for Foreign Rights, Subrights, and Book Club Sales
  • Maintain royalty advances and lifetime earnings schedule
  • Manage bi-annual royalty payment process

Requirements

  • Bachelor’s degree in business administration, accounting, or finance preferred (will substitute degree with 6 years of progressive accounting experience)
  • Advanced Excel skills
  • Strong computer skills
  • Strong interpersonal skills
  • Outstanding communications skills
  • Strong analytical and problem solving skills
  • Good organizational skills

Please reference the job title in the subject line when submitting your cover letter and resume to Jessie Jonik at jjonik@ipgbook.com.

 

IT Support Specialist

FLSA Status: Non-Exempt
Reports to: Senior SQL Server Developer

Job Summary

Responsible for providing technical assistance and support related to computer systems, hardware, or software. Responds to queries, runs diagnostic programs, isolates problem, and determines and implements solution.

Primary Responsibilities

  • Provide technical assistance and support for incoming queries and issues related to computer systems, software, and hardware.
  • Respond to queries either in person or over the phone.
  • Write training manuals.
  • Train computer users.
  • Maintain daily performance of computer systems.
  • Respond to email messages for customers seeking help.
  • Ask questions to determine nature of problem.
  • Walk customer through problem-solving process.
  • Install, modify, and repair computer hardware and software.
  • Clean up computers.
  • Run diagnostic programs to resolve problems.
  • Resolve technical problems with Local Area Networks (LAN), Wide Area Networks (WAN), and other systems.
  • Install computer peripherals for users.
  • Follow up with customers to ensure issue has been resolved.
  • Gain feedback from customers about computer usage.
  • Run reports to determine malfunctions that continue to occur.

Requirements

  • Bachelor's degree in an IT related field or four years of related experience
  • 1 year of help desk experience supporting a small to mid-size company
  • Ability to work one Saturday per month at our location on Pulaski in Chicago
  • Strong analytical and problem solving skills

Please reference the job title in the subject line when submitting your cover letter and resume to Jessie Jonik at jjonik@ipgbook.com.

 

Senior SQL Server Developer

FLSA Status: Exempt
Reports to: Chief Technology Officer

Job Summary

Independent Publishers Group (IPG) is the second largest distributor of books and e-books in the world, and one of the top 10 suppliers of book content to Barnes & Noble, Apple, Amazon.com, and Kobo, among thousands of other retailers globally. Want to know who’s behind that new book on your coffee table? Chances are good that your bookstore sourced it from IPG.

The successful candidate will join a multinational team of analysts, developers, software testers, platform engineers, and IT support specialists as they work on the next iteration of cutting-edge, publisher-focused software and systems.

This position centers around the development and maintenance of 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 database-oriented 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.

Job 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

Job Requirements

  • Bachelor's degree in computer science or related technical field
  • Minimum four years work experience in a SQL Developer or related role
  • Product or system certifications desirable, especially MS SQL certifications
  • Analysis and optimization of complex SQL statements; use of profiling tools
  • Specification, design, operation and troubleshooting of SSRS reports
  • Specification, design, operation and troubleshooting of SSIS packages
  • Specification, design, operation and troubleshooting of OLAP cubes
  • Familiarity with Microsoft and other database tools; Visual Studio and BIDS
  • Common configuration and maintenance tasks for SQL databases; backup, upgrade, migration
  • XML document structure and design. Creating and applying XML transforms with XSLT
  • PowerShell scripting for automation, configuration and management.
  • Understanding of object oriented programming; C#, Ruby on Rails, Visual Basic
  • Familiarity with Amazon Web Services including EC2 server instances, S3 storage, Storage Gateway, Simple Email Service, Identity and Access Management
  • Active Directory concepts and management tools. Working knowledge of VMware and Hyper-V virtualization architecture.
  • Experienced in and comfortable with requirements gathering and analysis role
  • Experience with Microsoft Dynamics and Great Plains interfaces a plus

Please reference the job title in the subject line when submitting your cover letter and resume to Jessie Jonik at jjonik@ipgbook.com.

 


 

Internship Program

IPG is always looking for qualified applicants for full-time internships which run for a minimum of six (6) months. Qualified candidates are recent college graduates who possess strong written and verbal skills, the ability to multi-task, and a passion for the publishing industry. Other preferred experience includes some sales experience, fluency in Word, Excel, and other Microsoft Office programs, and some knowledge of HTML and CSS. Experience in the book industry and a degree in a related field is a plus. The hours of work are Monday through Friday from 9 a.m. to 5 p.m. The hourly stipend is currently $10.50 per hour. Please send résumés, cover letters, and two writing samples via e-mail to Jessie Jonik. No phone calls, please.