Data Engineer

Company: Physicians Mutual
Location: Omaha
Posted on: March 19, 2023

Job Description:

Physicians Mutual is hiring a Data Engineer in our Enterprise Technology Group. The selected candidate will map source system data to data warehouse models or other file transformations (source to target mappings). Develops complex ETL processes. Follows ETL standards, goals, and objectives. Follows Change Management/Configuration Management processes for the deployment of code into test and production environments. Provides rotational on-call support, responding quickly to production issues. Creates basic to moderate physical designs of ETL processes. Job Qualifications:

• Bachelor's degree in Computer Science, MIS or related field or equivalent experience is required.
• Minimum of 3 to 5 years IT experience.
• 2 years of experience in data warehousing, relational database management systems, and/or multi-dimensional database management systems
• Demonstrated knowledge of at least one ETL tool such as IBM Infosphere DataStage.
• Hands-on experience in creating ETL solutions with Python/Spark is required.
• Demonstrated knowledge of Data Warehousing data population techniques for target structures such as Star Schemas, Snowflake Schemas, highly normalized data models, and file structures.
• Demonstrates knowledge of source to target mappings.
• Demonstrates relational database knowledge; possesses a broad understanding of the current and prospective data architecture, and database performance tuning.
• Demonstrates ETL staging environment development skills and strong SQL programming skills in a DB2 environment.
• Excellent verbal and written communication skills.
• Has ability to establish and maintain effective working relationships with external and internal personnel.
• Must be customer focused and excel in coordination of problem resolution.
• Flexibility to work in a changing, fast-paced environment and work with a sense of urgency and accountability.
• Rotational On-Call support is expected. Preferred:
  • Experience with programming languages such as PySpark, UNIX scripting, Java is desirable.
  • Experience with Agile methodologies is desirable.
  • Post graduate degree or coursework a plus. 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.

Keywords: Physicians Mutual, Omaha , Data Engineer, Engineering , Omaha, Nebraska