American Tower Senior Database Engineer in Woburn, Massachusetts
_SUMMARY:_ The Senior Database Engineer will be responsible for leading data modeling, mapping, extract, transform and load (ETL), test and deployment efforts for various business intelligence (BI) tools and technology solutions. The incumbent will be responsible for creating and maintaining logical and physical data models using established enterprise tools and best practices. These tools and best practices include the Erwin data modeling tool and semantic layer modeling using Oracle Business Intelligence Enterprise Edition (OBIEE). The incumbent will provide technical knowledge and leadership guidance working with Database Engineers, Database Administrators, Enterprise Data Warehouse (EDW) Architects, Quality Assurance Analysts and other teams.
_ESSENTIAL FUNCTIONS:_ * Engage business users to extract complex requirements and priorities in order to propose the right solution for the business need * Mentor business users and other team members in EDW and BI best practices and techniques * Assist the organization in understanding newest technology advances and best practices to leverage this technology to support business drivers * Lead technical teams in the design and development of enterprise data warehouses, operational data stores and reporting solutions * Design for a variety of functional area solutions (subject areas) in the telecommunications industry * Perform data modeling, including dimensional and relational * Design data warehouses (logically and physically) * Define industry standards for data administration and reporting * Support performance in BI and data warehouses * Analyze business requirements for real time, near-real time and staged data reporting * Design BI solutions using analytical processing (OLAP), standard reporting and ad-hoc querying _OTHER:_ * Other duties as assigned. _SUPERVISORY RESPONSIBILITIES:_ * None _QUALIFICATIONS:_ * Strong presentation skills * Expert troubleshooting and problem solving skills * Detail-oriented, able to multitask, meet deadlines, work on a team and independently. * Strong knowledge of dashboard and BI presentation design concepts * Excellent verbal and written interpersonal and communication skills * Knowledge of the difference between normalized and dimensional models * Knowledge of best practices through relevant experience across data-related disciplines and technologies, particularly for enterprise-wide data architectures, data management and data warehousing/BI and through experience with large, complex Enterprise Data Warehouse initiatives * Strong knowledge of OBIEE tool set, including Repository Builder (RPD), Dashboards, Analysis Reports, BI Publisher Reports * Experience with Oracle prepackaged BI Applications _EDUCATION AND EXPERIENCE:_ * Bachelor of Science degree in Computer Science or related degree or related experience required * Six (6) Ã¢â‚¬â€œ ten (10) years experience with relational database, ETL, data warehouse (design, data modeling, development or architecture) required * Extensive experience with data warehouse architecture, data modeling, design, implementation and concepts (Kimball methodology, star schemas, semantic layer design, etc.) * Experience with Oracle 10g/11g * Experience with relational databases (SQL queries, tuning, etc.) * Experience with Subversion, Toad, Sqldeveloper tools * Experience with a leading BI solution such as OBIEE, Cognos, Business Objects, or Microstrategy required * Experience with Erwin or an equivalent data modeling tool required _ENVIRONMENT:_ 100% performed in climate-controlled internal office environment working under normal office conditions. Approximately 10% travel will 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 Database
Title: Senior Database Engineer
Requisition ID: 170000CB