Data Architect with experience in Snowflake and Insurance Domain (P&C)

Overview

Remote
Depends on Experience
Contract - W2
Contract - Independent
Contract - 12 Month(s)

Skills

CMMI
Collaborate
Data Architect
Data ArchitectLocation
Data Governance
Data mapping
Document Data
ETL
Insurance
JSON
XML
data Modeling
data engineering
data integration
data lineage
data management
data migration
data transformation
data warehousing
system design
system integration
transformation

Job Details

Position : Data Architect

Location : Cincinnati OH / Can work remotely

Duration : 12 Months

Note: We need Data Architect with experience in Snowflake and Insurance Domain (P&C)

Responsibilities

  • Provide partnership, domain expertise (P&C Insurance), direction, and accountability for strategic architecture plans, system design, and implementation standards for the data domain.
  • Lead efforts to ensure data capabilities are operating efficiently, accurately, and with high quality.
  • Collaborate with programs & projects to understand data dependencies, anticipate risks, and identify opportunities. Guide data project decisions based on the direction of data domain roadmap.
  • Contribute data domain expertise to feasibility, complexity assessments of potential future initiatives including data domain analysis.
  • Develops an integrated view of data capabilities and processes, using a repeatable approach, cohesive framework, and available industry best practices and techniques.
  • Provides consulting and makes recommendations to tackle data transformation initiatives, help mature existing data capabilities, or enable new data capabilities.
  • Facilitate the process of defining and publishing data standards, best practices, data capabilities, and data roadmap, synchronized with the overall enterprise future state architecture.
  • Collaborate in creation of conceptual and logical architecture and models following the enterprise guidance to describe a particular domain of data and use these models to inform the physical design of data-related projects.
  • Co-develop data life cycle governance framework including standards, patterns, and controls.

Deliverables

  • Domain Analysis Specification & Findings
  • Clearly define the data domain and its confines
  • Leverage an organizationally accepted and standardized framework (like CMMI) to evaluate and grade maturity within the defined data domain.
  • Identify opportunities for investment along with specified benefits for investment, including the data capability roadmap.
  • Document Data Governance Capabilities (co-create)
  • Data and attribute definitions and master dataset definitions within the data domain.
  • Documentation of domain definition governance processes and platform.
  • Documented capabilities and coverage for data lineage within the data domain.
  • Diagrams overall data landscape within a data domain, including current and future state data flows.
  • Data mapping document (initiate/support)
  • Assist in the creation and delivery of Conceptual & Logical Data Model by providing business level understanding of relationships to other domains and business transactions across the enterprise.

Qualifications

  • Must have P&C domain experience.
  • Minimum eight years of relevant experience as a data architect building large-scale data solutions.
  • Experience in architecting and large data modernization, data migration, data warehousing experience with cloud-based data platforms (like Snowflake)
  • Experience with defining and operationalizing data strategy, data governance, data lineage and quality standards.
  • Extensive knowledge of data engineering, data integration and data management concepts (i.e. APIs, ETL, MDM, CRUD, Pub/Sub, etc.)
  • Experience with data Modeling.
  • Experience with structured and hierarchical datasets (i.e. JSON, XML, etc.)
  • Engineering experience with large scale system integration and analytics projects.