What are the responsibilities and job description for the Senior Data Engineer - Analytics position at Physicians Mutual?
Physicians Mutual is hiring a Sr. Data Engineer – Analytics 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.
Job Qualifications:
- Bachelor’s degree in Computer Science, MIS or related field.
- 8 years of IT experience, to include at least 6 years’ progressive experience in data warehousing, relational database management systems, and multi-dimensional database management systems.
- 6 years of SQL experience.
- 4 years’ experience using Python or Shell.
- 2 years’ experience with Snowflake & DBT
- 2 years of experience developing or deploying data solutions in any cloud such as AWS, Google or Azure required.
- Demonstrate experience in data engineering with 8 years’ experience using ETL tools (e.g., Informatica, DataStage, or DBT).
- 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.
- Experience with Docker/Jenkins.
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.
