DataJobs.io
← Back to all jobs

Job Description

Brotherhood Mutual Insurance Company is hiring an enterprise-focused Data Engineer II to design, build, and support data pipelines and platforms that enable analytics, regulatory reporting, and business intelligence. This role owns end-to-end data development, from pulling data from source systems to loading it into enterprise data stores on schedule. The position is based onsite in Fort Wayne, IN.

What you’ll do

  • Design, develop, and maintain ETL/ELT processes for on-premises and cloud data platforms while following established architectural and development standards.
  • Ingest data from on-premises and cloud source systems into centralized analytical environments, including data warehouses, lake houses, and curated enterprise data models.
  • Build and maintain database objects such as tables, views, stored procedures, and semantic models to support reporting, analytics, regulatory needs, and operational data.
  • Manage and optimize data solutions across relational, dimensional, and file-based storage, including cloud-hosted data warehouses and data lake environments.
  • Implement data quality checks, reconciliation processes, and dataset monitoring to help ensure data is accurate, complete, and reliable.
  • Analyze datasets to spot gaps, inconsistencies, and quality issues, contributing to continuous improvement of pipelines and models.
  • Identify and resolve problems affecting 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 activities, including 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.

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 SQL proficiency and a solid understanding of relational database concepts.
  • Working knowledge of cloud-based data services, including Microsoft Azure and Microsoft Fabric.
  • Proficiency in Python as the primary programming language for data engineering, including experience with Microsoft Fabric notebooks and Spark/PySpark based data processing frameworks.
  • Strong data engineering understanding, 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.
  • Analytical and problem-solving skills with attention to data quality and detail.
  • Ability to manage multiple priorities in a fast-paced environment and deliver results.
  • Proven ability to work effectively in a collaborative, cross-functional team environment.
  • Demonstrated 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.

Education

  • Associate’s degree in Information Technology, Computer Science, or a related field, or equivalent practical experience is required.
  • Bachelor’s degree in Information Technology, Computer Science, or a related field is preferred.
  • Experience in or exposure to the insurance industry is preferred.

Location and role details

  • Location: Fort Wayne, IN (onsite), Corporate Office
  • Department: Business Intelligence
  • Job Family: Information Technology
  • FLSA Status: Exempt
  • Education and/or Experience: Associate’s degree or equivalent practical experience required; 3+ years with database and data integration platforms required

Tools and technologies

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

Terms and conditions

  • This description is intended to summarize the general content of and requirements for the position and is not exhaustive.
  • Because the company’s niche is the church and related ministries market, familiarity with church operations is required, and conduct must not alienate or offend persons within that target niche.
  • The company may modify, interpret, or apply the position description as it desires.
  • This job description does not create an employment contract; the employment relationship remains at-will.
  • Equal Opportunity Employer.

Similar Jobs