Cycle3 IT Staffing is seeking a Sr. BI Data Warehouse Developer. The Sr. BI Data Warehouse Developer should be recognized as a subject matter expert for specific areas of development for Business Intelligence and Data Warehousing. This position will focus on the design and delivery of: Dashboards, Reports, User Interfaces, and associated database design and platforms using Microsoft technology, applications and tools. As a BI Data Warehouse specialist, you will act as the technical lead for our data warehousing projects to solve some of the toughest challenges in business intelligence today. The successful candidate should possess deep technical expertise in database design, ETL, reporting and analytics and will have previous consulting experience utilizing a structured delivery methodology. The candidate should also demonstrate general management competences including analytical problem solving, customer focused innovation, project management and technical excellence. The requirements listed below are representative of the knowledge, skill and ability required. General areas of responsibility include:
Leads projects that design and deliver data models, Analysis Services/OLAP cubes, Reporting Services, and dashboards in response to business requirements.
All aspects of BI including technical, process and organizational design.
Communicates with business users to design and deliver dashboards, reports and other user interfaces that drive business value and efficiently and effectively leverage the use of data.
Design and develop the architecture for all data warehousing components (e.g. tool integration strategy; source system data ETL strategy. Data staging, moving and aggregation; information and analytics delivery; and data quality storage)
Code management, peer review and deployment of BI solutions.
Works with a variety of internal and external users to develop data models and performs data design reviews with the rest of the project team as appropriate.
Assists database administrators with the development of the physical database model and database design, ensuring that data designs meet overall business information requirements and each application’s functional requirements.
Maintains expert knowledge of data warehouse, data mart models and assists in training others in data management methodologies and techniques.
Develops and maintains metadata for data warehouse and reporting systems.
Provides Microsoft based Services and Support (SSIS, SSAS, SSRS, etc)
Participation in proposal development and client presentations.
Qualifications Technical knowledge and documented experience including:
Hands on leadership in defining and implementing end to end full stack BI solutions.
A minimum of 5 years of experience with data warehouse development lifecycles or in Business Intelligence.
Strong relational database experience in logical and physical data models and data marts.
Strong experience with relational and multidimensional data warehouse, business intelligence concepts, capacity planning is required.
In-depth knowledge and experience of Microsoft SQL Server 2005/2008 and Oracle 9i/10g is required.
Experience with SQL Server Analysis Services, Reporting Services, and Integration Services (formerly DTS) is a must.
Strong experience in OLAP/Cube design and build (preferably Microsoft Analysis Services) is required.
Experience with other OLAP, ETL, and BI tools is a plus.
Knowledge of the use of source control systems including Subversion and VSS
Ability to work with clients to understand their business requirements and to assist with the development and design of effective solutions to meet the client’s needs.
Strong verbal and written communication skills
Ability to multi-task and meet strict deadlines
Work in Insurance environment a plus.
Ability to work in a team environment
BS Degree in computer related field or equivalent experience
To apply for this job email your details to brian@cycle3it.com