ETL Developer

Department:                 Business IT & Claims Administration

 

 

 

Reports To:                  Manager of Business IT

 

 

 

Status:                         Full Time, Exempt

 

 

 

Hours:                          Monday – Friday

 

 

 

Supervision:                This position does not supervise any other staff

 

 

 

Date Updated:              September 2022

 

 

 

Summary:                    This position is responsible for supporting and developing extract, transform, and load (ETL) processes and reports that directly or indirectly support operations at PrimeWest Health. The ETL Developer focuses on process improvement to reduce costs by providing solutions that reduce workload and manual processes. 

 

                       

 

Reporting Accountability – N/A  

 

Role and Key Responsibilities
Assist the Manager of Business IT and PrimeWest Health staff in the following as needed: 1.   Data Management

 

1. Design and implement a plan for both internal and external sources of data
2. Design and implement a plan for all types of data movement
3. Design, implement, maintain, and document reports and ETL processes developed
4. Troubleshoot reporting and data discrepancies
5. Define and develop reports for select user staff as needed

 

General PrimeWest Health Responsibilities

1. Abide by the PrimeWest Health Code of Conduct Comply with all PrimeWest Health policies and procedures Comply with the Health Insurance Portability and Accountability Act (HIPAA) and all other privacy laws Be familiar with building safety procedures and alert maintenance if something requires attention Keep public areas of the department and office neat and clean Conduct other responsibilities and activities as needed and assigned

 

 

Professional Competencies

1. Ability to analyze and manipulate data tables Experience with ad hoc, paginated, multi-perspective, or similar reporting tools for relational databases Understanding of and ability to develop relational database (e.g., Oracle, SQL Server, DB2) Ability to design and translate business requirements into ETL technical requirements Ability to develop efficient ETL mappings by applying standard procedures, conducting unit testing, implementing ETL routines, and preparing supporting documentation Experience with ETL and Online Analytical Processing (OLAP) for building an enterprise-wide data warehouse Strong problem solving and analytical skills and ability to understand complex business requirements Ability to learn and apply new technologies and concepts
2. Ability to adapt to varied situations requiring constructive thinking, analysis, interpretation, and evaluation

 

 

Educational Requirements and Required Qualifications

1. At minimum, an associate’s degree in computer science or other major related to this position, or two years of experience equivalent to the position requirements Demonstrated knowledge of, and proficiency in, Word, Excel, and Outlook required Flexibility and ability to handle multiple tasks. Demonstrated organizational skills and attention to detail. Ability to work effectively with a variety of people both within and outside of the organization. Excellent verbal and written communication skills, including the ability to provide effective training in one-to-one or group settings. Ability to sit at a desk or computer station most of the time. Ability to occasionally lift and/or carry objects up to 30 pounds.

 

 

Appropriate Licensure and Certification Requirements – N/A
  Collaborative Efforts with Other Departments

1. Administration Care & Population Health Management Corporate Compliance & Auditing Financial & Data Management Information Systems & Technology Membership & Provider Services Operations Pharmacy Management Quality & Utilization Management

 

 

Supervision – N/A  

 

This position description is not to be construed as an exhaustive statement of essential functions or responsibilities.

 

 

 

 

 

Alexandria, Minnesota – This position offers the possibility for remote/hybrid work

 

 

 

PrimeWest Health will accept résumés for this position until further notice. No phone inquiries please. Employment to begin as soon as possible.

 

 

 

Qualified candidates should submit their résumé and cover letter to:

 

 

Jeramie Harris, Director of Business IT & Claims Administration

 

PrimeWest Health

 

3905 Dakota St

 

Alexandria, MN 56308

 

 

 

or

 

 

 

Jeramie Harris at jeramie.harris@primewest.org

 

Please include “ETL Developer” in the subject line.

 

PrimeWest Health is an Equal Opportunity Employer Committed to Diversity, Equity, and Inclusion