Data Architect

Society Insurance Company

$100K — $130K *
Enterprise Technology
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in computer science, engineering, or related field.
  • 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 (Azure Synapse, Data Factory, Fabric, Databricks, etc.).
  • Deep understanding of data modeling, ETL/ELT patterns, and data integration.
  • Strong collaboration skills across business, architecture, and engineering teams.
  • Expertise in Microsoft data tools and technologies, including SQL and Power BI.

Responsibilities

  • Translate enterprise data strategy into architecture and implementation roadmaps.
  • Engage with stakeholders to gather requirements for end-to-end data architecture solutions.
  • Define and govern enterprise data architecture standards and designs.
  • Design and build scalable data platforms and pipelines for analytics.
  • Establish data modeling standards across systems and domains.
  • Optimize data ingestion and integration patterns for reliable data movement.
  • Lead technology evaluation and selection, including proofs-of-concept.

Benefits

  • Comprehensive benefits package including health, dental, life, and vision insurance.
  • Retirement options including a 401(k) plan plus profit-sharing.
  • Work-life balance with company-paid holidays and flexible scheduling.
  • Career development support with company-paid courses and tuition reimbursement.
  • Community engagement opportunities including charitable match and paid volunteer time.
  • Wellness initiatives, including health coaching and employee assistance programs.
Full Job Description
Job Information

Job Title

Data Architect

Home Department:

Information Technology

Employment Status:

Exempt; Full-time

Schedule:

Flexible Scheduling Opportunities

Position Location:

Remote/Hybrid (commutable distance to home office in Fond du Lac, WI)

This position offers flexible remote/hybrid work scheduling and we are targeting candidates who are located within the commutable greater Fond du Lac, WI area for infrequent in-person meeting events.

Society Insurance is seeking an experienced Data Architect to join our IT team. The Data Architect leads the design and implementation of the enterprise data architecture, translating business and data strategy into scalable, governed, and high-performing data platforms and solutions. The role is accountable for delivering the data architecture vision and enabling execution of the data strategy, including data models, pipelines, platforms, and integration patterns that support analytics, reporting, and operational use cases. The Data Architect partners with business and IT stakeholders to ensure data is trusted, accessible, and aligned to enterprise architecture standards, while driving modernization and continuous improvement of data capabilities.

About the Role

  • Translates enterprise data strategy into architecture, platforms, and implementation roadmaps aligned to business and analytics needs.
  • Engages with business and IT stakeholders to gather requirements and define end-to-end data architecture solutions.
  • Defines and governs enterprise data architecture standards, including data models, pipelines, integration patterns, and platform design.
  • Designs and builds scalable data platforms and pipelines (data lakes, warehouses, cloud platforms) to support analytics and reporting.
  • Establishes and enforces data modeling standards (logical, physical, dimensional) across systems and domains.
  • Designs and optimizes data ingestion, transformation, and integration patterns (ETL/ELT) to ensure reliable data movement across systems.
  • Ensures data architecture supports data quality, lineage, metadata, and governance frameworks aligned to enterprise standards.
  • Collaborates with architects and engineers to define architecture enablers, guide solution design, and support implementation.
  • Works with data engineering and Agile teams to ensure architecture is implemented effectively across delivery cycles.
  • Leads evaluation and selection of data technologies, tools, and platforms, including proof-of-concepts (POCs).
  • Develops and maintains data architecture roadmaps, including modernization, consolidation, and performance optimization.
  • Drives modernization of legacy data and reporting platforms to improve scalability, performance, and usability.
  • Ensures alignment between data, application, and infrastructure architecture.
  • Participates in Agile/PI Planning to align teams to a shared technical direction and standards.
  • Acts as a technical expert and leader, mentoring teams and driving adoption of best practices across data architecture and engineering.


About You

  • You are analytical and connect data across systems to support business insight and decision-making.
  • You are creative and innovative and identifies better ways to organize, integrate, and govern data.
  • You are driven by an underlying curiosity and desire to know more about things, people, or issues.
  • You take ownership of challenges and drive improvements in architecture, standards, and processes.
  • You quickly apply new knowledge, tools, and ideas to solve business and data challenges.
  • You enjoy managing the efficiency, accuracy, and integrity of the work that you produce.
  • You effectively prioritize work, manage multiple responsibilities, and meet deadlines.


What it Will Take

  • Bachelor's degree in computer science, engineering, or related field.
  • 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, (Azure Synapse, Data Factory, Fabric, Databricks, etc.)
  • Deep understanding of data modeling, ETL/ELT patterns, and data integration.
  • Experience implementing data architecture aligned to business and analytics needs.
  • Strong collaboration skills across business, architecture, and engineering teams.
  • Expertise in one or more of the following, but with versatility to grow in other areas:


  • Microsoft stack of Data Tools & Technologies (SQL, SSIS, TSQL)
  • Azure SQL Databases
  • Azure Blob storage
  • Azure App Services
  • Microsoft Azure Synapse, Data Factory & Fabric
  • Microsoft stack of Business Intelligence Tools (Power BI)
  • Data Modeling (Idera ERStudio)
  • Data Warehouse Design
  • Data Analytics Concepts


  • Strong organizational skills.
  • Demonstrated success in managing and/or completing projects.
  • SAFe Agile Delivery experience highly desirable.


What Society Can Offer

  • Comprehensive Benefits Package: Salary with bonus plan; health, dental, life, and vision insurance


  • Retirement: Traditional or Roth 401(k) Defined Contribution Plan PLUS Profit-Sharing Plan
  • Work-Life Balance: Company-paid holidays; flexible scheduling; PTO; telecommuting options


  • Education: Career Coaching; company-paid courses; student loan and tuition reimbursement
  • Community: Charitable Match; paid volunteer time; team sponsorships
  • Wellness: Employee Assistance Program; wellness initiatives/rewards; health coaching; and more


Similar Jobs

More Jobs at Society Insurance Company

More Enterprise Technology Jobs

Find similar Data Architect jobs: