Systems Analyst - BI & Database Development

Vertafore, Inc. is the leading provider of specialized software, services and information for the U.S. insurance industry, delivering solutions to facilitate productivity and profitability for retail agents, wholesalers, carriers and other key players within the industry. Vertafore’s businesses are primarily centered on the “independent agent” distribution channel, and provide Enterprise-level solutions to over 15,000 customers and 150,000 end-users. The principal business units under the Vertafore umbrella are AMS services, BenefitPoint, SilverPlume and ImageRight. Vertafore is growing consistently in revenue and profitability, and today has over 1000 employees in 14 business locations across the United States.

Position Summary

Support and manage all technical aspects of the BI/Analytics tools (Cognos TM1/Applix) at Vertafore
Manage the creation and maintenance of data marts and data warehouses for various departments.
Develop and manage integration plans for disparate systems across the Vertafore environment

Job Responsibilities

Provide guidance on best practices for selected BI toolset based on a strong understanding of data warehouse and business intelligence concepts
Manage the deployment of Cognos TM1 for the FP&A group. Develop plans to expand tool to other areas of business
Provides hardware recommendations for scaling and future projects
Acts as release/test lead for monitoring and ensuring database and OLAP cube changes are managed effectively
Work closely with the ERP team to develop plans for transactional data extraction and loads into to data warehouse
Develop stored procedures, views and other objects as required for data analysis for various departments
Develop technical documentation for all assigned work
Interact with department leads to define and develop analytical programs for reporting
Bachelor's degree in Computer Science or commensurate work experience
5+ years of development experience in Business Intelligence and Data Warehouse tools
Strong programming experience in relational databases (SQL server/Oracle)
2+ years of data analysis experience required
Integration experience with Office Products highly desired
Thorough technical knowledge in the following areas: Cubes, ETL, Metadata administration, Dashboard development, etc.
Prior work experience in establishing departmental data marts for corporate analysis and reporting
Excellent communication and interpersonal skills required



Vertafore is an Equal Opportunity Employer. We offer excellent salary, bonus program, benefits, and a convenient Bothell location
To Apply for this position, please CLICK HERE