Data Modeler and Big Data Solution Designer

  • 37463
  • Non-Life - Data Science
  • |
  • Ontario, Canada
  • |
  • Jun 2, 2020
Insurance
RESPONSIBILITIES
  • Work will primarily focus on creating & developing data models.
  • Work will also encompass creating & developing solution designs for data acquisition/ingestion of varied data sets, data integrations & data warehouse/marts.
  • Collaborate with business partners, product owners, stakeholders, functional experts, business analysts, IT architecture, and developers to design data models and solution designs to meet requirements.
  • Lead solution design discussions with internal and external stakeholders as relevant.
  • Prepare data model & solution design documentation.
  • Responsible for monitoring and ensuring that solutions adhere to enterprise data governance & design standards.
  • Assist in troubleshooting application problems where data, ETL, and reporting are integral elements.
  • Responsible for monitoring and ensuring the ongoing data quality within the data model.
  • Ensure a consistent approach and implementation of processes and technology in designing solutions.
  • Own the data definitions for all data tables and maintain data lineage.
  • Work with DBAs on imposing database constraints, indexes, performance tuning for the data models.
  • Work with Data Engineers to ensure that development adheres to best practices and ensure that quality is built-in.
  • Own the data models for various zones in the Enterprise Data Hub like post ingestion, integration, data warehouse/marts.
  • Communicate clearly and effectively during project execution on data models & solution designs aligned to data strategy.
  • Understand and articulate interdependencies, constraints of the data model to Data Engineers, project teams and business teams.
  • Collaborate with other IT teams, Architecture and third party vendors as required.
  • Understand the functional & technical aspects of Enterprise Data Hub, data integrations, data warehouse/marts.
  • Write queries to extract data from the Enterprise Data Hub, data warehouse/marts for analysis.
  • Work in an Agile delivery framework to evolve data models and solution designs to deliver value incrementally.
QUALIFICATIONS
  • 10+ years of experience building data models for data lakes, data warehouses & data marts.
  • 5+ years of experience designing solutions for data lakes, data integrations, data warehouses/marts.
  • 5+ years of experience in Property & Casualty Insurance domain.
  • Strong knowledge/experience with data technologies & tools.
  • Excellent knowledge and experience in ETL with Informatica product suite.
  • Knowledge/experience in Cloud Data Lake Design - pref AWS technologies like S3, EMR, Redshift, etc.
  • Experience implementing Data Governance principles.
  • Experience in Agile and DevOps model for Data Application design, implementation and operations.
  • Excellent background working with multiple databases.
  • Strong application design and development skills.
  • Excellent communication skills with the ability to communicate complexity in both technical and user-friendly language.
  • Understanding of reporting/analytics tools.
  • Experience with ACORD, IIW or SAS DDS data models will be an asset.
  • Strong data analysis and SQL skills to extract data from multiple zones.
  • Self-starter with experience working in a fast-paced agile development environment.
  • High level of flexibility with strong ability to lead others through process, system and transformation change.
  • Strong leadership skills and ability to lead by example and coach more junior team members.
  • Outcome focused with strong decision making and critical thinking skills to challenge the status quo which impacts delivery pace and performance.
  • Demonstrated ability to rapidly adjust to new contexts, technologies, trends.
  • Strong commitment to continuous delivery of improvements and efficiencies.
  • Superior organizational skills including the ability to balance and independently manage workload across multiple concurrent priorities.