Business Intelligence Developer

• PRIMARY FUNCTION:

Under general supervision, is responsible for developing and maintaining business intelligence reports and visualizations predominantly using the Strategy business intelligence toolset. This includes working with analysts to understand report requirements, unit testing, verifying, debugging, and system documentation. Will perform light administrative functions as required.

• MAJOR DUTIES AND RESPONSIBILITIES:

• Hands-on development of reports and dashboards using Strategy
• Reviews requirements and design documents and identifies required solutions
• Develop a strong understanding of the source system(s) and the relationships within the data
• Support special projects, ad-hoc reporting requests, and issue resolution
• Interface closely with IT management to roll out Strategy reports and dashboards
• Develop and maintain documentation for reporting, tracking all changes
• Training and mentoring less senior members of team
• Keeps up-to-date with all current and planned functionality within the supported reporting systems.
• Assists in verification of data accuracy within dashboards and reports.
• Designs and executes test plans that are designed to find errors, ensure that the information meets requestor’s specifications, and results in a quality implementation with no negative business impact
• Helps to debug errors found in testing.
• Provides technical assistance by responding to inquiries from others regarding errors, problems, or questions about reports and programs.
• May be required to assist in project implementation teams.
• Platform Administration
• Work with cloud team as required
• Manage and migrate Object Manager packages between environments
• Monitor Log-Files (dsserrors.log, distribution services log)
• Schedule and monitor Intelligent Cube refreshes
• Troubleshoot failed IC’s and other system errors
• Upgrade planning and testing
• Library and workstation deployment and support
• License Monitoring & Management
• Set up and manage user, group, and role privileges
• Monitor and maintain status of Intelligent Cubes and element, object, and doc caches
• Conduct performance testing and troubleshooting
• Analytics Architecture
• Maintain data structure and relationships
• Maintain correct data source availability in MicroStrategy
• Develop and maintain schema objects
• Performs other duties as assigned.

• REQUIRED SKILLS/KNOWLEDGE:

• EXPERIENCE:

  Bachelor’s degree in Computer Science, Information Technology or related field is desired but not required. A minimum of two years of experience in Strategy business intelligence reporting tools and SQL is required. Experience reporting over JD Edwards E1 database preferred. Other requirements include:

  Hands-on report development experience using Strategy, versions 9.0 and higher preferred.Experience in Strategy metric, attributes, groups and cubes requiredFull understanding of the Strategy reporting platform.Advanced knowledge of relational databaseStrong SQL skillsExperience with IBM iSeries DB2 and system desired (Not required)Advanced Microsoft Excel skillsExcellent communication skills with the ability to interact effectively with analysts both in IT and business staffEffective analytical, troubleshooting and problem-solving skillsStrong verbal communication skillsFlexibility to adjust to changing requirements, schedules and priorities Ability to grasp new concepts quicklyAbility to create practical solutions that comply with IT security and functionality protocols.

• SCOPE OF DECISION-MAKING: Decisions require complex analytical judgment. Plan and perform a wide variety of duties requiring general knowledge of company policies and procedures applicable within area of responsibilities, and including their application to cases not previously covered. Requires considerable judgment to work independently toward general results, devise methods, modify or adapt standard procedures to meet different conditions, make decisions based on precedent and company policies.

• ANALYTICAL/PROBLEM-SOLVING REQUIREMENTS: Problem solving skills are required in every aspect of this position.Problems vary widely in type and complexity from simple process issues to highly complex technical and application issues. Must be able to trouble shoot production issues working with business analysts as well as other technical staffMust be able to use a variety of problem solving tools and techniques and perform root cause analysisMust demonstrate resourcefulness in resolving issues.
• MENTAL/VISUAL/MANUAL COORDINATION: Normal mental/visual attention

• JOB IMPACT: Errors may be serious, usually not subject to direct verification, and may result in significant monetary and/or customer relation loss.

• LEVEL OF SUPERVISION PROVIDED: Project direction of other employees performing the same or directly related work.
• INTERNAL/EXTERNAL CONTACTS:

• Regular inside and outside the organization: Requires regular contact with subordinates and/or other departments, with occasional contacts with individuals outside the organization. Also includes jobs with regular customer/client/vendor contacts. Contacts are primarily for the purpose of supplying or seeking information or reports. Requires tact and discretion in order to obtain cooperation. May require some persuasiveness to obtain action, consent, agreement or approval. Improper contacts outside of the organization may affect results, but primary responsibilities rest with the next level of management.