[{"country_short": "USA", "city": "Salem", "description": "SQL/OBI Developer (6391)\n* \n* \n* \n* \n* \n* \n* \n* \n* \n* \n\nRequisition Id 6391 - Posted 02/03/2012 - Winston-Salem, NC - Information Technology\nJob Description Print Preview\n\nApplySave JobEmail Job to FriendReturn to List\n\n\n\n\n\nIf you\u2019re interested in joining a stable, fast-growing company that encourages professional advancement, fosters teamwork and rewards ingenuity, then B/E Aerospace may be right for you. As the world's leading manufacturer of aircraft interior products and solutions, and the world's leading distributor of aerospace fasteners and consumables for the commercial, business jet, and military markets, a career at B/E Aerospace is beyond what you'd expect in a job. At B/E, we realize that our employees are one of the keys to our success. We look for individuals who share our passion to succeed and generate results. Think you have what it takes to join our team?\n\nAs a leader in the aerospace industry, we are growing rapidly and have a number of exciting positions available right now, including a SQL/OBI Developer.\u00a0 This positionwill develop business solutions by creating new and modifying existing business intelligence applications. In this position you will design, code, test, debug, document and support Hyperion EPM/OBIEE/OBIA applications consistent with established specifications and business requirements to deliver business value.\u00a0\u00a0\u00a0\n\u00a0\n\u00a0\n\n\u00a0\n\u00a0\nMinimum Requirements\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Bachelor's degree (BA/BS) from four-year college or university or equivalent combination of education and experience\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05+ years experience with Essbase, EPM, OBIEE, or OBIA application development\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a03+ years experience with SQL Server 2005 or above including performance tuning and best practices\n\u00a0\nPreferred Requirements\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Oracle Essbase or OBIEE product certification strongly preferred\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05+ years Application Development and/or software implementation experience\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05+ years SQL Server development experience\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Solid understanding of and ability to support enterprise data warehouses and multi-dimensional cubes: star and snowflake schemas, material views, dense versus sparse dimensions, ASO versus BSO, calc scripts, load rules, etc.\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a03+ years of experience with ERP systems\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Proficient with ETL concepts and Master Data Management\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Strong knowledge of Oracle Performance Management tools including Oracle Essbase Administration Services, Shared Services, Application Manager, and OBIEE\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Strong working knowledge and experience with JDE developer tools and processes\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0JDE Enterprise One experience preferred but not required\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Familiarity with the EPM Suite including HFM, FDQM, Planning, Financial Reports, Web Analysis is a plus\n\u00a0\n\u00a0\nResponsibilities\n\u00a0\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Performs application development with team members on complex requirements involving multiple technologies such as Oracle, SQL Server, Hyperion Essbase, Hyperion Planning, Hyperion HSF, Hyperion FDQM, Hyperion HFM, and OBIEE.\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Research industry trends and best practices and implement data management life cycle within the organization\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Assist in establishing Data Governance and Change Management processes\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Responsibilities for building, maintaining, managing, and optimizing:\no\u00a0\u00a0\u00a0Oracle BI Server\no\u00a0\u00a0\u00a0Oracle Enterprise Manager (Weblogic Server)\no\u00a0\u00a0\u00a0Oracle BI Dashboards and Answers\no\u00a0\u00a0\u00a0Oracle BI Publisher\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Responsible for building, maintaining, managing, and optimizing:\no\u00a0\u00a0\u00a0SQL Data Marts from disparate data sources\no\u00a0\u00a0\u00a0Complex T-SQL and PL/SQL scripts to facilitate data flow within the ETL framework\no\u00a0\u00a0\u00a0Stored Procedures, SQL Server Jobs, Triggers, Functions, Views, Indexes, etc.\no\u00a0\u00a0\u00a0SSIS environment and SQL Server Management Studio\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Knowledge of with pre-packaged OBIA modules (Supply Chain and Order Management, Procurement and Spend, Financial Analytics)\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Responsible for developing end-user reports and web analysis dashboards\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Works with business leaders to develop detailed business requirements, creating functional design, gap analysis, technical design, and traceability matrices\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Validate all project touch points and implement changes into production\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Designs, develops and tests enhancements of reporting applications in adherence to standards and methodology, including UAT testing requirements\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Completes production support service requests, troubleshooting issues and batch support to ensure high levels of application availability and accuracy\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Ensures high reporting application availability and accuracy as well as oversight of customer service requests\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Collaborates with ERP team to manage reporting throughout implementation/changeover\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Collaborates with applications development team to help convert silo reporting systems to enterprise solutions\n\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Works closely with personnel responsible for security policy and structure to keep current with domestic and international requirement and maintain data management systems in compliance with all pertinent guidelines and rules.", "date_new": "2012-02-03 21:38:47", "url": "http://careers.beaerospace.com/xml/26306209/job", "country": "United States", "company": "B/E Aerospace, Inc.", "title": "SQL/OBI Developer (6391)", "reqid": null, "state": "North Carolina", "state_short": "NC", "location": "Salem, NC", "uid": 26306209}]