American Tower Senior Business Intelligence and Data Warehouse Engineer in Marlborough, Massachusetts
*SUMMARY:* The Senior Business Intelligence (“BI”)/Data Warehouse (“DW”) Engineer is responsible for understanding BI/DW business requirements, creating technical specifications and coordinating the development and testing tasks with onsite and remote development resources. The incumbent will be the subject matter expert in Oracle BI Applications ("OBA") implementation, Oracle Data Integration ("ODI") programming, BI Publisher report creation and Analyses creation. The incumbent will serve as a liaison between onsite Business Analysts and Architects and remote Developers to complete BI/DW projects deliverables.
*ESSENTIAL DUTIES:* * Participate in BI/DW business requirements and user stories review sessions * Participate in BI /DW functional and technical design sessions * Work with Business Analysts to create prototypes for BI solutions * Create technical specifications in accordance with business requirements documentation * Review technical specifications with remote Developers * Coordinate the development tasks with remote Developers * Coordinate the testing tasks with remote Quality Analysts and onsite Business Analysts * Conduct quality reviews on offshore development deliverables * Enforce BI/DW design and development standards * Update BI/DW product documentation * Provide hands-on technical expertise in ODI program changes, repository changes and report changes * Travel to business locations to participate in requirement gathering sessions and product deployment sessions * Travel to remote development centers to build relationships, conduct technical training to remote developers * Work with International business users to resolve BI/DW-related issues
*OTHER:* * Other duties as assigned
*SUPERVISORY RESPONSIBILITIES:* * None *QUALIFICATIONS:* * Ability to work with functional groups and different level of employees to effectively and professionally achieve results * Strong follow-up skills; ability to organize applicable department timelines and follow up with internal and external customer needs * Strong written and oral communication skills, including the ability to present ideas and suggestions clearly and effectively * Strong organizational skills; ability to accomplish multiple tasks within the agreed upon timeframes through effective prioritization of duties and functions in a fast paced environment * Strong track record of building and maintaining solid relationships with internal and external customers and vendors. * Self-motivated, able to work independently to complete tasks and respond to department requests and to collaborate with others to utilize their resources and knowledge to identify high quality solutions * Strong technical documentation skills; ability to prepare technical specifications * Excellent data analysis skills; ability to reconcile the reports with source applications and data warehouse * Excellent problem solving skills; ability to troubleshoot data related issues and systems related issues * Ability to communicate effectively with remote Developers and Quality Analysts * Clear understanding of data warehouse and BI concepts
*EDUCATION AND EXPERIENCE:* * Bachelor's degree in Computer Science or related field required * Between 7-10 years of Information Technology experience required * Between 5-7 years of BI/DW development experience required * Experience with ODI required * Experience with Oracle Business Intelligence Enterprise Edition required * Experience with Oracle prepackaged BI applications required * Understanding of Oracle EBS applications required * Experience with Oracle Essbase cubes preferred * Experience with Oracle Database programming required * Experience with other databases, such as SQL Server, preferred * Experience in collaborating with remote development teams required
*ENVIRONMENT:* * Approximately 100% performed in climate-controlled internal office environment working under normal office conditions. Approximately 20% travel may be required in support of the position’s responsibilities. * While performing the duties of this job, the employee is regularly required to sit, stand, walk, use hands and fingers to feel and handle, reach with arms and hands, talk and hear. While performing the duties of this job, the employee frequently is required to stoop, kneel and crouch, lift weight or exert a force up to a maximum of 25 pounds.
Job: *Sr Eng BI and DW
Title: Senior Business Intelligence and Data Warehouse Engineer
Requisition ID: 1700001Y