Proassurance - Remote, OR
posted 3 months ago
An exciting opportunity exists to join the ProAssurance family of companies! We are a specialty writer of professional liability, products liability, and workers' compensation insurance. With approximately 1,000 team members operating in all 50 states, we are well-positioned to offer career opportunities to individuals interested in professional growth. This position supports our medical professional liability line of business and can be fully remote in the continental United States. Please note we are not offering sponsorship now, or in the future, for this position. The Data Warehouse Architect is responsible for handling the delivery of data and information relating to the business intelligence of the organization. This role encompasses two primary areas: ETL (Extract, Transform, Load) and Business Intelligence analytic solutions. The ideal candidate will be an experienced leader of projects with deep hands-on experience in customer analytics, statistical analysis, and predictive modeling. Essential duties include managing data and analytics, where the architect partners with stakeholders, process specialists, and users to elicit and document business requirements for both data warehouse and analytics design. The architect will also design, develop, and maintain Data Warehouse ETL tools, reports, and analytical tools, ensuring quality assurance against data warehouse databases and reports. The role requires ongoing monitoring and refinement of Data Warehouse tables and reports, providing technical support for existing reports, dashboards, or other tools, and identifying and analyzing errors and inconsistencies in the data. Additionally, the architect will participate in M&A migration discussions and collaborate on the evaluation of systems, as well as engage in SPC LOB technology initiatives to develop solutions meeting the needs of SP&C. This position may also involve teaching and advocating the use of business intelligence tools across levels of the organization, managing projects, and handling Data Warehouse help desk tickets as assigned.