Job ID :
Company :
Internal Postings
Location :
Type :
Duration :
6 months
Salary :
Status :
Openings :
Posted :
09 Mar 2018
Job Seekers, Please send resumes to
Job Description:

Our client in Culver City, California is currently looking to hire a Technical Business Intelligence Application Lead for a contract to permanent opportunity.
Responsibilities include:
  • Interacting with Business Users/ Product Owners to understand their BI needs and identify the data sources / data completeness to meet the BI needs
  • Implement the BI and data warehouse requirements through the use of ETL, business intelligence tools, and database programming and reporting tools
  • Migration of current BI/Reporting Solutions to newer BI Platform
  • Work closely with the business and IT teams in design discussions, reviews and test cycles
  • Work closely with the business and IT teams to determine steps to produce reports in an agile methodology
  • Identify effective reporting techniques, identify the best data sources for reach report, identify risks and constraints, and design reporting formats
  • Ensure teams deliver optimized database and ETL design to achieve acceptable performance and utilize the database and ETL resources effectively
  • Full life-cycle awareness of data warehouse, ETL, and business intelligence solutions
  • Data analyst skills to determine root cause problems for data integrity and data quality issues identified through QA or by business report owners
  • Provide guidance and recommendations on BI reporting techniques considering the transaction reporting, management reporting and analytical reporting
  • Review current universe/reporting design and propose changes for better performance
  • Provides delivery estimates for project planning purposes.
  • Provide inputs into tuning of User Written reports or ETL jobs
Key outputs include:
  • Provide the right BI Solution in line with the Business needs and with Industry BI Best Practices
  • Document the BI processes involved in implementing a BI Solution end to end
  • Document Report Designs/Mock-Ups
  • Document Departmental Best Practices
  • Contribution of documentation to IT knowledge database
Core Responsibilities:
  • 25% - Understands the business requirements and translates them into Epics/Stories. Propose the solutions to meet these needs. Review the designs and ensure they follow the agreed and established standards
  • 25% - Implements and supports BI projects. Troubleshoot BI tool problems and tune for performance. Adapts BI processes to accommodate changes in source systems and new business user requirements. Support client areas in their analytical functions.
  • 20% - Data profiling, understanding of conceptual and logic models, participates in design of physical models
  • 20% - Sets design specifications for end-user semantic layers and multi-dimensional models across BI environments. Migration of current Reporting solutions to newer BI Platform as required.
  • 10% - Mentoring the team on the BI Standards, Technology and latest BI trends and initiatives happening in the organization
  • 7+ of years of IT work experience and 5+ years in the similar role of BI App Lead.
  • ITIL v3 certified
  • Business Intelligence tool architecture, features and functionality
  • Data Warehouse database platforms – Any MPP Architecture is a must .Teradata is a must and any experience with cloud, NOSQL, Hadoop is an added advantage
  • Experience with Business Objects/Tableau required. Knowledge of other tools such as Alteryx a plus.
  • Knowledge and experience of at least one data profiling tool
  • Familiar with ETL tools especially hands on experience with DataStage
  • Relational databases like Oracle, SQL Server, DB2 UDB and Sybase
  • Strong with data modeling concepts (star schemas, snowflake schemas, highly normalized data models), and familiarity with data modeling tools is an added advantage
  • Familiar with physical database administration concepts such as table partitioning, materialized views, indexing strategies, aggregate navigation and their role within the decision support environment
  • Familiar with OLAP and multi-dimensional database technologies such as Hyperion Essbase or SQL Server Analysis Services
  • Familiar with hardware concepts such as SMP and MPP architectures and their impact on the BI environment
  • Familiar with source control tools such as GitHub a plus
  • Excellent at performance tuning BI processes and queries (concepts such as caching, sorting, and indexing)
  • At least 2 years working in an agile environment for BI
  • Excellent relational database knowledge
  • Excellent problem solving skills
  • Excellent communication skills with both business and technical customers
  • Demonstrate a high level of integrity and maturity
  • Work on multiple projects and deliver consistently on time
  • Escalate issues appropriately to management and project team
  • Take a proactive approach to cross-functional communication
  • Actively seek out feedback from management and peers, to improve own performance based on that feedback.