ETL Developer II - Data Warehousing

Job Title : ETL Developer II - Data Warehousing

FLSA Status : Exempt

Job Family : IT

Department : IT - Business Intelligence

Location : On-site (Fort Wayne, IN)

JOB SUMMARY

Responsible for developing in ETL platforms and providing analyst support to gather, transform, and store data within Brotherhood Mutual’s reporting database architectures.

Demonstrate expertise in all phases of development from source system acquisition to the timely loading of enterprise data stores for analytic, regulatory, and reporting data uses.

Please note that this position is not eligible for sponsorship.

POSITION ESSENTIAL FUNCTIONS AND RESPONSIBILITIES

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential

functions.

Independently develop the extraction, transformation, and load outputs and processes for data

solutions based on formal requirements.

Design, develop and maintain database objects such as the tables, views and stored procedures

needed to support reporting, statistical, analytic, and operational data.

Manage and maintain various database systems such as relational, dimensional, and flat file to

move and transform the data for data warehousing, business intelligence, reporting, and

compliance needs.

• Provide resource planning support and assist with setting delivery timelines.
• Analyze data to understand gaps, inconsistencies and other quality issues to identify

improvements.

• Resolve database and query performance issues.
• Work with business stakeholders and IT staff to gather data and reporting requirements.
• Develop within the standardized deployment procedures for data projects including appropriate

testing, user feedback and potential rollback processes.

Actively participate in Database technology forums, user groups, conferences and seminars for

the purpose of networking and knowledge sharing.

Aid the Network Services team during system updates and replacements involving database

servers and processes.

Coordinate with Network Services team during Disaster Recover testing, specifically with

Recovery Point and Recovery Time Objectives.

Complete other projects as assigned.

KNOWLEDGE, SKILLS, AND ABILITIES

The requirements listed below are representative of the knowledge, skills, and / or abilities required to perform

each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with

disabilities to perform the essential functions.

• Solid research, organizational, database, and SQL competency skills.
• Excellent aptitudes in customer service and time management.
• Capacity to work on multiple projects simultaneously.
• Expertise in dimensional, statistical, analytical, and relational modeling.
• Ability to plan, manage, and administer complex data projects.
• Demonstrated ability to work within a team environment.
• Proven ability to learn and implement new methodologies and procedures.
• Effective oral, written, and listening communication skills.
• Effectively interface with external contacts, Brotherhood employees, managers, and department

staff members.

EDUCATION AND / OR EXPERIENCE

List Degree Requirement, Years' Experience, and Certifications

Education and / or Experience

• An Associate’s degree in Information Technology or equivalent degree required.
• Three or more years working with database technologies and ETL platforms such as SQL Server,

SAP, Informatica, or Oracle required.

• Bachelor's degree in Information Technology or equivalent degree is desired.
• Exposure to and understanding of insurance industry is desired.

Terms and Conditions

This description is intended to describe the general content of and requirements for the

performance of this position. It is not to be construed as an exhaustive statement of duties,

responsibilities, or requirements.

Because the company’s niche is the church and related ministries market, and because effective

service requires a thorough understanding of this market, persons in this position must be

familiar with church operations and must conduct themselves in a manner that will neither

alienate nor offend persons within this target niche.

Brotherhood Mutual Insurance Company reserves the right to modify, interpret, or apply this

position description in any way the company desires. This job description in no way implies that

these are the only duties, including essential duties, to be performed by the employee occupying

this position. This position description is not an employment contract, implied or otherwise. The

employment relationship remains at-will .