WCF Insurance

This position is available or hybrid remote/in office work.. Develop and maintain code in the ETL processes using stored procedures, T-SQL, and SSIS, against a variety of data sources such as PostgreSQL, Microsoft SQL Server, flat files, etc.. Identify, quantify, and propose automated solutions to address data integrity and data quality issues.. Experience with T-SQL, query performance tuning, indexing, and high-performance stored procedures.. Experience working with visualization tools, Power BI and python preferred.

data engineer

Do you love researching data and applying your findings to create the best data structures for data analytics? Do you enjoy digging into all the details as you work through a data set and identifying patterns and relationships? If so, this job may be a fit for you! Keep reading and watch our video below to see why WCF was voted one of the best places to work again!

Position
The Finance department has an immediate opening for someone who can demonstrate the WCF values to join their team as Data Engineer. This is a full-time, exempt position based out of WCF's Sandy, Utah headquarters. This position is open to internal and external candidates. This position is available or hybrid remote/in office work.



Responsibilities
Understand data requirements, concepts, data types and structures.
Understand and document business rules and cases to be applied to the ETL processes.
Develop and maintain code in the ETL processes using stored procedures, T-SQL, and SSIS, against a variety of data sources such as PostgreSQL, Microsoft SQL Server, flat files, etc.
Collaborate and participate in code review with peers.
Identify facts and dimensions required by data consumers to obtain reporting and analytical data requirements.
Identify, quantify, and propose automated solutions to address data integrity and data quality issues.
Ensure ETL processing uses standards, has good performance, and produces data with consistency and accuracy.
Implement quality insurance automated testing for data completion, accuracy, integrity, and consistency.

Qualifications
The most qualified candidate will have:
Proven work experience as an ETL or data developer.
Clear written and oral communication skills.
Strong data analytical skills to identify patterns, relationships, and flows, and troubleshoot data inconsistencies.
Working experience designing and developing data warehouse dimensional modeling.
Good understanding of SQL Server, including creating tables, stored procedures, views, setting up jobs, and troubleshooting code and data issues.
Experience with T-SQL, query performance tuning, indexing, and high-performance stored procedures.
Working experience developing SSIS packages.
Experience working with visualization tools, Power BI and python preferred.
Bachelor's degree in information technology or a related field and at least two years of work experience (or six years of directly related experience without a degree).
Ability to work well with others through communication and collaboration.

Ability to hire at the Senior Data Engineer Level depending on experience.

WCF INSURANCE DE&I MISSION
Promote and embrace a diverse, inclusive, equitable, and safe workplace.

WCF INSURANCE IS AN EQUAL OPPORTUNITY EMPLOYER
WCF Insurance provides equal employment opportunity to all qualified applicants and employees regardless of race, color, religion, sex, age, national origin, veteran status, disability that can be reasonably accommodated, or any other basis prohibited by federal, state, or local law.

START NEW SEARCH