Business Intelligence Systems Analyst III

GM Financial is the captive finance company and the wholly owned subsidiary of General Motors and is headquartered in Fort Worth, Texas. The company is a global provider of auto finance solutions, with operations in North America, Europe, Latin America and China.

The Business Intelligence (BI) Systems Analyst III is responsible for the administration, configuration, development, and on-going support of the OLAP reporting and analytical solutions for the business community. The BI Systems Analyst III is responsible for the internal customer facing activities of defining business requirements, proposing development solutions, and validating that these solutions meet the needs of the business.The Business Intelligence Systems Analyst must have strong technical, analytical and problem-solving skills. This team member will have exposure to 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 customers to better understand and enable delivery of their reporting requirements. This team member ensures that customers are trained to use the applications in a way that will meet their requirements.

* 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 BI Solutions Manager 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 and disaster recovery environments. Ensure disaster recovery environments are in sync with the production environment. * 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** * Direct reports: none

**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 reporting or budgeting and planning. SAP Business Planning and Consolidation (BPC) for Microsoft preferred. Hyperion Planning and Budgeting experience also considered. * 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. * Functional and technical understanding of budgeting and planning applications and processes. * Working knowledge of SAS in a server environment a plus. **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. * Minimum of 5 years project management experience or PMI certification.. * Financial Services experience a plus. * Base SAS and Enterprise Guide experience a plus.