Data Engineer II
Azure
Azure Data Platform
Azure Platform
Big Data
Bigdata
Cloud
Cloud Data Engineering
Cloud Data Platform
Cloud Engineer
Cloud Operations
Cloud Platform
Cloud Platforms
Cloud Platforms Cloud Platforms
Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Engineering
Data Fabric
Data Integration
Data Integration Tools
Data Pipeline
Data Platform
Data Processing
Data Warehouse
Database
Databases
Engineer
ETL
Informatica
Informatica
Information Technology (IT)
Integration
Microsoft Fabric
Programming
Programming Language
Programming Languages
Pyspark
Reporting and Analytics
Software Development
SQL
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
C