CDW Lead Business Systems Administrator - Oracle Hyperion in Vernon Hills, Illinois


The Lead Business Systems Administrator is responsible for ensuring production environment availability, stability and performance of 3rd party software applications and servers (such as Hyperion, Cognos, Tableau, other similar platforms). This role serves as the IT point person, system advocate, and subject matter expert for such applications and provides day-to-day close support to internal business partners. In addition, provides team with technical guidance and day-to-day task assignments.

Key Areas of Responsibility

  • Provide in depth leadership in the analysis and resolution of business needs related to packaged software

  • Ensure production environment availability, stability and performance through proactive monitoring, configuration and tuning

  • Serve as the IT point person, system advocate and SME for 3rd party software applications with a strong customer-service oriented disposition toward internal business partners

  • Establish and maintain a strong, close working relationship with functional area counterparts, users, internal IT, external consultants, and product vendors

  • Perform software installations, system configurations, migrations, maintenance, upgrades, patches/fixes of 3rd party package software

  • Troubleshoot software, hardware and infrastructure issues; marshal all necessary resources (developers, infrastructure team, Help Desk, coworkers, etc.) and collaborate to resolve including escalation with vendor

  • Partner with management to plan and coordinate IT activities with all users/stakeholders

  • Provide regular status and report on issues that arise to management

  • Communicate with all stakeholders when problems exist and follow-up once resolved

  • Create and maintain system documentation; train other administrators

  • Develop and promote standard operating procedures, best practices, governance

  • Establish and perform backup/disaster recovery procedures

  • Assist and advise management with setting vision and strategy

  • In pursuit of all the above, provides team with technical guidance and day-to-day task assignments


  • In alignment with business needs, design and manage system security plans and procedures; maintain user groups, roles, rights/permissions; perform security audits

  • Perform technical infrastructure/hardware requirements gathering, sizing, installation, testing with the IT systems engineering/networking groups

  • Remain current on the latest software releases/release notes in anticipation of future business needs and/or to improve productivity and departmental capabilities

  • Keep abreast of related technologies, methodologies, best practices and provide recommendations for adoption/implementation

  • Proactively identify opportunities for improvement and take necessary actions to implement

  • Evaluate packaged software products and upgrades to existing products

  • Analyze and resolve business needs related to packaged software

  • Assist manager with strategy, vision, planning, building of the administration team

  • Mentor and coach junior team members

  • Work evening and weekend hours when necessary for installations, implementations, and upgrades

  • Login capability from home to respond to any system-related problem(s)

  • Carry a company-issued smart phone and respond to critical business issues in a timely manner


Minimum Qualifications

  • Bachelor’s Degree

  • 10 years information technology experience

Other Required Qualifications

  • Expert knowledge of 3rd party packaged software

  • In depth expert knowledge of PC hardware and software

  • Experience of networking and connectivity as it relates to hardware and software

  • Demonstrated experience in teaching and/or mentoring professionals

  • Demonstrated outstanding verbal and written communication skills with the ability to effectively interact with all stakeholders including senior leadership

  • Ability to work effectively with, and support the needs of, administration team members. Ability to work effectively with other IT teams. Ability to effectively present information, interact with, and respond to questions from managers and vendors.

  • Demonstrate mastery in leading and managing implementation and upgrade projects

  • Demonstrate creative problem solving skills

  • Possess intimate working knowledge of mission-critical business functions (particularly finance) and a successful history of facilitation and solutions implementation

  • History of balancing competing priorities with the ability to adapt to the changing needs of the business while meeting deadlines

  • Flexibility to work off hours and weekends as business needs dictate

  • Demonstrated process documentation ability

  • Proactive mindset focused on continuous improvement

  • Customer-service oriented disposition

  • Willingness/interest in expanded role to multiple enterprise applications

Other Preferred Qualifications:

  • Masters Degree in relevant field

  • Oracle Hyperion Performance Management solutions:

  • Strong working knowledge from a technical (non-functional)/administrative perspective of Oracle Hyperion Enterprise Performance Management solutions including Planning, Essbase, Profitability and Cost Management (HPCM), Financial Data Management (FDMEE), Financial Reporting, Smartview, etc. and the ability quickly learn and master others

  • Experience with Essbase calc scripts, load rules, business rules, report scripts

  • Strong knowledge of SQL, MDX/MAXL, SSIS

  • Experience developing and running data extraction, transformation, load jobs using Hyperion as both source and target

  • Familiarity with financial functional area (especially FP&A)

  • Administration experience with Hyperion, Cognos, Tableau, other similar platforms

Lead Business Systems Administrator - Oracle Hyperion

Vernon Hills, IL