Data Engineer

Medical Mutual employees must submit their applications through MySource.Note: 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 IJob Summary: 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).

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 IIResponsibilities:Developing and sequencing jobs and processes to transform data into data lake and data warehouseSupport 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 objectivesBusiness meetings to understand data, capture agreement on business rules, understand analyst and stakeholder objectives, and support usage of data to solve business problemsData profiling, data documentation, and measuring data quality with manual verification and development of automated data quality testsDeveloping data models to represent dataPerforms other duties as assignedLearns new technical concepts and software languages as neededData Engineer IIIResponsibilities:Develop data pipelines to integrate and transform data for analysisSupport other data users and enable applied use of data to solve business problemsBusiness meetings to understand data and business needs, socialize knowledge of data products and insights, and generate consensusData profiling, data documentation, measuring and enforcing data qualityDeveloping data models to represent informationPerforms other duties as assigned.Learns new technical concepts and software languages as needed.Data Engineer IVResponsibilities:Develop data pipelines to integrate and transform data for analysisSupport other data users and enable applied use of data to solve business problemsBusiness meetings to understand data and business needs, socialize knowledge of data products and insights, and generate consensusData profiling, data documentation, measuring and enforcing data qualityDeveloping data models to represent informationPerforms other duties as assigned.Learns new technical concepts and software languages as needed.

Qualifications

Data Engineer IBachelor'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 IIBachelor's degree in Computer Science, Computer Information Systems, business degree with focus on data transformation or analysis, or equivalent work experienceTwo or more years professional experience developing software to solve business problemsExperience with data engineering system design and software implementationExperience with all parts of the systems development life cycleExperience with database technologies and query semanticsExperience with public cloud database technology (e.g. RedShift, SnowFlake, DataBricks, Azure Synapse, BigQuery)Experience programming in ETL or ELT technologyUnderstanding of data warehouse data model theory and techniquesExperience with Python programming languageData Engineer IIIBachelor's degree in Computer Science, Computer Information Systems, business degree with focus on data transformation or analysis, or equivalent work experienceFour or more years professional experience developing software to solve business problemsThree or more years' experience with data engineering system design and software implementationExperience with all parts of the systems development life cycleExperience with database technologies and query semanticsExperience with public cloud database technology (e.g. RedShift, SnowFlake, DataBricks, Azure Synapse, BigQuery)Experience programming in ETL or ELT technologyUnderstanding of data warehouse data model theory and techniquesExperience with Python programming languageData Engineer IVBachelor's degree in Computer Science, Computer Information Systems, business degree with focus on data transformation or analysis, or equivalent work experienceSeven or more years professional experience developing software to solve business problemsFive or more years' experience with data engineering system design and software implementationProficient with all parts of the systems development life cycleExperience with database technologies and query semanticsExperience leading and coordinating technical initiativesExperience with public cloud database technology (e.g. RedShift, SnowFlake, DataBricks, Azure Synapse, BigQuery)Experience programming in ETL or ELT technologyUnderstanding of data warehouse data model theory and techniquesExperience with Python programming language