Data Engineer

Description

POSITION SUMMARY

The Data Engineer will build scalable, trusted, and secure data models and pipelines that support analytics, reporting, and operations across our healthcare organization. The Data Engineer plays a critical part in delivering validated, governed, and actionable data products that drive decision-making throughout the business.

This position involves end-to-end ownership of data workflows, including ingestion, transformation, modeling, and delivery. It requires strong proficiency in SQL and Python, as well as deep experience with Azure data services such as Synapse, Data Factory, Logic Apps, and Microsoft Fabric. The Data Engineer is responsible for applying continuous validation at every stage of the process and maintaining clear, collaborative communication with both stakeholders and technical team members to ensure data accuracy, alignment, and reliability.

EXPECTATIONS

Every Adelante Healthcare employee will strive to maximize their performance and contribution to Adelante Healthcare and the community we serve every day. Employees are expected to work in a manner that demonstrates a commitment to quality, patient safety, employee engagement, innovation, and the highest standards of personal integrity, professionalism, and competence.

OUR CORE VALUES

• Inclusion
• Nurture
• Service
• Purposeful
• Integrity
• Resilient

Engaged

Qualifications

ESSENTIAL SKILLS AND EXPERIENCE:

• Bachelor’s degree in computer science, Information Systems, Engineering, or a related technical field, preferred.
• Three (3) – five (5) years of experience
• Strong proficiency in SQL for large-scale data transformation, query optimization, and schema development.
• Advanced Python skills for scripting ETL/ELT logic, validation routines, automation, and integration.
• Demonstrated ability to design and implement scalable, maintainable data pipelines using Azure Data Factory, Synapse Pipelines, and Logic Apps.
• Expertise in data modeling, including normalized and dimensional models (star/snowflake), surrogate keys, SCD handling, and business-friendly schema design.
• Experience implementing robust data validation and quality frameworks, including completeness, accuracy, integrity, and anomaly detection.
• Proficient with Azure Synapse Analytics (dedicated and serverless pools), Azure Data Lake Storage, and Logic Apps for managing ingestion, transformation, and orchestration.
• Working knowledge of data security practices and compliance (HIPAA, PHI), including RBAC, RLS, and secure data delivery.
• Familiarity with CI/CD pipelines and infrastructure-as-code using Azure DevOps or GitHub Actions.
• Ability to deliver trusted, analytics-ready datasets to business teams via Microsoft Fabric Lakehouses and Power BI.
• Experience supporting Power BI development by preparing validated semantic models, implementing row-level security, and enabling performance-optimized report layers — always backed by solid pipeline foundations.

Other common essential skills / experience you may choose to include:

• Certification to perform cardiopulmonary Resuscitation for the Health Care Professional (CPR) and AED through courses that follow the guidelines from the American Heart Association and Red Cross (cognitive and skills evaluations)
• Valid Level One Fingerprint Clearance Card issued by the Arizona Department of Public Safety for all specialty behavioral health locations or ability to obtain within 30 days of employment
• Prioritization and multi-task skills are required
• Competency in working with people of various cultures
• Ability to perform a variety of assignments requiring considerable exercise of independent judgment

POSITION REPONSIBILITIES

• Build and maintain robust data pipelines that ingest, transform, validate, and deliver data from multiple internal and external sources.
• Design data models that align with business use cases and support high-performance reporting and analytics.
• Implement data validation logic to ensure quality, trust, and accuracy in all downstream outputs.
• Automate workflows using Logic Apps and Data Factory to support real-time and batch use cases.
• Ensure pipeline observability, logging, and monitoring for proactive issue detection and resolution.
• Collaborate with data analysts, BI developers, and business stakeholders to translate requirements into engineering solutions.
• Provide secure, governed access to data through role-based access controls and RLS configurations.
• Participate in DevOps workflows to version-control and automate deployments across environments.
• Publish curated, validated datasets to Power BI workspaces and Fabric Lakehouses, supporting enterprise-wide reporting.
• Maintain documentation, data dictionaries, and flow diagrams to ensure transparency and maintainability.

NONESSENTIAL SKILLS AND EXPERIENCE:

• Knowledge of healthcare interoperability standards such as FHIR or HL7, or experience working with clinical data models or claims data.
• Exposure to Microsoft Purview or other data cataloging tools for metadata management, lineage tracking, and automated governance.
• Background in building or supporting machine learning pipelines in Azure using Synapse ML, Azure ML, or Databricks.
• Experience with Delta Lake or lakehouse optimization strategies, including schema evolution, time travel, and ACID transactions on big data.
• Proficiency in performance tuning for large-scale BI environments, including query optimization, caching strategies, and dataset partitioning.
• Ability to lead data architecture discussions, contribute to platform design decisions, or mentor junior engineers on engineering best practices.
• Understanding of data privacy engineering, such as implementing differential privacy, data anonymization, or secure multi-party computation in analytics workflows.
• Hands-on experience with cross-cloud or hybrid-cloud architectures, especially integrating Azure with AWS or on-premise systems.

Additional Duties and Responsibilities

• Other duties as requested or assigned

Patient Centered Medical Home (PCMH) and Integrated Care Team (ICT)

All employees are responsible for promoting and participating in interdisciplinary communication and collaboration to enhance the delivery of quality across the health care system. Employees should maintain an environment which supports and engages patients and co-workers in a caring team-based model to promote wellness and improve health outcomes.

Adherence to Compliance and Code of Conduct

All employees are required to comply with Adelante Healthcare’s written standards, including its Compliance Program and Code of Conduct, policies and procedures and reporting of any conduct that potentially violates Adelante’s legal or compliance requirements. Such compliance will be an element considered as part of the regular performance evaluation.

PHYSICAL DEMANDS AND WORK ENVIRONMENT

The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Physical demands: While performing the duties of this job, the employee may be required to sit for long periods of time, is required to stand, walk, use hands to handle or feel objects, tools or controls; reach with hands and arms; climb steps/stairs; balance; stoop, kneel, crouch or crawl; talk or hear; smell; manage stress as it relates to essential job functions. The employee must frequently lift and/or move up to 25 pounds without assistance and may occasionally be required to lift or move up to 50 pounds with assistance. Specific vision abilities required by the job include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to adjust focus.

Work environment: While performing the duties of this job, the employee is exposed to weather conditions prevalent at the time when traveling to various clinic sites. The noise level in the work environment is usually moderate. The employee may be subject to health hazards (contagious diseases, blood borne pathogens, etc.) when working in the clinic area.

In any organization or job, changes take place over time. Although an effort will be made to keep job-related information current, this is not an all-inclusive list of job responsibilities. Adelante Healthcare, Inc. reserves the right to revise or change job duties and responsibilities as the business need arises. In compliance with EEOC 29 CFR part 1630, if the essential functions of this position cannot be performed in a satisfactory manner by the employee, further accommodations shall be made if it does not constitute undue hardships upon this organization.