Data Architect (Informatica)

An exciting opportunity exists to join the ProAssurance family of companies!

Our mission is powerful and simple: We protect others. Choosing a place to apply your talents is an important decision for anyone. You have plenty of options. Why choose ProAssurance?

At ProAssurance, we sell a pledge, and that pledge is delivered by our team members. We are seeking individuals who value integrity, leadership, relationships, and enthusiasm—and want to build their career with a great company where they can be their authentic self and feel valued, recognized, and rewarded for their contributions. ProAssurance specializes in healthcare professional liability, products liability for medical technology and life sciences, legal professional liability, and workers' compensation insurance. We are an industry-leading specialty insurer operating in all 50 states, with in-office, hybrid, and remote job opportunities around the country.

This position supports our medical professional liability line of business and can be fully remote in the continental United States.

Informatica experience is a must.

We may consider filling the position at a different level for candidates with less experience. Compensation will be commensurate with the experience level.

Please note we are not offering sponsorship now, or in the future, for this position.

The Data Warehouse Architect will be responsible for defining and delivering data solutions and contribute to the development and implementation of IT business analytics plans in line with the overall strategy of IT and the business. The architect is primarily responsible for Extracting, Transforming and Loading (ETL) data from the core systems to the Data Warehouse for our 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 data warehouse design
• Partners with business teams to define and document business requirements for new data warehouse facts and dimensions
• Designs, develops, and maintains Data Warehouse extract, translate, and load tools
• Performs quality assurance against data warehouse databases
• Performs ongoing monitoring and refinement of Data Warehouse tables
• Identifies and analyzes errors and inconsistencies in the data and provides timely resolutions
• Creates written communication materials that effectively summarize findings and support recommendations
• Creates ad hoc queries and views on a frequent basis to assist management in understanding, researching and analyzing issues
• 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 Initiatives

10% SPC LOB Technology Initiatives

• Participate in cross-organizational teams to develop solutions meeting the needs of SP&C

Secondary Duties and 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 data warehouse design, ETL, and business and marketing analytics with 10 of those years in Informatica IICS (cloud service applications or SQL in Oracle and MS SQL Server databases, including, but not limited to: queries, stored procedures, functions, etc.
• 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
• 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

We are committed to providing a dynamic and inclusive environment where everyone can do their best work and grow personally and professionally.

For that reason, we partner with The Predictive Index (PI) – an organization equally committed to improving the working lives of people, to help us hire the best talent by providing additional insight about one’s work style. 

The position you applied to requires completion of two assessments prior to being scheduled to interview with a hiring manager. Completion of the assessments is not required in order for your application to be reviewed and to speak with a Talent Acquisition team member. These assessments are Behavioral and Cognitive (internal candidates will only receive the Behavioral assessment), and each assessment takes less than 12 minutes to complete.

After submitting your application, you will receive two emails from The Predictive Index inviting you to complete each of these assessments (please check your SPAM or Junk email folder if you do not see these emails in your inbox).

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.

Build your career with us and enjoy access to a best-in-class benefits program.