IT - Business Intelligence (Advanced Analytics Developer) Business Intelligence (Advanced Analytics Developer)

Job Description : Provides development leadership and expertise for advanced BI analysis and analytics. Guides and moves forward an advanced BI / Data Mart system providing sophisticated and measurable business benefits.

Drives data, ETL and system architecture and development. Owns the advanced analytics data environment to ensure that the data refresh from various sources, to facilitate research, is happening at regular intervals.

Supports a group of multi-disciplinary data professionals and analysts. Drives development (coding using PL / SQL, Perl or any other scripting language, ad-hoc queries using SQL).

Ensures that the data infrastructure can scale to meet defined performance, load, and functional objectives Effectively manages the execution of parallel projects of varying scope and duration.

Responsible for all database objects including tables, indices, triggers, views, sequences, packages, and procedures. Works with Systems and Database Administration for infrastructure needs related to support, storage, backups, monitoring, performance bottlenecks.

Participates with applications development and quality assurance in the management of application releases. Advises senior management on best practices concerning web analytics, data warehousing, data architecture, and data development.

Works with business intelligence and other source system owners to build data refresh plan for research environment. Owns web click stream data collection and supports product managers to implement best practices for data definition.

Supports project management and documentation needs of the group.

Skill Set :

Experience with Oracle i, i and g including PL / SQL, SQL loader, external tables, partitioning and performance tuning. Strong knowledge of Oracle data structures, data dictionary, and RDBMS structures.

Experience as data architect and / or DW / BI architecture. Experience in database design and administration, strong in performance tuning, software installation, scripting, PL / SQL coding, backup & recovery process.

At least medium to large scale DW / BI project implementation experience. Experience working with DW / BI environment to be able understand the concepts of STAR, data cleansing, transformation and aggregations.

• years, current, development experience and inclination towards development. + years experience with web analytics products like web trends, NetTracker, Omniture etc.
• Experience working in an environment that has come across customer integration issues or has addressed it using MDM. Ability to express business and technical concepts clearly and concisely both verbally and in writing.

Aggressive approach to staying current with developments within the internet world, related web analytics & data management.

Experience working in a team-oriented, collaborative environment. Good to Have Skills : Experience working with various business applications like campaign management, CRM, ERP.

Experience with Java scripts or any other web front end scripting. Experience with column oriented database solutions such as HBase or Infobright.

Experience with Hadoop. Oracle database administration experience. Experience working with various data reporting tools like Business Objects, MicroStrategy, COGNOS.

Experience working with ETL tools like Data Stage, Informatica, Hummingbird. Experience working with meta data management. Experience with SAS.

Additional Regions : EEO :

EEO :