Talent.com
ETL Developer II

ETL Developer II

Brotherhood MutualFort Wayne, IN, US
job_description.job_card.30_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.job_description

Job Title : ETL Developer II

FLSA Status : Exempt

Job Family : IT - Business Intelligence

Department : IT - Business Intelligence

Location : Corporate Office (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.

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

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

    serp_jobs.job_alerts.create_a_job

    Etl Developer • Fort Wayne, IN, US