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.