POSITION #1 BI DW ARCHITECT

Job Description

The Business Intelligence Architect and Developer is responsible for designing, developing, documenting, and maintaining the overall Business Intelligence platform required to address and support Business Reporting and Data Analytics needs at Guidewire.

This position is responsible for assessing Data Analytics requirements, defining the overall Data Model, Data Dictionary and Standards, designing the technical architecture, developing needed databases, cubes and ETLs, as well as developing all presentation layer components of the BI architecture.

The ideal candidate must have a strong business acumen, excellent analytical and development abilities, great written and verbal communication skills, and a team player.

He/she should be able to envision the big picture at the same time be hands-on and be comfortable with team work.

Essential Duties and Responsibilities

• Collaborate with stakeholders to understand business requirements and define appropriate solution architecture in line with overall IT strategy and systems architecture

• Define and document data model, data dictionary and standards

• Design, develop and maintain various Data Marts and Cubes using dimensional design techniques based on Microsoft SQL Server technologies

• Define and document data mapping between source and target

• Develop, document and maintain various ETL processes into and out of data marts using Microsoft BI Integration technologies

• Develop highly interactive and intuitive Reports and Dashboards

• Performance Tuning of existing data structures

• Define and implement appropriate User's permissions and Security Access to Data Analytics

Qualifications

• Technically proficient in data modeling, data manipulation, architecture and design of data marts and warehouses.

• Experience in architecture, design and support of Data Warehouse projects

• Expertise and experience in the development and support of OLAP cubes, data mining and data analysis tools.

• Skilled in Data Warehouse Design including logical and physical star schema data models, extraction/transformation of data.

• Skilled in SQL, Database and Transaction processing concepts, knowledge of query analysis tools and performance optimization of queries

• Exceptional skills and proven ability in the design and development of stored procedures, procedural SQL, SQL Server DTS, SSAS, SSRS and SSIS.

• Strong problem solving & analytical skills

• Strong written and verbal communication skills

• Have a "can do" attitude, great listening skills and effective delivery of technology solutions

• Ability to present ideas in business-friendly and user-friendly language

Education & Exprience

• BS degree in Computer Science/MBA preferred

• 10+ years working with multiple database platforms.

• 10+ years of experience in MS SQL (2000/2005/2008/2008 R2) Server with SSAS, SSRS and SSIS.

• 8+ years experience in data modeling, analysis and data migrations

• 5+ years hands-on experience with Data Warehouse implementations (covering all areas from architecture, design, development [data extraction/transformation/loading], reporting & analysis, audit trails and checks for data marts/warehouses).

• 5+ years experience in producing dashboards and interactive analytical reports using Qlik, Tableau or Microsoft BI technologies