DBA / SW Engineer II-(Advanced SQL) Vertafore, Inc.
THIS JOB HAS EXPIRED This position will be responsible for the installation, administration, development, maintenance, capacity planning, performance tuning, and troubleshooting for the Customer Support data mart (Currently MS SQL). The SW ENg II will also work closely with various levels of leadership to develop reports and reporting interfaces to leverage data stored in the data mart.
This role will also lead on the development of internal Customer Support utility applications and/or services including Web Services. While the role focuses on database there is expected to be a significant development component. This is a broad role and requires an individual with a diverse skillset.
Who Are You?
You are an expert with building, configuring, and administering sql databases.
You have the skillset needed to implement OLAP and OTLP data modeling and schema design.
You have previous experience with applications integrations architecture and development using multiple integration methods including xml and web services methodologies.
You enjoy working with a functional requirements document to develop a technical solution.
You are passionate about working with a Functional Analyst to deliver KBIs & Reports required by the business at various levels including BI Dashboard modeling and design as well as canned or adhaoc reports as required.
Qualification And Requirements
Advanced Microsoft SQL, Excel, PowerPivot, Visio, and Access skills.
Ability to program and debug in multiple programming languages (Java, C#, C++, VP, .Net, sql)
Knowledgeable in database design, concepts, methods, and data warehousing best practices including dimensional modeling and ETL processes.
Experience with third-party ETL tools (Informatica preferred)
Ability to develop reports using various reporting and/or business intelligence tools including Microsoft Excel, Access, Business Objects, Crystal Reports, Microsoft Reporting Services, Tableau, and OLAP cubes and potentially OBIEE.
Knowledge of data access methods under MS Windows environment including using API libraries, ODBC connectors, or web development/XML/WebServices
Saas Based systems integrations (SalesForce.com, CRM On Demand etc)
Oracle Fusion Middleware / SOA Integration experience and/or the desire to learn these tools is a plus
Vertafore Company Overview
Vertafore, Inc. is a leading provider of software and information to the insurance industry including independent agents, brokers, MGAs, carriers and reinsurers. For more than 30 years, Vertafore has leveraged a unique industry presence to deliver meaningful solutions?powerful technology, critical information and robust insights to help organizations effectively respond to business challenges and capture new opportunities. Vertafore solutions have helped more than 17,000 customers and 500,000 end users gain a competitive advantage to accelerate their business performance.
Currently, over 1,200 employees nationwide, with continued growth plans well into the future. Our corporate headquarters are in Bothell, WA with offices nationwide. We offer competitive compensation and benefit packages along with 18 days PTO/10 paid holidays, free parking and company sport teams and much more. A big advocate of training, development and promoting from within, we have a vested interest in our employees.
Vertafore is privately held by TPG Capital, the global buyout group of TPG, a leading private investment firm with a long-standing global presence. Founded in 1992, TPG Capital has $48 billion of assets under management and has extensive experience with global public and private investments executed through leveraged buyouts, recapitalizations, spinouts, growth investments, joint ventures and restructurings.
||Bothell, WA |
THIS JOB HAS EXPIRED