*Please send resume to **n...@westcoastllc.com* <n...@westcoastllc.com>*only with contact information and location of candidate **.*
*Senior BI Consultant (SSIS SME and ETL Developer)* *Duration: 6 months+* *Face to face required * *Location: Redwood City, CA* The Senior Business Intelligence Engineer will be a key team member of the Business Intelligence and Database Engineering group supporting BI development lifecycle practices in a fast paced high growth Bio-Tech company. The candidate will be primarily responsible for Enterprise Report development for Finance, Sales, Commercial Operations, Customer Service and Laboratory business units. Additionally the candidate will also be responsible for Data Warehouse modeling & design & ETL development. The candidate must have excellent database engineering and related skills (major RDBMS - Oracle, SQL Server) and be able to multi-task on projects based on business priorities. This position offers significant growth potential within an innovative and dynamic cancer diagnostics company. *Responsibilities:* · Contribute substantially in the implementation of business intelligence solutions using Tableau, SQL Server 2005/2008 Integration Services, Analysis & Reporting Services and Business Intelligence Studio. · Contribute substantially in understanding business reporting needs, gathering & documenting Data Warehouse & Reporting requirements. · Contribute substantially in Data Warehouse development lifecycle from business requirements to development of logical design, translation to physical design, ETL code development and testing using SQL Server 2008 Business Intelligence Development tools. · Contribute substantially in defining the report functional specifications based on business user requirements. Define, implement, and QA & performance tuning of reports. · Cross train and mentor other report developers in efficient report design techniques. · Contribute substantially in report query optimization, Index design and Planning, Index analysis and tuning. · Contribute substantially in technical review of SQL code with peers and design review with end-user audience. Participate in the testing & deployment of database code to QA & Production, managing database source code & scripts and updating & maintaining data models. · Contribute substantially in maintaining and monitoring Enterprise Data Warehouse System (EDW) on production and development servers. · Collaborate with the QA team to create and execute system test plans and user-acceptance testing. *Qualifications: * *Must a Subject Matter Expert with SSIS and strong ETL development skills. * · *Experience changing servers to a new storage environment, synchronize the change with zero issues* · *Strong production system knowledge * · Hands-on experience with aspects of the Data Warehouse lifecycle including data analysis, data modeling & design (preferably using STAR schema approach). · Hands-on experience in ETL and reports development with SQL 2008 Integration (SSIS) and Reporting (SSRS) Services · Hands-on experience in Data Warehouse migration including SSIS driven ETL and reporting from SQL 2005 to SQL 2008 · Hands-on experience in ETL job orchestration, batch process automation, and lights-out batch processing in medium to large data warehouse implementations · Hands-on experience with setup & optimization of the operational data streams using scheduling tools · Hands-on experience designing, scripting, and tuning report queries using ANSI-SQL (SQL-92) syntax. Familiarity with some advanced T-SQL usage patterns to solve common query and aggregate reporting problems. · Hands-on experience in building enterprise reports with major professional report building software packages such as SQL Server Reporting Services, Business Objects, Hyperion BRIO etc. · Experienced in enterprise level report deployments, upgrades, conversions and operations. · Must be experienced in troubleshooting issues, working with vendor support team is required. · Candidate must have a high comfort level with report terminology and concepts such as drill-down, roll-up, aggregation, etc. · Technical understanding of database-related aspects of the software development lifecycle such as change control management, unit testing, packaging and deployment of database changes and management of database source code projects. · Familiarity with entity relationship modeling tools and be able to maintain database logical model and schema diagrams. · Hands on experience and knowledge of modern data warehousing principles and practices a plus. · Solid analytical skills and integration knowledge · Strong problem solving and troubleshooting skills · Ability to work effectively in a team-oriented environment · Effective verbal and written communication skills · *Must have a degree* *Pluses:* · *Tableau tool experience* · *Really want someone with back end to front end experience, so dashboarding tools and data modeling tools experience are key* · *Expert skills with Cube, Snow Flake and Star Schemas* *Regards,* * Ning* *West Coast Consulting, LLC** **Work – 949 743 0065 x 202 • Direct -949 800 5351* *Fax – 714 844 9091 * *ning**@westcoastllc.com* <r...@westcoastllc.com>* * *www.westcoastllc.com* <http://www.westcoastllc.com/>** -- You received this message because you are subscribed to the Google Groups "SAP or Oracle Financials" group. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. To unsubscribe from this group, send email to sap-or-oracle-financials+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sap-or-oracle-financials?hl=en.
