Data Engineer II

Outcomes® • Full-time • Dublin, OH, US • 1w ago

Description

Job Summary

Outcomes™ is a digital health technology company connecting Payers, Pharmaceutical manufacturers, and Pharmacies, to enhance patient outcomes and close gaps in healthcare system. Outcomes provides Medication Adherence, and Medication Therapy Management (MTM) services through various digital channels. With 48K connected pharmacies and 400M patient engagements, there are ample opportunities to harness your creativity to reduce healthcare costs and improve patientcare.

As a Data Engineer, you will be responsible for defining and implementing Data Solutions, Automation and BI Self-Service capabilities for Outcomes business. In this key technical role, you will partner with business stake holders to understand requirements, collaborate with other Data engineers, BI developers, and product engineers to create data pipelines, and convert raw data into meaningful business insights/metrics, reports and dashboards.

As part of the Data Solutions team, you will be utilizing cutting-edge cloud technologies to help migrate legacy analytics solutions to modern technologies. You wil help implement and operationalize large-scale Data and Analytics solutions utilizing Cloud and SaaS technologies such as AWS RedShift, Glue, Sigma Computing and Databricks. You will engage in hands-on implementation and offer support across various build and run operations.

You’ll thrive in small, cross-functional teams that embrace agile methodologies, follow data best practices and standards, and focus on driving automation and self-service capabilities to democratize data throughout the organization.

At Outcomes, Inc., we are looking for a forward-thinking Engineer with a strong sense of ownership, initiative, and a passion for transforming our business into a data-driven enterprise by modernizing our data analytics landscape.

Qualifications

ESSENTIAL DUTIES & RESPONSIBILITIES

Task

Work with business users and other subject matter experts to implement Data Analytics solutions

Collaborate with data engineers, BI developers, and product teams, to define requirements and deliver high-value data products

Participate in Data and Analytics discovery to establish feasibility of new use cases
Design or suggest improvements to optimize existing solutions
Implement and test solutions to ensure results meet business criteria
Deploy and enhance the solutions
Run and Maintain Operations for Data and Analytics Solutions

Develop and maintain complex Data pipelines, ETL processes, reports and business dashboards

Build and enhance Data Pipelines to ingest data
Own and enhance ETL processes for multiple Data Warehouses
Develop and maintain new reports and dashboards
Develop and maintain CICD artifacts
Monitor and troubleshoot Data pipelines and ETL processes
Document new and existing processes

Automate and Self-Service enable Data Solutions

Migrate existing legacy Datawarehouse and ETL processes to modern BI platforms and technologies
Automate current manual processes across business functions
Self-service enable Data Solutions to empower business with faster service and insights

Support and maintain Data and Analytics solutions

Troubleshot and resolve production issues
Implement enhancements and bug fixes
Operationalize daily data extracts, pipelines, reports and Dashboards
Proactively and independently identify performance issues and recommend enhancements
Proactively monitor and support production systems, including on-call responsibilities
Mentor and assist other team members on issue resolution and troubleshooting

Develop software with a security-first mindset using knowledge of standard security protocols and common security risks, secure coding techniques, and appropriate usage and protection of sensitive information such as PHI. Identify potential security issues during requirements analysis, development, and threat modeling discussions.

Knowledge & Requirements

Strong experience in Data Engineering, Modeling and Data Warehousing technologies
Strong experience in ETL design, development, testing, maintenance, and implementation of data pipelines and analytics initiatives
Strong SQL programming/python scripting/data analysis experience
Strong experience in MS SQL Server, SSIS and SSRS Technologies
Experience in AWS Cloud Data Services (AWS RedShift, and Glue)
Experience in Sigma Computing BI tool and Qlik Replicate is a plus
Experience in Databricks is a plus
Experience in GenAI, LLM and Agentic AI is a plus
Experience with React and other UI development tools is a plus.
Experience and knowledge in Clinical Services and Healthcare industry is a strong plus
Experience in gathering requirements, development, testing and maintenance of Data and Analytics Solutions
Experience leveraging cloud native services, AI tools/services, and DevOps practices
Provides a positive impact on team: influences team decisions, mentors peers, drives innovation
Excellent written and verbal communication skills
Experience with developing Chatbot automations is a plus

Desirable Qualifications

Self-motivated, quick learner, and thrives in fast-paced environments while adapting seamlessly to new technologies
Experience working with healthcare technology.
Experience working with PHI data and HIPAA standards.
Experience resolving issues that do not have clear answers.
High sense of urgency and accountability
Adaptable, friendly, and ability to work with teams.
Passion for data and digging into the minutia of datasets.

Education & Experience Requirements

Minimum years of work experience: 7 years
Minimum level of education or education/experience: Bachelors or equivalent work experience in Computer Science, Computer Engineering, Electrical Engineering, Information Systems, IT
4+ years of Data Warehousing experience
4+ years of experience in build data pipelines, ETL, and complex SQL scripting
4+ years of experience in Data Engineering