The IT department at WCF Insurance has an immediate opening for someone who can demonstrate the WCF values to join their team as a senior ETL developer. This is a full-time, exempt positon based in WCF's Sandy, Utah headquarters. This is open to internal and external candidates.
The senior ETL developer works as part of a team with responsibilities for overall management and usability of the enterprise data warehouse. Specific responsibilities of the senior ETL developer include design, development, implementation, and maintenance of data loads from incoming database data sources and feeds, including development and validation of transformations. Additionally, the senior ETL developer is maps source system data to data warehouse tables and extracts and loads the data, developing automated processes to increase consistency. As a member of the data team, the senior ETL developer works closely with business stakeholders, and provides exceptional communication, technical skill, training, and support to team members and other stakeholders in the company.
The most qualified candidate will have:
Bachelor's degree in an IT-related field or equivalent experience,
At least five years of work experience in an ETL role or developing data warehouse systems (or nine years work experience without a degree),
Deep understanding of relational database architectures,
Strong understanding of data warehousing principles, models, architectures, best practices, technologies, and trends,
Strong SQL development skills,
Familiarity with MS SQL (SSIS, SSRS, SSAS),
Strong understanding of ETL processes and tools,
Proficiency in a scripting language such as python, PERL, or bash,
Excellent communication and project management skills.