Physicians Mutual Insurance Company

Physicians Mutual is hiring a Sr. Data Engineer in our Enterprise Technology Group. The selected candidate will design, develop, test and maintain scripts and jobs that are required to extract, transform, clean and move data and meta data to be loaded into a data warehouse, data mart, or operational data store. Mentor less experienced designers and serve as a project technical lead for mid-sized data projects.

ABOUT THE JOB

Job Qualifications:Bachelor’s degree in Computer Science, MIS or related field.6 years of IT experience, to include at least 5 years’ progressive experience in data warehousing, relational database management systems, and multi-dimensional database management systems. ​Must have strong experience with Snowflake & DBTMust have strong programming skills using Python/PySpark.Familiarity with ETL tools (e.g., DataStage, Informatica) is a must.Must have strong SQL.Demonstrated knowledge of data warehouse design and data warehousing data population techniques for target structures (Star Schemas, Snowflake Schemas, etc.)Strong relational database knowledge, including a broad understanding of current and prospective data architecture and database performance tuning.Preferred:Experience with Docker/Jenkins.AWS cloud experience is a plus.Demonstrated knowledge of UNIX scripting or PythonStrong SQL programming skills in a DB2 environment

OTHER

n/a