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”.