Job description

About the Company:

IPS Corporation is a global, market-leading provider of solvent cements, adhesives and specialized plumbing products for a broad range of construction, industrial, and manufacturing applications. Established in 1954 as the original inventor of solvent cement for PVC pipe applications, IPS has grown dramatically over the past 70+ years. Today with its three operating companies, WeldOn, IPS Adhesives and Diversified Products, we have 13 manufacturing plants and 20 distribution centers supporting sales to a diverse set of end markets in 85 countries.

Our leading brands include AB&A®, Arjay™, Christy’s™, Floodstop™, Guy Gray®, Integra®, Roof Top Blox™, SciGrip®, Studor®, Test-Tite®, Tough Pans™, TruBro®, Water-Tite®, and Weld-On®

.
About the Ro

leIn this remote Eastern Standard Time (EST) based role, the Business Intelligence (BI) Programming Analyst will work closely with cross-functional business teams to design and develop BI and Analytics capabilities including ad-hoc reports, dashboards, and scorecards. You’ll need to have experience in Cognos Framework Manager, Cognos Report Studio and Cognos Analysis Studios in order to effectively support stakeholder

s.
In addition to troubleshooting support, you’ll focus on monitoring and supporting the daily operations of the Cognos infrastructure for the company. Having Cognos Analytics experience is required in this role. Although travel is minimal, there will be approximately 10% travel in this role reporting to the Director, IT Applications Support and Developme

nt.
Key Responsibili

ties
Work collaboratively with Finance, Distribution, Manufacturing, Commercial and other business functions, and business analysts to gather requirements and design business operational reports in support of various applications and business
areasAuthor complex reports and dashboards utilizing IBM Cognos 10\11 studios and other reporting solu
tionsServe as a technical resource supporting all business intelligence, data warehouse, ETL and reporting activities and
toolsDrive relational and dimensional modeling best prac
ticesCoordinate BI initiatives between business users and the IT
groupExpand & enhance data and analytic capabilities, continue to improve processes, explore/adopt new tools, drive automation and scri
ptingLead and participate in medium to large projects and confirm that the application/reporting requirements are established and in operation within the project schedule and b
udgetFollow all prescribed software development life cycle and project management processes and procedures. Provide solutions for process improvement of IT processes and proce
duresCollaborate with other IT team members on the integration of all systems and reporting

tools
Required Expe

rience3+ years of experience delivering BI solutions and reports with Cognos Analysis Studios, Cognos Report Studio and Cognos Framework M
anagerExperience with data warehousing/database concepts and knowledge of relational and OLAP concepts and methodo
logiesWorking knowledge of other ETL related languages or tools (SSIS pref
erred)Expertise with SQL (structured query lan
guage)Strong oral and written communications
skillsAbility to develop and communicate training packages for knowledge tr

ansfer
Preferred Exp

erience3+ years experience with database management (SQL Server pre
ferred)Working knowledge of JD Edwards Enterprise One ERP pr
eferredExperience with OneStream, and/or Insight

Hubble
O

ur OfferWe're a rapidly growing midsized company with a customer-centric mentality operating fast and lean. We think big, embrace problem solving, and believe our proven business system gives us a competitive edge in the markets we play. Through experience in this role, mentoring and via formal instruction, we will grow your career and develop you based off your strengths and in

terests.
A career with IPS Corporation will push you and challenge you, providing growth opportunities and the prospects to advance your career. If you are a driven performer, you will work with committed, like-minded people, giving you the support to reach your full p