Sr. Cognos Administrator

GM Financial Arlington , TX 76004

Posted 2 months ago

Overview

The Sr. Business Intelligence (BI) Systems Analyst acts as a lead team member in the Business Intelligence group and is responsible for the administration, configuration, developer support, and on-going support of the reporting and analytical solutions for the business community. The Sr. BI Systems Analyst (Sr. BISA) is responsible for internal customer facing activities of defining business requirements, proposing development solutions, and validating that these solutions meet the needs of the business. The Sr. BISA 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 reporting 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

  • Administrate the BI applications. Provide a stable production environment that meets performance needs and make adjustments as needed. Resolve production issues in a timely manner including on-call support as needed and maintain audit/security.

  • Working with other internal and external resources, plan and manage BI system implementations and upgrades, license management, security, auditing, and future/additional product evaluations for the business intelligence applications as needed.

  • Create documentation for project plans, project status reports, timelines, project issues and risks, change requests, requirements, design, testing plans and test cases as needed for assigned projects.

  • Provide the AVP Business Intelligence and DW Solutions with regular and timely status reports and benchmarking metrics of projects, issues, system implementations and upgrades. Make wise decisions regarding prioritization of work assignments.

  • Communicate status of production issues (describing issue, resolution, and status) with both the business and the Business Intelligence team in a timely manner.

  • Cross-train with and serve in backup administrator role for other Business Intelligence 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). Provide business and application consultation for project and support teams.

  • Define and document application best practices, required standards, processes, and guidelines regarding the use and administration of the BI tools. Standardize the development process for the content developers.

  • Research functionality and technical configuration within the BI systems supported by the BI Applications group and prepare recommendations for system improvements whenever possible.

  • Maintain and monitor all BI environments including development, test, production, and disaster recovery.

Qualifications

Knowledge

  • Advanced knowledge of information technology systems, infrastructure and operations.

  • Significant experience in a large and complex business environment.

  • Advanced knowledge of report development, data models, and administration processes in an enterprise Business Intelligence tool such as IBM Cognos.

  • Advanced knowledge of database software (Oracle, SQL Server, Informatica, etc.) as well as relational and OLAP database designs.

Skills

  • Ability to effectively lead, organize, and supervise.

  • Ability to interact with staff at all levels.

  • Ability to meet expected delivery dates and the tasks necessary to achieve objectives.

  • Ability to work directly with senior level management.

  • Advanced computer skills and knowledge in information technology issues.

  • Advanced experience with data visualization concepts and tools.

  • Deadline oriented.

  • Excellent writing and speaking skills.

  • Must be a self-starter and able to manage the investigations function with minimal supervision.

  • Strong ability to analyze data using Excel for reporting and data mining purposes.

  • Strong in the use of Microsoft Office software.

  • Strong people skills.

  • Must have advanced SQL writing skills.

  • Strong project management, organizational and time management skills.

  • Strong understanding of the technical and functional environment. Strong skills in system administration and development experience with BI tools.

Education

  • Bachelor's Degree Computer Science or MIS or equivalent work experience required

Experience

  • 5-7 Years designing, developing, and administering Business Intelligence applications. Experience should include maintenance and support activities, 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 combined in general data warehouse and business intelligence report development. Required

Work Condition

  • Normal office environment

  • Strong focus on providing quality service to internal and external customers

  • Occasional extended working hours may be required

  • Limited travel may be required to support business needs

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Sr Cognos Developer/Oracle EBS

GM Financial

Posted 3 weeks ago

