Intact Insurance Specialty Solutions · 9 hours ago
Architectural Consultant (Hybrid or Remote)
Canton, MA
Full-time
Hybrid
Senior Level
$142K/yr - $188K/yr
7+ years expIntact Insurance Specialty Solutions is a leader in the specialty insurance market, dedicated to providing customized solutions and exceptional service. They are seeking an Architectural Consultant to lead the full data systems life cycle, design high-performance data platforms, and ensure compliance with regulatory requirements while collaborating with cross-functional teams.
FinanceFinancial ServicesInsurance
Responsibilities
Works closely with business partners, and team members to understand business requirements that drive the analysis and design of quality technical data solutions. Solutions must be aligned with Business’s and IT’s overall strategies, while complying with the organization’s data architectural and business standards
Proposes and supports the implementation of data systems and technology plans, data architectures (Current state, Future state) and standards in order to meet the company’s strategic goals
Makes recommendations towards the design and development of data architecture, infrastructure, and business systems
Leads the data architecture part of data systems and technology projects, in collaboration with other team members
Develops and maintains the data systems and technology models and standards for a project
Involved in the significant parts of the data systems life cycle and is responsible for designing, implementing and supporting data solutions that is delivered on time and within budget
Collaborates effectively with others in a variety of work settings. This involves helping to educate others on their area of work, understanding the issues/concerns of other areas, and working together to solve problems, which may cross numerous boundaries within the organization
Define and implement end-to-end data architecture for Data Solution (CDC, Data Lake, Date Lakehouse, Data Mart) ensuring scalability, security, and performance
Design data models, pipelines, and frameworks to support Medallion Architecture
Develop high-availability and fault-tolerant data processing architectures that handle large-scale, real-time transactions
Architect and implement big data solutions using cloud data technologies including Apache Spark, Databricks, or Snowflake
Leverage cloud platforms (Azure preferred) for Data Acquisition and Data Integration - data storage, transformation, and analytics
Design near real-time streaming data architectures using Kafka or similar technologies for handling real-time transaction
Ensure data integrity, data quality, data lineage, data cataloging, security, and privacy across all data systems
Implement data governance frameworks and compliance measures aligned with regulations like GDPR, CCPA, etc
Establish audit trails, access controls, and data encryption to meet security and regulatory standards
Drive solutions to manage master data, reference data and third-party data for accurate, effective and timely business insights
Optimize query performance, indexing/partition strategies, and distributed computing for large-scale datasets
Automate ETL/ELT pipelines, data validation, and reconciliation processes to improve efficiency and accuracy
Work closely with business partners and cross-team members to define data requirements and align technology solutions with business objectives
Manage backlog through execution and delivery
Guide and mentor data engineers, ensuring best practices in data architecture, engineering, and security
Engage with executive leadership and stakeholders, providing technical recommendations and strategic insights
Qualification
Required
Bachelor's degree in computer science, Information Systems or another related field OR equivalent work experience
7-12 years of experience
Hands-on data modeling, data Solutions development and data architecture experience in the data technologies used by the company – SQL Server, T-SQL, SSIS, SSRS, SSAS, Azure Data Factory, Azure Databricks, Azure DB for PostgreSQL, Power BI
Preferred
Experience with big data architectures, cloud platforms, and data security best practices
Experience with Apache Spark, Databricks, or Snowflake
Experience with Azure cloud platforms for Data Acquisition and Data Integration
Experience designing near real-time streaming data architectures using Kafka or similar technologies
Experience implementing data governance frameworks and compliance measures aligned with regulations like GDPR, CCPA
Benefits
Comprehensive medical, dental and vision insurance with no waiting period
Competitive paid time off programs
401(k) savings and annual contributions of up to 12% of annual salary
Mental health support programs, life and disability insurance, paid parental leave and a variety of additional voluntary benefits
Company
Intact Insurance Specialty Solutions
Intact Insurance Specialty Solutions offer a range of specialty insurance products sold through independent agencies and wholesalers.
1001-5000 employees
Funding
Current Stage
Public CompanyTotal Funding
unknown2017-05-02Acquired
2006-11-09IPO
Leadership Team
Jeff Bellmont
Deputy SVP, US Chief Claims Officer
Carolyn Koutsaftis, SHRM-SCP
HR Business Partner
Recent News
2025-08-21
Company data provided by crunchbase