Data Engineer I-V

Founded in 1934, Medical Mutual is the oldest and one of the largest health insurance companies based in Ohio. We provide peace of mind to more than 1.6 million Ohioans through our high-quality health, life, disability, dental, vision and indemnity plans. We offer fully insured and self-funded group coverage, including stop loss, as well as Medicare Advantage, Medicare Supplement, and individual plans.

Medical Mutual’ s status as a mutual company means we are owned by our policyholders, not stockholders, so we don’t answer to Wall Street analysts or pay dividends to investors. Instead, we focus on developing products and services that allow us to better serve our customers and the communities around us and help our members achieve their best possible health and quality of life.

****** Candidate must be willing to work on a hybrid (2-3 days) per week in Brooklyn, OH or Dublin, OH***********

Data Engineer I

Software developer for the design and development of the company’s data lake, data warehouse, and data marts, and development of related business intelligence dashboards and visualizations. Job duties involve profiling data, developing data transformation jobs and processes, measuring data quality, and designing data warehouse data models, evaluating usability and testing data models, and developing business intelligence visualizations.

Data Engineer II

Software developer for the design and development of the company’s data lake, data warehouse, and data marts, and support for applied use of data for business insights. Job duties involve profiling data, developing data transformation jobs and processes, measuring data quality, and designing data warehouse data models, evaluating usability and testing data models, and developing processes for applied use of enterprise data (data analysis, business intelligence, reporting).

Data Engineer III

Data engineer responsible for the design and development of data integration pipelines. Build data solutions for business problems and support the applied use of data to enable business insights and action. Job duties involve profiling data, developing data transformation pipelines, measuring data quality, designing data models, and supporting applied use of data to solve problems (exploratory analysis, business intelligence/dashboards, reporting, alerts).

Data Engineer IV

Data engineer responsible for the design and development of data integration pipelines. Build data solutions for business problems and support the applied use of data to enable business insights and action. Job duties involve profiling data, developing data transformation pipelines, measuring data quality, designing data models, and supporting applied use of data to solve problems (exploratory analysis, business intelligence/dashboards, reporting, alerts).

Data Engineer V

Data engineer responsible for the design and development of data integration pipelines. Build data solutions for business problems and support the applied use of data to enable business insights and action. Job duties involve profiling data, developing data transformation pipelines, measuring data quality, designing data models, and supporting applied use of data to solve problems (exploratory analysis, business intelligence/dashboards, reporting, alerts).

Responsibilities

Data Engineer I

• Develop data pipelines to integrate and transform data for analysis

• Support other data users and enable applied use of data to solve business problems

• Business meetings to understand data and business needs, socialize knowledge of data products and insights, and generate consensus

• Data profiling, data documentation, measuring and enforcing data quality

• Developing data models to represent information

• Performs other duties as assigned.

• Learns new technical concepts and software languages as needed.

Data Engineer II

• Developing and sequencing jobs and processes to transform data into data lake and data warehouse

• Support analytic projects, data extracts, and other work to apply data in the warehouse, test and prove capabilities, evaluate usability, and perform demonstrations to other analysts for how to use data to meet objectives

• Business meetings to understand data, capture agreement on business rules, understand analyst and stakeholder objectives, and support usage of data to solve business problems

• Data profiling, data documentation, and measuring data quality with manual verification and

• development of automated data quality tests

• Developing data models to represent data

Data Engineer III

• Develop data pipelines to integrate and transform data for analysis

• Support other data users and enable applied use of data to solve business problems

• Business meetings to understand data and business needs, socialize knowledge of data products and insights, and generate consensus

• Data profiling, data documentation, measuring and enforcing data quality

• Developing data models to represent information

• Performs other duties as assigned.

• Learns new technical concepts and software languages as needed

Data Engineer IV

• Develop data pipelines to integrate and transform data for analysis

• Support other data users and enable applied use of data to solve business problems

• Business meetings to understand data and business needs, socialize knowledge of data products and insights, and generate consensus

• Data profiling, data documentation, measuring and enforcing data quality

• Developing data models to represent information

• Performs other duties as assigned.

• Learns new technical concepts and software languages as needed.

Data Engineer V

• Develop data pipelines to integrate and transform data for analysis

• Support other data users and enable applied use of data to solve business problems

• Business meetings to understand data and business needs, socialize knowledge of data products and insights, and generate consensus

• Data profiling, data documentation, measuring and enforcing data quality

• Developing data models to represent information

• Performs other duties as assigned.

• Learns new technical concepts and software languages as needed.

Qualifications

Data Engineer I

Education and Experience:

• Bachelors degree in Computer Science, Computer Information Systems, business degree with focus on data transformation or analysis, or equivalent work experience

Technical Skills and Knowledge:

• Basic understanding of programming design and coding techniques

• Familiarity with systems development life cycle

• Understanding of database technologies and query semantics

• Experience with public cloud database technology (e.g. RedShift, SnowFlake, DataBricks, Azure Synapse, BigQuery)

• Experience programming in ETL or ELT technology

• Understanding of data warehouse data model theory and techniques

• Experience with Python programming language

Data Engineer II

Education and Experience:

• Bachelors degree in Computer Science, Computer Information Systems, business degree with focus on data transformation or analysis, or equivalent work experience

Technical Skills and Knowledge:

• Two or more years professional experience developing software to solve business problems

