What are the responsibilities and job description for the Data Engineer position at Physicians Mutual?
Physicians Mutual is hiring a 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.
Job Qualifications:
- Bachelor’s degree in Computer Science, MIS or related field.
- 3 years of IT experience, to include at least 1-year progressive experience in data warehousing, relational database management systems, and multi-dimensional database management systems.
- Must have strong experience with Snowflake & DBT
- Must 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 Python
- Strong SQL programming skills in a DB2 environment
About Us:
Health. Life. Retirement. The Physicians Mutual family empowers people from all walks of life to enjoy the financial security they deserve. That’s what Insurance for all of us® is about.
The Physicians Mutual family includes Physicians Mutual Insurance Company and Physicians Life Insurance Company. Physicians Mutual Insurance Company offers reliable dental and supplemental health insurance (and now, pet insurance!). Physicians Life Insurance Company provides important Medicare Supplement and life insurance coverage. The company additionally offers coverage for funeral pre-planning to help meet the growing needs of funeral home owners and the families they serve.
Since our start in 1902, our dedication to delivering on our promise has helped make us one of the nation’s leading health and life insurance providers. In fact, we are rated in the top 1% of insurance companies. We consistently maintain some of the highest financial strength ratings in the nation from independent insurance analysts, including A.M. Best Company and Weiss Ratings, ensuring we’ll be there for our policyowners and our employees far into the future.
But the achievement we’re most proud of? We have a 95% customer approval rating — a true sign of a company dedicated to embodying its vision.
