Enterprise Data Specialist - Insurance Domain

We are seeking an experienced Enterprise Data Specialist to design, model, and architect data solutions for our enterprise data warehouse. This strategic role focuses on building robust data models and seamless integration across insurance and reinsurance systems to drive operational excellence and support our industry-leading data warehouse development.

Req.#900216276

Responsibilities

Data Architecture & Design: Collaborate with business stakeholders and IT teams to define, document, and architect comprehensive enterprise data warehouse solutions

Data Integration: Source and integrate data from multiple Insurance and Reinsurance Policy, Treaty, Claims, and financial systems

Mapping & Modeling: Design and implement Source to Target mappings optimized for high-volume data integration; create logical and physical data models on SQL Server platforms

Development Collaboration: Partner with development teams to ensure accurate translation of mappings into code and validate post-deployment changes

Data Strategy: Develop data collection and ingestion strategies; write SQL-based solutions to validate data accuracy and integrity

Reporting Support: Analyze and design enterprise data models for optimal reporting; support reporting teams in understanding and utilizing the data warehouse effectively

Performance Optimization: Troubleshoot and optimize SQL and Informatica mappings, stored procedures, and develop SQL Server views for reporting and dashboards

Requirements

10+ years of data architecture and design experience with enterprise data warehouse development

3+ years of experience within the Insurance and Reinsurance domain

Advanced experience extracting data from Insurance applications

Extensive knowledge of Data Warehousing, ETL, and BI Architectures, concepts, and frameworks

Proficiency in creating and tuning Semantic layer Reporting Views

Experience with RDBMS platforms (SQL Server, DB2, etc.) and DDL generation

Knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-CD & SAP FI-GL applications

Nice to have

Strong interpersonal, written, and verbal communication skills

Proven ability to work effectively in team environments

Excellent organizational and analytical skills

Experience facilitating data discovery sessions with business subject matter experts

We offer

Extended Healthcare with Prescription Drugs, Dental and Vision Insurance, and Healthcare Spending Account (Company Paid)

Life, Critical Illness, and/or Accidental Death & Dismemberment Insurance.

Employee Assistance Program (Company Paid)

Long-Term Disability

Registered Retirement Savings Plan (RRSP) with company match

Employee Discounts

Unlimited access to LinkedIn learning solutions

EPAM is a leading global provider of digital platform engineering and development services. We are committed to having a positive impact on our clients, our employees, and our communities. We embrace a dynamic and inclusive culture. Here you will collaborate with multi-national teams, contribute to a myriad of innovative projects that deliver the most creative and cutting-edge solutions, and have an opportunity to continuously learn and grow. No matter where you are located, you will join a dedicated, creative, and diverse community that will help you discover your fullest potential.

Engineer the Future with a Career at EPAM

This posting includes a good base salary range EPAM Canada would reasonably expect to pay the selected candidate. Individual compensation offers within the range are based on a variety of factors, including, but not limited to, experience, credentials, education, training, the demand for the role, skillset, and overall business and local labour market considerations. Most candidates are hired at a salary within the range disclosed. Salary range: CA$70-CA$100 per hour. In addition, the details highlighted in this job posting above are a general description of all other expected benefits and compensation for the position.

EPAM Canada welcomes and encourages applications from candidates with disabilities. Please contact WFA Human Resource CA WFAHRCA@epam.com if you have questions in this regard, or if you require an accommodation to complete the application process. Click here to review EPAM’s Accessibility for Ontarians with Disabilities Accessibility Policies and Multi-Year Access.

Show more Show less