American Tower Senior Database Engineer - ODI 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 packages using Cognos. The Senior Database Engineer 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. * Design, develop and implement Cognos TM1 applications for financial planning and reporting models with complex rules _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 * Knowledge of reporting suites (Cognos preferred): Microsoft (Reporting Services, Report Builder, Excel Services, Performance Point); Cognos 8 BI (Query Studio, Report Studio, Event Studio) * Knowledge of Cognos TM1 tool * Knowledge of financial planning solutions using Cognos TM1 applications * Knowledge of integrating TM1 applications with enterprise business applications using Turbo Integrator _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.) * Extensive experience with at least one relevant ETL tool Experience with SQL Server 2005 (Integration Services and Relational Engine) and/or Oracle 10g/11g (and equivalent ETL). * Experience with relational databases (SQL queries, tuning, etc.) * Experience with Visual Studio, Team Foundation Server and/or Visual Source Safe, SQL Management Studio preferred * Experience with a leading BI solution such as Cognos, Business Objects, or Microstrategy required * Experience with Erwin or an equivalent data modeling tool required * Experience with implementing Planning, Budgeting, Forecasting and financial reporting solutions using TM1 _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 - ODI
Requisition ID: 17000083