PHL Data Engineer

A successful Data Engineer will actively participate in the design, development, and operation of a modern data platform that supports Carenet Health's business strategy and delivers trusted data-as-a-service capabilities with a focus on data quality, reliability, and ease of use.

At Carenet Health, we're relentlessly focused on delivering clinically driven, consumer-centric engagement solutions rooted in powerful, one-on-one connections. One in five (65 million) Americans has access to our services, and we connect with 70,000 consumers daily about their health and wellness, coverage and benefits, care coordination and more.

Responsibilities

• Work with data and BI teams and business stakeholders to design, build and populate the data warehouse.
• Ingest data from on-prem and cloud-based source systems.
• Build, maintain, monitor, and troubleshoot complex data pipelines.
• Evaluate storage needs and take a hands-on approach to provision and build the required infrastructure.
• Model data marts and generate all DDL.
• Test and tune various data architectures to optimize cost and performance.
• Analyze raw data
• Develop and maintain datasets
• Improve data quality and efficiency

Qualifications

Education/Experience:

• Minimum 3 years of experience as an ETL/ELT developer or data engineer.
• In-depth knowledge of MS SQL Server platform, including SSIS and SSRS. Exposure to SSAS a plus.
• Demonstrated experience developing and maintaining complex ETL jobs using SSIS.
• Proficiency in analyzing and tuning SQL processes and queries.
• Experience producing relational data models.
• Knowledge of data warehousing concepts (dimensions, facts, star schemas).
• Basic knowledge of SQL Server administration.
• Familiarity with data security and privacy best practices.
• Experience with tools and techniques for data masking and data anonymization.
• Some hands-on experience with Azure data stack, in particular, ADF and Azure SQL.
• T-SQL / Ansi SQL expertise

Desirable Technical Skills

• Exposure to big data tools and technologies (Spark, data lakes, Databricks, Snowflake, etc.)
• Knowledge of NoSQL databases, especially document store and key-value types.
• Python, C#, R, Javascript

Required Skills

• Ability to productively interact with co-workers, peers, and customers
• Ability to lead detailed discussions of application systems and requirements
• Ability to work collaboratively across different departments, functions, and environments
• Excellent organization skills
• Effective writing skills and attention to detail
• Self-disciplined with strong attention to detail
• Energetic and self-starting

We're searching for the market's strongest candidate to join our group of innovators, collaborators, and builders in pioneering the next phase of Carenet's place in healthcare history. If this sounds like you, we need to connect!

More About Carenet Health

Carenet Health delivers multi-dimensional value to healthcare organizations in areas such as revenue optimization, cost containment and consumer experience. Our clients choose us-and stay with us for an average of seven years or more-because of our clinical expertise and our experience creating meaningful connections that deliver impact and ROI.

Our solutions include multi-channel consumer engagement programs that support quality and satisfaction performance metrics, as well as on-demand clinical engagement and telehealth services that improve care and lower costs. Intelligent contact strategies, empathy-focused interactions, high-touch navigation assistance and best-in-class partners are a few of the key factors in our success.

Learn more at carenethealthcare.com