Data Engineer

Medical Mutual; Cleveland (OH); Hybrid; USD 95,000 - 125,000; Full time

Job summary

Medical Mutual is seeking a data engineer to design and develop data integration pipelines, build data solutions for business insights, and support data quality and data modeling efforts. The role includes collaboration with business teams, data profiling, and ongoing skill development to meet evolving data needs.

The position emphasizes hands-on work with data pipelines, data lake/warehouse processes, and cloud technologies to enable analytics, reporting, and informed decision-making in a

Qualifications

• Bachelor's degree in Computer Science, Computer Information Systems, business degree with focus on data transformation or analysis, or equivalent work experience.
• 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.

Responsibilities

• 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.

Skills

Data pipelines

Data profiling

Data modeling

Python

SQL

Stakeholder communication

Education

Bachelor's degree in CS/IS or related

Tools

RedShift

Snowflake

DataBricks

Azure Synapse

BigQuery

Job description

This is a hybrid position located in Brooklyn, OH, with a three-day per week onsite requirement. Candidates must be located in the Cleveland/Brooklyn area.

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, pipeline development, scheduling, alerts).

Data Engineer I

Responsibilities

• 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

Responsibilities

• 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
• Performs other duties as assigned
• Learns new technical concepts and software languages as needed

Data Engineer III

Responsibilities

• 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

Responsibilities

• 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 informationPerforms other duties as assigned.
• Learns new technical concepts and software languages as needed.

Qualifications

Data Engineer I

• Bachelor's degree in Computer Science, Computer Information Systems, business degree with focus on data transformation or analysis, or equivalent work experience.
• 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

• Bachelor's degree in Computer Science, Computer Information Systems, business degree with focus on data transformation or analysis, or equivalent work experience
• 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

• Bachelor's degree in Computer Science, Computer Information Systems, business degree with focus on data transformation or analysis, or equivalent work experience
• 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

• Bachelor's degree in Computer Science, Computer Information Systems, business degree with focus on data transformation or analysis, or equivalent work experience
• 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