Data Architect

Society Insurance Company•Fond du Lac, WI

18d

About The Position

Society Insurance is seeking an experienced Data Architect to join its Information Technology team. The role leads the design and implementation of enterprise data architecture, translating business and data strategy into scalable, governed, high-performing data platforms and solutions. It is accountable for delivering the data architecture vision and enabling execution of data strategy, including data models, pipelines, platforms, and integration patterns supporting analytics, reporting, and operational use cases. The Data Architect partners with business and IT stakeholders to ensure data is trusted, accessible, and aligned with enterprise architecture standards, while driving modernization and continuous improvement of data capabilities. The position offers flexible remote or hybrid work scheduling for candidates located in one of the nine states where Society conducts business: Colorado, Georgia, Illinois, Indiana, Iowa, Minnesota, Tennessee, Texas, or Wisconsin. Home-office, hybrid, and remote opportunities are available.

Requirements

Bachelor’s degree in computer science, engineering, or a related field.
At least 8 years of experience in data architecture, data engineering, or data platform design.
Strong experience designing and implementing data pipelines, data lakes, and data warehouses.
Experience with cloud data platforms such as Azure Synapse, Data Factory, Fabric, or Databricks.
Deep understanding of data modeling, ETL/ELT patterns, and data integration.
Experience implementing data architecture aligned with business and analytics needs.
Strong collaboration skills across business, architecture, and engineering teams.
Expertise in one or more of the following, with versatility to grow in other areas: Microsoft data tools and technologies (SQL, SSIS, TSQL); Azure SQL Databases; Azure Blob storage; Azure App Services; Microsoft Azure Synapse, Data Factory, and Fabric; Microsoft business intelligence tools (Power BI); data modeling (Idera ERStudio); data warehouse design; and data analytics concepts.
Strong organizational skills.
Demonstrated success in managing and/or completing projects.

Nice To Haves

SAFe Agile Delivery experience is highly desirable.

Responsibilities

Translate enterprise data strategy into architecture, platforms, and implementation roadmaps aligned with business and analytics needs.
Engage business and IT stakeholders to gather requirements and define end-to-end data architecture solutions.
Define and govern enterprise data architecture standards, including data models, pipelines, integration patterns, and platform design.
Design and build scalable data platforms and pipelines, including data lakes, warehouses, and cloud platforms, to support analytics and reporting.
Establish and enforce logical, physical, and dimensional data modeling standards across systems and domains.
Design and optimize ETL/ELT data ingestion, transformation, and integration patterns to ensure reliable data movement across systems.
Ensure data architecture supports data quality, lineage, metadata, and governance frameworks aligned with enterprise standards.
Collaborate with architects and engineers to define architecture enablers, guide solution design, and support implementation.
Work with data engineering and Agile teams to ensure architecture is implemented effectively across delivery cycles.
Lead evaluation and selection of data technologies, tools, and platforms, including proof-of-concepts.
Develop and maintain data architecture roadmaps for modernization, consolidation, and performance optimization.
Drive modernization of legacy data and reporting platforms to improve scalability, performance, and usability.
Ensure alignment between data, application, and infrastructure architecture.
Participate in Agile/PI Planning to align teams on shared technical direction and standards.
Act as a technical expert and leader, mentoring teams and driving adoption of data architecture and engineering best practices.