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.
Job Summary:
The Data Warehouse Architect are responsible for handling the delivery of data and information relating to the business intelligence of the organization for which they work. The architect is responsible for two primary area: ETL and Business Intelligence analytic solutions. This role requires the person be an experienced leader with deep hands-on experience in customer analytics, statistical analysis, and predictive modeling.
Essential Duties and Responsibilities:
70% - Data Management and Analytics:
Partners with stakeholders, process specialists, and users to elicit and document business requirements for both data warehouse and analytics design
Partners with business teams to define and document business requirements for new data warehouse facts and dimensions and analytic reports.
Designs, develops, and maintains Data Warehouse extract, translate, and load tools.
Designs, develops, and maintains reports and analytical tools.
Performs quality assurance against data warehouse databases and reports.
Performs ongoing monitoring and refinement of Data Warehouse tables.
Performs ongoing monitoring and refinement of reports.
Provides technical support for existing reports, dashboards, or other tools.
Identifies and analyzes errors and inconsistencies in the data and provides timely resolutions.
Translates data results into written reports, tables, graphs and charts to convey information to management.
Creates written communication materials that effectively summarize findings and support recommendations.
Creates ad hoc reports and views on a frequent basis to assist management in understanding, researching, and analyzing issues.
Teaches and advocates the use of business intelligence tools across levels of the organization.
Ability to self-manage projects and potentially manage staff, as needed.
Handle Data Warehouse help desk tickets as assigned.
10% - M&A Migration:
Participate in discussion and collaboration of due diligence and evaluation of systems.
Participate in the development integration timeline and communications.
10% - SPC LOB Technology Initiatives:
Participate in cross-organizational teams to develop solutions meeting the needs of SP&C.
Secondary Responsibilities:
10% - Other duties as assigned.
Qualifications:
Bachelor's degree in data analytics, data science, computer science, management information systems, finance, statistics, or related fields. MBA or advanced degree preferred.
15+ years' experience in in data warehouse design, ETL, and business and marketing analytics.
Deep knowledge of insurance industry; MedMal a bonus.
Previous experience leading a team preferred.
Advanced analytical skills and attention to detail.
Strategic, intellectually curious thinker with focus on outcomes.
Advanced knowledge of Data Warehouse architecture including BI Practices, Data structures, and data modeling.
Advanced knowledge of DW ETL tools and utilization.
Advanced knowledge of SQL, Oracle, and MS SQL Server.
Advanced knowledge of MS PowerBI Analytical platform, including SSRS.
Proficient in SQL for use in business analysis and testing efforts.
Ability to manage multiple projects at the same time.
Ability to work with other senior and junior associates; provide coaching to others on the team.
Proven ability to quickly learn new applications, processes, and procedures.
Able and willing to collaborate in a team environment and exercise independent judgment.
Excellent interpersonal skills including verbal and written communication, teamwork, and issue resolution.
Experience presenting findings and actionable recommendations.
Professional image with the ability to form good partner relationships across functions.
#LI-Remote
Position Salary Range$96,465.00 - $159,184.00The salary range displayed represents the entirety of the pay grade for this position. Most candidates will start in the bottom half of the range. Factors that may be used to determine your actual salary include your specific skills, how many years of experience you have, your location and comparison to other team members already in this role.