Data Engineer II

Location: This position is located at our Dublin, OH campus with hybrid flexibility.

Who we are

Founded in 1999 and headquartered in Central Ohio, we’re a privately-owned, independent healthcare navigation organization. We believe that no one should have to navigate the cost and complexity of healthcare alone, and we’re on a mission to make healthcare simpler and more effective for our millions of members. Our big-hearted, tech-savvy team fights to ensure that our members get the care they need, when they need it, at the most affordable cost – that’s why we call ourselves Healthcare Warriors®.

We’re committed to building diverse and inclusive teams – more than 2,000 of us and counting – so if you’re excited about this position, we encourage you to apply – even if your experience doesn’t match every requirement.

About the role

The Data Engineer II is responsible for the design and construction of data flows that assemble and refine complex data sets into usable information that support organization initiatives. They will work with architects and team leads to design and build data-focused artifacts consistent with the architecture direction and business areas to satisfy documented functional/non-functional requirements.

The scope of their work will support and drive capabilities of Business Intelligence, Operational Reporting, Enterprise Data Warehouse, Enterprise Application Integrations and partner application functions. In some cases, they may oversee/guide the development activities of fellow engineers in areas where they have subject matter expertise.

What you’ll do

Create and maintain data pipelines and associated objects / services

Work with data and design teams to define solutions and support data requirements

Support peers and associated activities that enhance the overall productivity and capabilities of the department and team

What you’ll bring

BS / Graduate Degree in Computer Science, Engineering, Mathematics, Statistics or related field

3+ years of experience in similar technical roles (ETL, Application Development, Data Science, Big Data, Reporting)

Exposure and experience with document markups (JSON,XML), document data stores and REST API endpoints for data retrieval and update

Reasonable background with relational databases and SQL

Experience building and optimizing data pipelines and data sets

Experience with cloud technologies and associated purpose. AWS preferred, such S3, EC2, EMR, DynamoDB, Aurora, Athena, Glue, Lambda.

Ability to analyze data, find patterns, identify issues, and enhance and improve the integrity and quality of data and associated technical processes

Build processes supporting data transformation, data structures, metadata, dependency and workload management

Working knowledge of message queuing, stream processing, and scalable data stores / processes

Experience with data warehouse and associated modeling / design (data mart, dimensions, facts)

Exposure and familiarity with object-oriented/object function scripting languages: Python, Java, C++, Scala, etc. (Python preferred)

Experience with Enterprise integration and ETL platforms/IPaaS (SnapLogic, Informatica, SSIS)

Experience supporting and working with cross-functional teams in a dynamic environment.

Strong organizational and interpersonal skills

MarkLogic or Snowflake experience a big plus.

Strong administrative/technical skills; Comfort working on a PC using Microsoft Office (Outlook, Word, Excel, PowerPoint), IM/video conferencing (Teams & Zoom), and telephones efficiently.

A high degree of personal accountability and trustworthiness, a commitment to working within Quantum Health’s policies, values and ethics, and to protecting the sensitive data entrusted to us.

--

#LI-KT1

#LI-Hybrid