Cognos Administrator

Job Locations US-TX-Arlington
Requisition ID
2018-30976
Employee Type
Full Time-Regular
Category
Information Technology

Overview

The Business Intelligence (BI) Systems Analyst III is responsible for the administration, configuration, developer support, and on-going support including on-call of the reporting and analytical solutions for the business community.  The BI Systems Analyst III is responsible for the internal customer (content developers) facing activities of defining business requirements, proposing solutions, and validating that these solutions meet the needs of the business. The Business Intelligence (BI) Systems Analyst must have strong technical, analytical and problem-solving skills. The team member will have exposure to tool administration, data mapping, coding, ETL, metadata and report development. The job entails working with all aspects of Data Warehouse administration, business units and enabling groups.  This team member must maintain relationships with the super-users (content developers) to understand and deliver their reporting requirements, and ensure that they are trained to use the applications in a way that will meet those requirements.

Responsibilities

JOB DUTIES:

 

  • Administer the GM Financial BI Application systems. Ensure production environment stability and level of performance. Resolve production issues in a timely manner.
  • Provide on-call support as needed. Work with internal and external resources.
  • Assist with BI system implementations and upgrades, license management, security, auditing, and future/additional product evaluation for the BI applications as needed.
  • Communicate production issues (describing issue, resolutions, and status) with both the business and the BI team in a timely manner.
  • Create and maintain documentation for project plans, project status reports, timelines, project issues and risks, change requests, requirements, design, testing plans and test cases as needed for projects assigned.
  • Provide AVP Business Intelligence and DW Solutions and team with regular and timely status reports and benchmarking metrics for projects, issues, system implementations and upgrades.
  • Cross-train with, and serve in backup administrator role for other BI Applications team members. Coordinate with backup team members and IT monitoring departments in order to provide occasional after hours system support.
  • Proactively develop, coordinate, and provide on-going training, functional, and technical direction to the super-users (content developers).
  • Define and establish application best practices, required standards, and guidelines regarding the use of, and administration of, the BI tools. Standardize the development process for the content developers. Document processes and standards and regularly provide documentation to content developers and BI team.
  • Research functionality and technical configuration within the BI systems supported by the BI Applications group and prepare recommendations for system improvements whenever possible.
  • Monitor and administer data extractions from the Data Warehouse to ensure availability and accuracy. Develop and document new data loads as needed. Develop and maintain a working relationship with various support teams to leverage data access and transfer using the BI applications.      
  • Maintain and monitor production, development, test, and disaster recovery environments.
  • Provide assistance to Server Support when needed.
  • Create and develop content as needed to support the super-users (content developers) and demonstrate system functionality.
  • Acquires and maintains in-depth knowledge of all BI systems or applications used.
  • Frequently interact with business customers and functional peer groups.

 

 OTHER IMPORTANT DUTIES:

  • Makes wise decisions regarding prioritization of work assignments.
  • Develop and document effective new and existing operational procedures for BI infrastructure, BI Architecture, and business system requirements (as well as recommendations and proposals).
  • Be aware of, and assist with, cross-training needs in the BI group.
  • Ability to write technical and business documents as well as deliver oral presentations.
  • Provides business and application consultation for project and support teams.
  • Performs other duties as assigned.

REPORTING RELATIONSHIP:

Reports to: AVP Business Intelligence and DW Solutions

Direct reports: none

Qualifications

Knowledge

 

  • Must be proficient in the use of computer functions and Microsoft applications.
  • Minimum of 5 years working knowledge of report development, data models, and administration processes in an enterprise BI reporting tool.
  • Minimum of 5 years working knowledge of database software (Oracle, SQL server, Informatica, Microsoft SSIS, Rapid SQL, etc.) and stored procedures.
  • Must understand relational and OLAP database designs.

 

Skills

 

  • Solid SQL writing skills required.
  • Proficient in system administration or development experience with BI/OLAP applications.
  • Hands on experience designing, developing, and administering BI applications.
  • Excellent customer service skills a must.
  • Ability to manage large projects (i.e. upgrades) and perform necessary communication and coordination to management, end users and developer community.
  • Ability to use appropriate analysis, judgment, and logic when solving problems and making decisions.
  • Ability to plan, execute, and improve work processes to ensure achievement of business objectives.
  • Strong active listening, written and verbal communication skills. Able to present to all levels of the organization and tailor message appropriately for the audience.
  • Ability to understand GM Financial's business, apply knowledge, and critical thinking skills in day-to-day problems and solutions.
  • Ability to create and maintain a well-structured environment through development of standards and procedures.
  • Must be highly organized and detail-oriented.
  • Strong problem-solving skills, troubleshooting, and root cause analysis.
  • Ability to write technical and business documents.
  • Ability to train users on BI applications.
  • Ability to balance multiple efforts and complete deliverables on time.

 

Experience

 

  • CS or MIS Bachelor's degree or equivalent work experience required.
  • Minimum 5 years of experience with system administration or development experience with BI/OLAP applications.
  • Experience using RDBMS such MS SQL Server or Oracle.
  • Experience in dealing with multiple business units, technical personnel, and diverse employee population.      
  • IT experience should include maintenance and support activities of performance monitoring and tuning, upgrading versions, software configuration, Business Continuity and Disaster Recovery planning, and general IT processes such as Change Management, Configuration Management, Problem Resolution, and Incident Tracking.
  • Financial Services experience a plus.

 

WORK CONDITION:

Normal office environment. Occasional extended working hours may be required.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Need help finding the right job?

We can recommend jobs specifically for you! Click here to get started.