Job Description :
Job Summary: The BI Technical Lead provides oversight and direction to the BI Developers. The BI Technical Lead also designs and develops Dashboards and ETLs using OBIEE suite of tools. The candidate must have a strong background in Business Intelligence and Data Warehousing concepts; as well as, experience leading teams.

Specific Duties
Gather Requirements, conduct Business Analysis, and write Technical Design Specifications
Design and Build ETL solutions utilizing Data Analysis, Dimensional Modeling and ETL Design
Design Physical, Business Model and Presentation layers using OBIEE; define logical views and physical data Security structures
Develop Informatica code, Design, Develop and modify Informatica mappings and workflows
ETL performance tuning, Optimization, Code Quality and Standards
Design, document, and develop OBIEE11g Reports/Dashboards
OBIEE Administration activities including Security, Configuration, and Maintenance
Define Test Scenarios and Build/Execute Test Plan
Assist with performance tuning as it relates to OBIEE dashboards, analyses, and prompts
Maintain and Support DAC nightly schedule
OBIEE Migration, including RPD, DAC, Informatica and Web Catalog
Work with IT Financials Director to set priorities and direction for BI Team.
Perform Development Reviews and provide feedback to Team Members

Bachelor’s degree in Information Management, Computer Science or comparable major.
5+ years of experience required in related field (i.e. ETL, Data Warehousing and SDLC
5+ years of experience working with Informatica ETL tool (design and development
Experience in the design, architecture for an ETL solution, including Data analysis, Dimensional Modeling and ETL Design using Informatica in a Data warehousing environment.
Strong data analysis skills, Dimensional Modeling, experiences in designing Star Schemas.
Solid understanding of requirements for Data Quality, Metadata, Data Lineages, Operational Data Management and provide the Solutions.
Basic OBIEE administration (manages web catalog objects, archive/unarchive, set permissions and ownership, start/stop server, deploy RPD, etc
OBIEE RPD development, including the design and creation of dimensions, hierarchies, and logical data sources, etc.
Hands-on experience using Data Warehouse Application Console (“DAC”
Demonstrate in-depth understanding of Data Warehousing (DW) and ETL concepts, ETL loading strategy, Data archiving, Data reconciliation, ETL Error Handling, Error logging mechanism, standards and best practices.
BI Publisher report development a plus.