• Experience with data engineering system design and software implementation

• Experience with all parts of the systems development life cycle

• Experience with database technologies and query semantics

• Experience with public cloud database technology (e.g. RedShift, SnowFlake, DataBricks, Azure Synapse, BigQuery)

• Experience programming in ETL or ELT technology

• Understanding of data warehouse data model theory and techniques

• Experience with Python programming language

Data Engineer III

Education and Experience:

• Bachelors degree in Computer Science, Computer Information Systems, business degree with focus on data transformation or analysis, or equivalent work experience

Technical Skills and Knowledge:

• Four or more years professional experience developing software to solve business problems

• Three or more years experience with data engineering system design and software implementation

• Experience with all parts of the systems development life cycle

• Experience with database technologies and query semantics

• Experience with public cloud database technology (e.g. RedShift, SnowFlake, DataBricks, Azure Synapse, BigQuery)

• Experience programming in ETL or ELT technology

• Understanding of data warehouse data model theory and techniques

• Experience with Python programming language

Data Engineer IV

Education and Experience:

• Bachelors degree in Computer Science, Computer Information Systems, business degree with focus on data transformation or analysis, or equivalent work experience

Technical Skills and Knowledge:

• Seven or more years professional experience developing software to solve business problems

• Five or more years experience with data engineering system design and software implementation

• Proficient with all parts of the systems development life cycle

• Experience with database technologies and query semantics

• Experience leading and coordinating technical initiatives

• Experience with public cloud database technology (e.g. RedShift, SnowFlake, DataBricks, Azure Synapse, BigQuery)

• Experience programming in ETL or ELT technology

• Understanding of data warehouse data model theory and techniques

• Experience with Python programming language

Data Engineer V

Education and Experience:

• Bachelors degree in Computer Science, Computer Information Systems, business degree with focus on data transformation or analysis, or equivalent work experience

Technical Skills and Knowledge:

• Seven or more years professional experience developing software to solve business problems

• Five or more years experience and demonstrated excellence with data engineering system design and software implementation

• Demonstrated excellence with all parts of the systems development life cycle

• Expert in database technologies and query semantics

• Demonstrated excellence leading and coordinating technical initiatives

• Experience with public cloud database technology (e.g. RedShift, SnowFlake, DataBricks, Azure Synapse, BigQuery)

• Experience programming in ETL or ELT technology

• Expert understanding of data warehouse data model theory and techniques

• Experience with Python programming language

Medical Mutual is looking to grow our team We truly value and respect the talents and abilities of all of our employees. That's why we offer an exceptional package that includes:

A Great Place to Work

• We will provide the equipment you need for this role, including a laptop, monitors, keyboard, mouse, and headset.

• Whether you are working remotely or in the office, employees have access to on-site fitness centers at many locations, or a gym membership reimbursement when there is no Medical Mutual facility available. Enjoy the use of weights, cardio machines, locker rooms, classes and more.

• On-site cafeteria, serving hot breakfast and lunch, at our Brooklyn, OH location. Convenience stores at many locations.

• Discounts at many places in and around town, just for being a Medical Mutual team member.

• The opportunity to earn cash rewards for shopping with our customers.

• Business casual attire, including jeans.

Excellent Benefits

• Employee bonus program

• 401(k) with company match up to 4% and an additional company contribution.

• Health Savings Account with a company matching contribution.

• Excellent medical, dental, vision, life, and disability insurance — insurance is what we do best, and we make affordable coverage for our team a priority.

• Access to an Employee Assistance Program, which includes professional counseling, personal and professional coaching, self-help resources and assistance with work/life benefits.

• Company holidays and up to 16PTO days during the first year of employment with options to carry over unused PTO time.

• After one year of service, parental leave for eligible employees who become parents through maternity, paternity, or adoption.

An Investment in You

• Career development programs and classes.

• Mentoring and coaching to help you advance in your career.

• Tuition reimbursement up to $5,250 per year, theIRS maximum.

• Diverse, inclusive, and welcoming culture with Business Resource Groups.

About Medical Mutual

Medical Mutual’s status as a mutual company means we are owned by our policyholders, not stockholders, so we do not answer Wall Street analysts or pay dividends to investors. Instead, we focus on developing products and services that allow us to better serve our customers and the communities around us.

There is a good chance you already know many of our Medical Mutual customers. As the official insurer of everything you love, we are trusted by businesses and nonprofit organizations throughout Ohio to provide high-quality health, life, disability, dental, vision and indemnity plans. We offer fully insured and self-funded group coverage, including stop loss, as well as Medicare Advantage, Medicare Supplement, and individual plans. Our plans provide peace of mind to more than 1.5 million Ohioans.

We are not just one of the largest health insurance companies based in Ohio, we are also the longest running. Founded in 1934, we aree proud of our rich history with the communities where we live and work.

At Medical Mutual and its family of companies we celebrate differences and are mutually invested in our employees and our community. We are proud to be an Equal Employment Opportunity and Affirmative Action Employer. Qualified applicants will receive consideration for employment regardless of race, color, religion, sex, sexual orientation, gender perception or identity, national origin, age, marital status, veteran status, or disability status.

We maintain a drug-free workplace and perform pre-employment substance abuse and nicotine testing.

Title: Data Engineer I-V

Location: OH-Brooklyn

Requisition ID: 2400605

Other Locations: US-OH-Dublin