VIEW JOBS 11/22/2018 12:00:00 AM 2019-02-20T00:00 Overview The Sr. Oracle Application Technical Specialist – Cognos position, under limited supervision, provides advanced support for Oracle E-business Suite acting as an internal Functional/Technical analyst resource. This includes, but is not limited to, gathering business report requirements, assisting business partners with user acceptance testing, communication, documentation, training, report testing and end-user production support. The Sr. Oracle Application Functional/Technical Specialist resource will work with Cognos developers to support all aspects of business analytics and reporting. Technical skills required include a solid understanding of the Oracle ERP table structures using basic to advanced SQL select statements, provide adequate data issue resolution with detailed documentation and anticipate business partner's questions and provide solutions to answer analytics and reporting questions. This employee has heavy contact with other business departments, as well as, outside vendors in support of international IT operations. Responsibilities Plan, organize and coordinate the business requirements gathering and/or development of analytics and reporting in accordance with strategic business plans and industry standards on multiple large projects Responsible for analyzing and providing functional/technical knowledge of supported applications and user needs. Document the requirements, help coordinate reporting solutions following the GMF Software Development Lifecycle methodology Investigate and resolve data issues and analyze all business requirements and perform interview with all stakeholders Coordinate with all customers and analyze test queries and analyze client issues and assist all application analysts to translate all workflow requirements to efficient data points Assist with the creation, documentation and execution of report test scripts for supported systems. Research, implement and document solutions to issues identified during testing Develop and perform tests on various enterprises and provide dashboard solutions with help of Cognos software and assist all end users Collaborate with Project Management Office, development teams, data integration teams (ETL, Data Architect) for providing new data sources for analytics and reporting Interface with vendors and suppliers in support of business applications Provide direction to and mentor other teammates Communicate with management and business partners on production and project statuses in a timely manner Work closely with internal business units to facilitate project completion. Performs other duties as assigned Conforms with all corporate policies and procedures Qualifications Knowledge Knowledge of relational database structures, start schema structures, models, and diagrams Understanding of enterprise data integration and data architecture Advanced knowledge of business processes for supported business groups. Advanced knowledge of information technology systems, infrastructure and operations. Advanced working knowledge of information systems and operations systems for supported business groups. Knowledge of business processes for supported business groups. Knowledge of GM Financials core business functions, policies and procedures. Knowledge of information technology systems, infrastructure and operations. Knowledge of security methodologies, policies, standards and best practices. Knowledgeable of best practices in information technology governance and regulatory landscape for financial institutions. Significant experience in a large and complex business environment. Working knowledge of information systems and operations systems for supported business groups. Working knowledge of the Corporate Business solution environment. Skills Ability to analyze data using Excel for reporting and data mining purposes. Ability to effectively lead, organize, and supervise. Ability to interact with staff at all levels. Ability to meet expected delivery dates and the tasks necessary to achieve objectives. Ability to work directly with senior level management. Advanced computer skills and conversance in information technology issues. Advanced experience with data visualization concepts and tools. Deadline oriented. Excellent writing and speaking skills. Must be a self-starter and able to manage the investigations function with minimal supervision. Strong ability to analyze data using Excel for reporting and data mining purposes. Strong in the use of Microsoft Office software. Strong people skills. Additional Knowledge Skills and Abilities Experience with Cognos version 9.X, 10.X or Cognos Analytics Oracle R Financial eBusiness Suite modules (GL, AP, AME, SLA, FA, PAY, WF, CE, PO, iProc, iExp and AR Lite) Excellent Proactive Planning and Initiative in success of all project and support efforts SQL Select and Advanced SQL Experience with Human Resource and or Financials applications such as; Oracle ERP modules and databases, SuccessFactors, iCIMS, Treasury Management Systems, or Imaging Systems would be a plus. Education Education Level Education Details Req Pref N/A Bachelor's Degree Finance, Information Systems or Accounting X Work Experience Experience Experience Details Req Pref N/A Greater than 10 years of implementation and support on ERP system as a functional resource X Essential Functions: The following are Essential Job Functions, such as physical, sensory and cognitive demands representative of those that must be met by an employee to successfully perform the essential functions of this job. Essential Functions IT Positions Essential Type Ability to convey information. Concentrate and focus with frequent interruptions. Lifting or raising object(s) less than pounds. Must be able to operate a motor vehicle (company, personal or rental) for travelling from one work location to another work site. Perceive normal speaking levels with or without correction. Repetitive motion: use fingers to click and scroll mouse and type on computer keyboard. Walking and moving from one work location to another. Repetitive motion: use hand and wrist to move around computer mouse. Reaching or extending hands and arms in any direction. Lifting or raising object(s) more than pounds. Converse verbally with clients, colleagues and vendors. Ability to receive information through oral communication. Working Conditions Occasional overtime or split shifts may be required. Subject to loud noise. Subject to stressful situations. some travel required. normal office environment. Fast-paced office environment. Strong focus on providing quality service to internal and external customers. Work a flexible schedule including extended business hours, weekends and holidays. Work additional hours based on production demands requiring mandatory overtime. Flexible schedule with possibility of working long hours. Limited travel may be required to support business needs. Must be able to deal with stressful office conditions while troubleshooting problems. GM Financial Arlington TX

Sr. Cognos Administrator

GM Financial