Jobs search

Business Intelligence Engineer

DPP Tech • Contract • Remote (California, United States, US) • 5d ago

Job Title: BI Engineer

Key Responsibilities

Leadership & Development: Provide development leadership for advanced BI analysis and analytics, guiding the evolution of the BI/Data Mart system.
Data Management: Own the advanced analytics data environment, ensuring regular data refreshes from various sources to facilitate research.
Architecture & Development: Drive data architecture, ETL processes, and system development. Ensure scalability of the data infrastructure to meet performance and functional objectives.
Project Management: Effectively manage parallel projects of varying scope and duration, ensuring timely execution and delivery.
Database Administration: Oversee all database objects, including tables, indices, triggers, views, sequences, packages, and procedures.
Collaboration: Work with Systems and Database Administration on support needs, storage, backups, monitoring, and performance bottlenecks.
Application Management: Collaborate with application development and quality assurance teams in managing application releases.
Best Practices Advisory: Advise senior management on best practices in web analytics, data warehousing, data architecture, and development.
Data Refresh Planning: Collaborate with business intelligence and source system owners to develop a data refresh plan for the research environment.
Web Data Management: Own web clickstream data collection and support product managers in implementing best practices for data definition.
Documentation & Support: Assist with project management and documentation needs for the team.

Required Skills and Experience

Database Expertise: Experience with Oracle 8i, 9i, and 10g, including PL/SQL, SQL loader, external tables, partitioning, and performance tuning.
Data Architecture: Strong knowledge of Oracle data structures and RDBMS. Experience as a data architect or in DW/BI architecture.
Database Design: Proven experience in database design, administration, performance tuning, software installation, scripting, PL/SQL coding, and backup & recovery processes.
Project Implementation: At least two medium to large-scale DW/BI project implementations.
Data Concepts: Understanding of DW/BI concepts, including STAR schema, data cleansing, transformation, and aggregations.
Development Experience: Minimum of 4 years of current development experience with a focus on development tasks.
Web Analytics: Over 1 year of experience with web analytics products such as WebTrends, NetTracker, or Omniture.
Integration Issues: Experience in addressing customer integration issues, preferably with MDM.

Preferred Skills

Familiarity with various business applications such as campaign management, CRM, and ERP systems.
Experience with front-end scripting languages like JavaScript.
Knowledge of column-oriented database solutions such as HBase or Infobright.
Experience with Hadoop.
Oracle database administration experience.
Proficiency with data reporting tools like Business Objects, MicroStrategy, or COGNOS.
Experience with ETL tools such as DataStage, Informatica, or Hummingbird.
Familiarity with metadata management and SAS.