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 Responsibilities
Defines 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 Requirements
Education: Bachelor’s or Master’s degree in information technology, Computer Science or a related field.Prefer: Informatica Cloud, Snowflake, ODS, ETO experience
Experience: 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.
Skills Required
- Bachelor's or Master's degree in Information Technology, Computer Science, or related field
- Minimum of 14 years of experience in data architecture, data management, or a related field
- Proficiency in data modeling, database design, SQL, ETL processes, and data integration tools
- Experience with cloud data platforms (AWS, Azure, Google Cloud)
- Experience with Informatica Cloud
- Experience with Snowflake
- Experience with ODS and ETO
- Progress toward or completion of professional certification (e.g., CDMP or AWS Certified Big Data - Specialty)
- Ability to lead data architecture initiatives, influence stakeholders, and mentor junior team members
Great American Insurance Group Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Great American Insurance Group and has not been reviewed or approved by Great American Insurance Group.
-
Leave & Time Off Breadth — PTO, paid holidays, and paid parental leave are positioned as generous from the first year. These time‑off provisions are seen as core strengths of the total package.
-
Healthcare Strength — Health coverage includes comprehensive medical, dental, and vision options supported by HSA and FSA programs. Wellness resources such as EAP access, fitness facilities or reimbursements, and instructor‑led classes broaden the offering.
-
Retirement Support — Immediate 401(k) eligibility with a competitive company match and potential discretionary retirement contributions support long‑term savings. An employee stock purchase option and various discounts further reinforce financial benefits.
Great American Insurance Group Insights
What We Do
Based in Cincinnati, Ohio, the operations of Great American Insurance Group are engaged primarily in property and casualty insurance, focusing on specialty commercial products for businesses. We have more than 30 specialty property and casualty insurance businesses, and in 2021, approximately 50% of our gross written premium in our property and casualty operations was generated by business units with a Top 10 market ranking. Great American Insurance Company has received an "A" (Excellent) or higher rating from the AM Best Company for more than 110 years (most recent rating evaluation of "A+" (Superior) affirmed December 3, 2021). The members of Great American Insurance Group are subsidiaries of American Financial Group, Inc. (AFG), also based in Cincinnati, Ohio.
