DeveloperJobs.io
← Back to all jobs

Job Description

Brotherhood Mutual Insurance Company is seeking a Data Engineer II to design, build, and support enterprise data pipelines and platforms. This role focuses on delivering data capabilities that enable analytics, regulatory reporting, and business intelligence, from source acquisition through loading into enterprise data stores.

Role Summary

The position is responsible for end-to-end data development, including acquiring data from source systems and ensuring timely loading into enterprise data environments. Work includes building ETL/ELT processes, developing database objects, monitoring data reliability, and collaborating with business and IT stakeholders to translate requirements into scalable data solutions.

Key Responsibilities

  • Design, develop, and maintain ETL/ELT processes for on-premises and cloud-based data platforms, ensuring alignment with established architectural and development standards.
  • Ingest data from on-premises and cloud source systems into centralized analytical platforms such as 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 lake environments.
  • 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, contributing to continuous improvement of pipelines and data models.
  • Identify and fix issues related to 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 with establishing delivery 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 opportunities.
  • Complete other duties and projects as assigned.

Required Qualifications

  • 3+ years of experience working with database technologies and data integration platforms (examples include 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 as the primary programming language 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 data 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.
  • Demonstrated ability to work effectively within a collaborative, cross-functional team environment.
  • Proven 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.

Preferred Qualifications

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

Education

Associate’s degree in Information Technology, Computer Science, or a related field, or equivalent practical experience, is required.

Technologies

  • SQL, Microsoft Azure, Microsoft Fabric
  • Microsoft Fabric notebooks, Python, Spark, PySpark
  • SQL Server, Informatica, SAP, Oracle, AWS
  • ETL, ELT

Location and Employment Status

  • Location: Fort Wayne, IN (onsite), Corporate Office (Fort Wayne, IN)
  • Department: Business Intelligence
  • Job Family: Information Technology
  • FLSA Status: Exempt

Terms and Conditions

  • This description outlines the general content of and requirements for the position and is not exhaustive of all duties, responsibilities, or requirements.
  • Because the company serves the church and related ministries market, individuals in this position must be familiar with church operations and conduct themselves appropriately within this target niche.
  • Brotherhood Mutual Insurance Company reserves the right to modify, interpret, or apply the position description in any way the company desires.
  • This job description does not imply these are the only duties, including essential duties, to be performed.
  • This position description is not an employment contract, implied or otherwise.
  • The employment relationship remains “at-will.”
  • Equal Opportunity Employer.

Similar Jobs