Hyperion EPM Software Development Specialist
The Pentagon, DC
Full Time
Mid Level
Company Overview:
Macalogic is a company with broad competencies focused on bringing practical technology solutions to complex problems. We are an SBA-certified Woman-Owned Small Business (WOSB) and an Economically Disadvantaged Woman-Owned Small Business (EDWOSB). We provide business consulting services to government clients in four primary areas: software development and IT-related consulting; program support; federal enterprise architecture; and compliance. In the commercial, Business-to-Business (B2B) arena, we provide management support services, including hardware, software, and network installation, troubleshooting, and management.
Our core values of Respect, Accountability, Collaboration, and Excellence are central to everything we do at Macalogic. As such, we are always open to self-motivated and responsible team players who are focused on contributing to the success of our clients. We offer a generous benefits package and compensation commensurate with your experience and skill set.
General Description
The successful candidate will perform as a Software Development Specialist for the Hyperion Financial Reporting component of Oracle’s Enterprise Performance Management (EPM) application. The candidate will provide support to the Air Force’s Program and Budget Enterprise System (PBES), providing development, operational, and sustainment support which ensures that the system is fully functional and available. The successful candidate will perform software development in support of Oracle’s Hyperion Financial Management and Reporting/EPM software solution, and associated business intelligence solutions using Oracle’s OBIEE data warehouse. In addition, the candidate will be required to periodically support the PBES Sustainment Help Desk, providing support to production users as part of day-to-day program execution. In addition, the candidate will support the stand-up and sustainment of the PBES Development and Test environments in AWS. Other activities will include providing functionality updates, performing data refreshes, and performing document development. Responsibilities further include performing data analysis and evaluation, developing data update strategies, performing data cleansing activities, and performing data extraction in support of new report development.
Duties and responsibilities
The successful candidate will participate in the development and sustainment of the PBES solution, including manipulating/validating input data so that data can be loaded into the Hyperion portion of EPM using Hyperion tools and techniques, creating new scripts and PL/SQL routines, troubleshooting data commitment and extraction issues, and both supporting existing reporting requirements and supporting the creation of new reports. They will also evaluate, using root cause analysis, issues associated with data quality and work with management to develop and implement data quality strategies to support organizational requirements; consult with and advise users on access to various databases and datasets in support of report development; work directly with users to resolve data quality issues and inappropriate data usage; provide second-tier support to end-users through participation in the PBES Sustainment Help Desk; and handle problems that the first tier of help desk support is unable to resolve.
Specialized Knowledge
Education
Bachelor’s Degree in computer science, management information systems, or related field.
Professional Certifications
An active CompTIA Security+ certification is required.
Clearance
An active U.S. Secret Security Clearance or the ability to obtain said clearance is required.
Experience
A minimum of 2 to 5 years of Hyperion development experience, data migration strategy development and execution, and data cleansing.
U.S. Citizen or Similar
Must be a U.S. Citizen
Skills and Abilities
Experience with the development of Oracle EPM products, with a specific focus on Hyperion and data management techniques.
Other Characteristics (e.g., Personal or Language)
Must be a self-starter with the ability to manage work efforts with minimal leadership oversight. Must also have excellent time-management skills as well as excellent oral, written, and communication skills. Must be able to work in a team environment with members that include personnel from other companies, Government program management and administrative personnel, and technical staff members.
Working conditions, including location
This position REQUIRES a combination of remote work plus one to two days per week working at the Pentagon, Washington DC supporting the Sustainment Help Desk.
Client duty hours are Monday through Friday.
Macalogic is a company with broad competencies focused on bringing practical technology solutions to complex problems. We are an SBA-certified Woman-Owned Small Business (WOSB) and an Economically Disadvantaged Woman-Owned Small Business (EDWOSB). We provide business consulting services to government clients in four primary areas: software development and IT-related consulting; program support; federal enterprise architecture; and compliance. In the commercial, Business-to-Business (B2B) arena, we provide management support services, including hardware, software, and network installation, troubleshooting, and management.
Our core values of Respect, Accountability, Collaboration, and Excellence are central to everything we do at Macalogic. As such, we are always open to self-motivated and responsible team players who are focused on contributing to the success of our clients. We offer a generous benefits package and compensation commensurate with your experience and skill set.
General Description
The successful candidate will perform as a Software Development Specialist for the Hyperion Financial Reporting component of Oracle’s Enterprise Performance Management (EPM) application. The candidate will provide support to the Air Force’s Program and Budget Enterprise System (PBES), providing development, operational, and sustainment support which ensures that the system is fully functional and available. The successful candidate will perform software development in support of Oracle’s Hyperion Financial Management and Reporting/EPM software solution, and associated business intelligence solutions using Oracle’s OBIEE data warehouse. In addition, the candidate will be required to periodically support the PBES Sustainment Help Desk, providing support to production users as part of day-to-day program execution. In addition, the candidate will support the stand-up and sustainment of the PBES Development and Test environments in AWS. Other activities will include providing functionality updates, performing data refreshes, and performing document development. Responsibilities further include performing data analysis and evaluation, developing data update strategies, performing data cleansing activities, and performing data extraction in support of new report development.
Duties and responsibilities
The successful candidate will participate in the development and sustainment of the PBES solution, including manipulating/validating input data so that data can be loaded into the Hyperion portion of EPM using Hyperion tools and techniques, creating new scripts and PL/SQL routines, troubleshooting data commitment and extraction issues, and both supporting existing reporting requirements and supporting the creation of new reports. They will also evaluate, using root cause analysis, issues associated with data quality and work with management to develop and implement data quality strategies to support organizational requirements; consult with and advise users on access to various databases and datasets in support of report development; work directly with users to resolve data quality issues and inappropriate data usage; provide second-tier support to end-users through participation in the PBES Sustainment Help Desk; and handle problems that the first tier of help desk support is unable to resolve.
Specialized Knowledge
- Perform as a Hyperion software development specialist.
- Diagnose and resolve input data load issues from external systems when they arise.
- Develop data access scripts and PL/SQL routines supporting existing or new reports.
- Execute tasks from design through code development; software build; unit, system, and integration test.
- Use available static code analyzing tools to evaluate existing and new application code and address deficiencies uncovered.
- Must have a strong background in agile-based software development.
- Provide service desk support for the Sustainment Help Desk.
- Assist in test setup and changes required because of testing.
Education
Bachelor’s Degree in computer science, management information systems, or related field.
Professional Certifications
An active CompTIA Security+ certification is required.
Clearance
An active U.S. Secret Security Clearance or the ability to obtain said clearance is required.
Experience
A minimum of 2 to 5 years of Hyperion development experience, data migration strategy development and execution, and data cleansing.
U.S. Citizen or Similar
Must be a U.S. Citizen
Skills and Abilities
Experience with the development of Oracle EPM products, with a specific focus on Hyperion and data management techniques.
Other Characteristics (e.g., Personal or Language)
Must be a self-starter with the ability to manage work efforts with minimal leadership oversight. Must also have excellent time-management skills as well as excellent oral, written, and communication skills. Must be able to work in a team environment with members that include personnel from other companies, Government program management and administrative personnel, and technical staff members.
Working conditions, including location
This position REQUIRES a combination of remote work plus one to two days per week working at the Pentagon, Washington DC supporting the Sustainment Help Desk.
Client duty hours are Monday through Friday.
Apply for this position
Required*