Come grow with James River Insurance!

James River Insurance is an excess and surplus lines segment of James River Group Holdings, Ltd. and operates on an approved non-admitted basis in 50 states and Washington, DC. Since 2003, James River has provided thousands of commercial property and casualty customers with innovative and creative solutions for particular insurance needs.

At James River Insurance, we are committed to providing a stable and rewarding work environment supported by our Core Values and Guiding Principles: Integrity, Accountability, Innovation, Customer Service, Communication, and Teamwork. We are proud of our recent national recognition as a 2021 Top Workplaces USA award.

**Job Summary**

Under moderate to limited supervision, the Data Warehouse Technical Analyst II, collects, analyzes, mines and helps the business leverage data stored in data warehouses.

**Duties and Responsibilities**

* Continuously exhibit and uphold Core Values of Integrity, Accountability, Communication and Teamwork, Innovation and Customer Service

* Creates data design, database architecture, and data repositories

* Design, maintain and provide support for data warehouse systems and related data marts

* Evaluate new data warehouse applications for adoption

* Perform complex data analysis

* Design intermediate data transformation pipelines

* Improve performance of existing applications

* Ensure data accuracy

* Intake and research business information needs and develop solutions

* Identify system requirements for assigned projects

* Execute data extraction procedures

* Fulfil requests for data reports of high complexity

* Develop diagrams or flow charts of system operations

* Assist on projects of high complexity

* Train and mentor Data Warehouse Technical Analysts I

* Demonstratecontinuous learning; participate in hackfests, technical communities and technical conferences

**Knowledge, Skills and Abilities**

* Knowledge of relational database theory

* Intermediate to advanced proficiency in all of the below:

SQL skills across multiple data platforms (SQL Server, Oracle, MySQL, Postgres SQL, MongoDB)

Data modeling (OLTP, star-schema, snowflake-schema)

Cloud-based data services (Azure Data Lake, Azure SQL Database, Synapse, Azure Analysis Services, Azure Data Catalog, Azure Databricks, AWS/GCP technologies)

Custom ETL design, implementation and maintenance using data orchestration tools (Azure Data Factory, AWS Glue, SSIS, Pentaho, Informatica, SAP Data Services)

Reporting, data presentation and dashboarding skills (SSRS, Tableau, Sisense, Power BI)

Producing technical designs (artifacts) using tools like Visio

General purpose programming language (Java, C/C /C#, Python)

Modern DevOps practices (Git, CI/CD)

Agile software development (Azure DevOps/VSTS)

* Strong knowledge of the P&C insurance industry

* Research, analysis and problem-solving skills

* Ability to lead teams and projects

* Ability to exercise sound judgement in making critical and complex decisions

* Ability to build effective relationships with business partners and influence decisions

* Self-starter who works well independently and in a team environment

* Ability to convey technical process information in a clear and concise manner

* Ability to manage multiple tasks and projects effectively

* Ability to identify and make process and procedure improvement recommendations

* Developing business acumen and forward thinking-skills

* Strategic thinker with creative problem solving abilities

* Attention to detail

* Continuous learning style

* Active listening skills

* Excellent written and verbal communication skills

**Experience and Education**

* High School Diploma required

* Bachelors Degree in related field (IT, IS, Computer Science) preferred, or equivalent combination of education, training and experience

* Advanced Degree in related field (IT, IS, Computer Science) preferred

* Minimum of four years of related experience (software development/engineer experience within data analytics, business intelligence or application development using Microsoft technologies) required

* Previous experience with Guidewire DataHub and InfoCenter highly preferred

**Qualifications may warrant placement at a different job level*