Data Engineer II

Brotherhood Mutual Insurance Company•Fort Wayne, IN
•Onsite

About The Position

The Data Engineer II designs, builds, and supports enterprise data pipelines and platforms that enable analytics, regulatory reporting, and business intelligence throughout Brotherhood Mutual. The role covers all phases of development, from acquiring data from source systems to loading enterprise data stores in a timely manner for analytical, regulatory, and reporting purposes. The position designs, develops, and maintains data solutions across on-premises and cloud platforms, supports data quality and performance, and collaborates with business stakeholders, analysts, and IT partners to deliver scalable solutions. It also supports operational readiness and keeps current with evolving data engineering tools and cloud technologies. The role requires familiarity with church operations and conduct that does not alienate or offend people in the company’s church and related ministries market. The job description is general rather than exhaustive, may be modified by the company, and does not constitute an employment contract; the employment relationship is at-will.

Requirements

  • Associate’s degree in Information Technology, Computer Science, or a related field, or equivalent practical experience.
  • At least three years of experience working with database technologies and data integration platforms, such as SQL Server, Informatica, SAP, Oracle, Microsoft Fabric, AWS, or similar.
  • Strong proficiency in SQL and relational database concepts.
  • Working knowledge of cloud-based data services, including Microsoft Azure and Microsoft Fabric data platform components.
  • Proficiency in Python for data engineering, including experience with Microsoft Fabric notebooks and Spark/PySpark-based data processing frameworks.
  • Solid understanding of data engineering principles, including data modeling, pipeline orchestration, and performance optimization.
  • Experience with dimensional, analytical, statistical, and relational data models.
  • Ability to design, support, and troubleshoot enterprise-scale data pipelines and platforms.
  • Strong analytical and problem-solving skills, with attention to data quality and detail.
  • Ability to manage multiple priorities and deliver results in a fast-paced environment.
  • Ability to work effectively in a collaborative, cross-functional team environment.
  • Ability to learn and apply modern technologies, tools, and methodologies.
  • Effective verbal, written, and interpersonal communication skills.
  • Strong customer service mindset when working with internal stakeholders and partners.

Nice To Haves

  • Bachelor’s degree in Information Technology, Computer Science, or a related field.
  • Experience in or exposure to the insurance industry.

Responsibilities

  • Design, develop, and maintain ETL/ELT processes for on-premises and cloud-based data platforms in accordance with architectural and development standards.
  • Ingest data from on-premises and cloud source systems into centralized analytical platforms, including data warehouses, lake houses, and curated enterprise data models.
  • Build and maintain database objects, including tables, views, stored procedures, and semantic models, to support reporting, analytics, regulatory, and operational data needs.
  • Manage and optimize data solutions using relational, dimensional, and file-based storage, including cloud-hosted data warehouses and data lakes.
  • Implement data quality checks, reconciliation processes, and monitoring to ensure enterprise datasets are accurate, complete, and reliable.
  • Analyze data to identify gaps, inconsistencies, and quality issues and contribute to improvements in pipelines and models.
  • Identify and resolve issues involving databases, data pipelines, and query performance.
  • Collaborate with business stakeholders, analysts, and IT partners to gather requirements and translate them into scalable data solutions.
  • Support delivery planning through effort estimation and assistance establishing timelines.
  • Develop and deploy data solutions using standardized development, testing, deployment, and rollback procedures.
  • Support operational readiness by participating in system upgrades, platform changes, and disaster recovery testing for data platforms.
  • Maintain awareness of evolving data engineering tools and cloud technologies through training and professional development.
  • Complete other assigned duties and projects.
  • Maintain familiarity with church operations and conduct oneself in a manner that does not alienate or offend people in the company’s target market.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service