Senior Data Architect - Hybrid

Summit Consulting; Town of Richfield (WI); Hybrid; USD 120,000 - 170,000; Full time

Benefits offered by this job

Medical, dental, vision coverage

Paid time off & holidays

401(k) with company match

Employee stock purchase plan

Commuter benefits

Job summary

National Interstate Insurance Company (NIIC) is seeking a Data Engineer to join our Richfield, OH team. The role supports enterprise data architecture, governance, and analytics, with on-site three days a week and potential remote work two days.

The ideal candidate will lead data modeling, data integration, ETL, and cloud-based platforms, ensuring data quality, security, and regulatory compliance across the organization. A strong mentorship mindset and stakeholder collaboration are essential.

Qualifications

• Bachelor’s or Master’s degree in information technology or related field.
• Experience with data architecture, data governance, and data quality controls.

Responsibilities

• Defines and governs the enterprise data architecture, including models, data flows, and integration strategies.
• Leads the design and governance of data integration solutions and optimizes databases and data warehouses.
• Establishes standards for data modeling, metadata, and governance with policies to ensure security and regulatory compliance.
• Performs analysis to define data acquisition, access, and usage requirements for data-driven decisions.
• Develops and enforces data governance policies and controls to ensure data quality and security.
• Evaluates emerging data technologies to enhance architecture and analytics capabilities.
• Maintains comprehensive documentation for data architecture and governance processes.
• Collaborates with senior stakeholders to align data architecture with enterprise priorities and provides thought leadership.
• Mentors junior team members and participates in talent development decisions.

Skills

Data architecture

Data modeling

SQL

ETL processes

Data integration

Cloud platforms

Stakeholder management

Mentoring

Leadership

Regulatory compliance

Education

Bachelor's or Master’s in IT

CDMP or AWS Big Data – Specialty

Tools

Snowflake

Informatica Cloud

AWS

Job description

National Interstate is a member of Great American Insurance Group. As one of the leading commercial transportation insurers in the nation, we offer risk financing solutions in all 50 states tailored to meet the needs of a wide variety of transportation classes. Our offerings include traditional insurance and innovative alternative risk transfer (ART) programs, including more than a dozen group captive programs catering to niche wheels markets. We are proud to be a multiple Northcoast 99 winner and Cleveland Plain Dealer Top Workplace in Northeast Ohio. It is because of our talented and dedicated team that we are able to live out our company values of integrity, transparency, fairness, accountability, empowerment and collaboration with each transaction we make. If you are ready to join an engaging and driven team such as ours, we would love to hear from you!At Great American, we value and recognize the benefits derived when people with different backgrounds and experiences work together to achieve business results. Our goal is to create a workplace where all employees feel included, empowered, and enabled to perform at their best.This position is not eligible for employment visa sponsorship. Applicants must be authorized to work in the United States without the need for current or future sponsorship.Since 1989, National Interstate has specialized in serving the insurance needs of the wheels-based transportation industry. Our steadfast focus on developing niche expertise in product design, loss control and claim services has made National Interstate one of the most respected names in commercial transportation insurance today. (https://natl.com/)National Interstate is looking for a Data Engineer to join their team. This individual will either work hybrid from the Richfield, OH office 3 days per week.National Interstate’s culture is built on connection, shared learning, and strong relationships. To support this, employees in this role are expected to be on-site a minimum of three days a week, with the potential to work two days remotely. Core in‑office days are Tuesday, Wednesday and Thursday but will be determined by business needs.Essential Job Functions and ResponsibilitiesDefines and governs the enterprise data architecture, including conceptual, logical, and physical models, data flows, and integration strategies that support business objectives.Leads the design and governance of data integration solutions and oversees the optimization of databases, data warehouses, and analytical environments to ensure performance, scalability, and resilience.Establishes and enforces enterprise standards for data modeling, metadata, and governance, including policies and controls to ensure data quality, security, and regulatory compliance.Conducts analysis to define requirements for data acquisition, access, and usage, enabling informed, data-driven decisions. Leads the development and of data governance policies and controls, ensuring data quality, security, and regulatory compliance.Evaluates and recommends emerging data technologies and practices to enhance architecture and analytics capabilities.Oversees the creation and maintenance of comprehensive documentation for data architecture, standards, and governance processes.Collaborates with senior stakeholders across business and technology teams, influencing strategic initiatives and ensuring data architecture supports enterprise priorities.Provides thought leadership through workshops, advisory sessions, and guidance on enterprise data architecture and strategy.May have responsibility for performance and coaching of staff and may have a participatory role in decisions regarding talent selection, development, and performance management for direct reports.Performs other duties as assigned.Job RequirementsEducation: Bachelor’s or Master’s degree in information technology, Computer Science or a related field.Prefer: Informatica Cloud, Snowflake, ODS, ETO experienceExperience: Generally, a minimum of 14 years of experience in data architecture, data management, or a related field. Completion of or continuing progress toward a professional designation preferred, such as Certified Data Management Professional (CDMP) or AWS Certified Big Data – Specialty.Scope of Job/Qualifications: Defines and leads the development of enterprise data architectures that align with organizational strategy, business objectives, and governance requirements. Demonstrated proficiency in data modeling, database design, SQL, ETL processes, and data integration tools. Experience with cloud data platforms (e.g., AWS, Azure, Google Cloud). Solves highly technical and complex problems based on multiple projects and provides consultative support to internal staff. Works on multiple projects as a project leader or as a subject matter expert. Demonstrates the ability to analyze complex data requirements and design effective data solutions. Meticulous in ensuring data accuracy and integrity. Works on projects/issues of moderate to high complexity that requires in-depth knowledge across multiple technical areas and business segments. Performs work under limited supervision. Strong analytical and problem-solving skills. Excellent stakeholder engagement and communication skills, with the ability to influence at all levels. Ability to lead data architecture initiatives and mentor junior team members. Recognized as a subject matter expert across the organization.Company:NIIC National Interstate Insurance CompanyBenefits:We offer competitive benefits packages for full-time and part-time employees*. Full-time employees have access to medical, dental, and vision coverage, wellness plans, parental leave, adoption assistance, and tuition reimbursement. Full-time and eligible part-time employees also enjoy Paid Time Off and paid holidays, a 401(k) plan with company match, an employee stock purchase plan, and commuter benefits.Compensation varies by role, level, and location and is influenced by skills, experience, and business needs. Your recruiter will provide details about benefits and specific compensation ranges during the hiring process. Learn more at http://www.gaig.com/careers.*Excludes seasonal employees and interns.