Arrchetype Consulting, Inc. Senior Consultant ETL Developer in Boston, Massachusetts

Senior Consultant ETL Developer, Bachelor?s (or foreign equivalent) in Computer Engineering, Computer Science or related. Five year?s progressive post-baccalaureate experience in Computer Science, MIS, Engineering or related field. Skill set and/or knowledge must include relational or multi-dimensional databases modelling, SQL, PL/SQL, ETL tools such as ODI, Informatica and OBIEE reporting tool; OBIEE/OBIA Architect/SME (Subject Matter Expert) for OBIEE/BIA implementation; creating data marts, schema designing for reporting purpose, OBI analyses and complex dashboards; multiple source systems for reporting such as Oracle Applications, PeopleSoft and Essbase; different domains such as Financial, Banking, HealthCare, Manufacturing and Education; financial planning and reporting processes including planning, consolidation and financial reporting applications; financial reporting and/or performance management processes; designing/developing integrated planning/reporting/business intelligence solutions; source system requirements including transactional systems, business queries and business analytics; implementation and managed services project management; business/end-users for requirement gathering and executing functional designs; training end-users on ad hoc reporting using OBIEE reporting tool. Willing and able to work at unanticipated client sites throughout the U.S. (30%). Lead, design, build and deliver Oracle SQL database development solutions as part of Service Delivery team. Involved in all project phases including requirements gathering and documentation, technology evaluation, solution design and implementation, testing and validation, and user training and acceptance Participate and lead "firm building" initiatives and activities. Source system analysis, software evaluations, requirements analysis and/or the future solution visualization, aligning business requirements and best practices to implement technical solution. Lead the design of databases (conceptual and logical models), ETL processes, calculation processes utilizing best practices of Business Intelligence (BI) and data warehouse design. Ensure data integrity during implementation process balanced with project scope/time line. Business Development and pre-sales support through providing subject/technical expertise, estimating work effort and resources, development of sales proposals and statements of work. Provide expertise and guidance to develop service delivery practices and supporting methodologies. Current state process analysis; developing future state recommendations; solution recommendations; prioritization and road mapping to close performance gaps and develop high level implementation plans. Provide technical leadership for 3- member project team. Work at unanticipated client sites throughout the U.S. (30%). Lead, design, build and deliver Oracle SQL database development solutions as part of Service Delivery team. Involved in all project phases including requirements gathering and documentation, technology evaluation, solution design and implementation, testing and validation, and user training and acceptance Participate and lead "firm building" initiatives and activities. Source system analysis, software evaluations, requirements analysis and/or the future solution visualization, aligning business requirements and best practices to implement technical solution. Lead the design of databases (conceptual and logical models), ETL processes, calculation processes utilizing best practices of Business Intelligence (BI) and data warehouse design. Ensure data integrity during implementation process balanced with project scope/time line. Business Development and pre-sales support through providing subject/technical expertise, estimating work effort and resources, development of sales proposals and statements of work. Provide expertise and guidance to develop service delivery practices and supporting methodologies. Current state process analysis;