Sign upLog in
See more jobs

Engineer Data Intelligence/Business Analytics

OSTechnical
  • Irvine, CA
  • Quick Apply
11 days ago

Job Description


Engineer Data Intelligence/Business Analytics


The Engineer, Data Management and Analytics designs and develops scalable ETL/ELT pipelines leveraging Snowflake, dbt, and Matillion, with a focus on healthcare data (including Epic). This role incorporates AI-driven techniques to improve data quality, pipeline efficiency, and intelligent data processing.
  1. Partner with Data Warehouse Product Owner and BSA to translate healthcare business requirements (including Epic data) into scalable ETL solutions.
  2. Collaborate with Data Architect to design Snowflake-based data models supporting analytics and AI use case.
  3. Build and maintain ETL/ELT pipelines using Matillion, dbt and Python to ingest and transform data from Epic Clarity, APIs, and third-party systems.
  4. Apply AI-driven techniques for automated data mapping, anomaly detection, and schema drift identification within pipelines.
  5. Develop reusable frameworks for logging, monitoring, and data quality validation using intelligent rules and pattern detection .
  6. Optimize Snowflake performance (partitioning, clustering, cost optimization) for both BI and AI workloads .
  7. Enable feature engineering by preparing curated datasets for downstream machine learning use cases .
  8. Leverage AI-assisted development tools to accelerate SQL/dbt/Python model development and pipeline automation.
  9. Implement data observability practices to proactively identify pipeline failures and data inconsistencies.
  10. Ensure compliance with healthcare data governance standards (HIPAA) and responsible AI usage.
  11. Other duties as assigned.
REQUIRED:
  • Bachelor's degree or equivalent experience.
  • 2+ years in data engineering with strong ETL/ELT experience.
  • Hands-on experience with Snowflake.
  • Strong SQL skills and experience with dbt or Matillion.
  • Experience building cloud-based data pipelines.
  • Foundational understanding of AI/ML concepts related to data preparation and feature engineering.
  • Experience with Git-based source control and CI/CD pipelines.
  • Experience in data integration from disparate sources: third party vendor data and/or API calls.
PREFERRED:
  • Experience integrating Epic (Clarity/Caboodle) data models or related healthcare data .
  • Experience in Microsoft SSIS.
  • Experience with Microsoft Fabric
  • Experience using Python for data integration and analysis.
  • Experience with data observability tools and anomaly detection frameworks.
  • Exposure to MLOps practices and model data pipeline support.
  • Experience with Kafka or streaming ingestion frameworks
  • Experience using AI copilots or automation tools in development workflows
  • Experience with Cloud Lakehouse experience for any of the Cloud vendors (AWS, Azure, GCP)
  • Experience with Enterprise orchestration tools like Airflow, Dagster.

KNOWLEDGE/SKILLS/ABILITIES :
  • Strong problem-solving skills with ability to optimize complex ETL pipelines.
  • Demonstrated excellent interpersonal, verbal and written communication skills.
  • Detail oriented, organized, customer/process focused, problem resolution, and proactive.
  • Ability to draw conclusions and make independent decisions with limited information.
  • Ability to respond to common inquiries from customers, staff, regulatory agencies, vendors, and other members of the business community.
  • Ability to be self-motivated, reliable, work independent, as part of a team, and work effectively with all levels within the organization.
  • Demonstrated intellectual curiosity and willingness to adopt emerging AI technologies.
  • Demonstrated change management in a fast-paced environment under time constraints.
  • Ability to work with mathematical concepts: probability and statistical inference.
  • Ability to effectively simplify complex data and communicate information to leadership.

Numbers & Facts

LocationIrvine, CA

Skills

  • Amazon Web Services (AWS)unmatched
  • Application Programming Interface (API)unmatched
  • Architectural Designunmatched
  • Artificial Intelligence (AI)unmatched
  • Automationunmatched
  • Business Analysisunmatched
  • Business Intelligenceunmatched
  • Change Managementunmatched
  • Cloud Computingunmatched
  • Communication Skillsunmatched
  • Computer Networksunmatched
  • Continuous Deployment/Deliveryunmatched
  • Continuous Integrationunmatched
  • Cost Controlunmatched
  • Data Analysisunmatched
  • Data Managementunmatched
  • Data Mappingunmatched
  • Data Modelingunmatched
  • Data Processingunmatched
  • Data Qualityunmatched
  • Data Warehousingunmatched
  • DataArchitect Data Modeling Toolunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • Detail Orientedunmatched
  • Emerging Technologyunmatched
  • Epic Caboodleunmatched
  • Epic Clarityunmatched
  • Epic Systemsunmatched
  • GCP (Good Clinical Practices)unmatched
  • Gitunmatched
  • HIPAA (Health Insurance Portability and Accountability Act)unmatched
  • Healthcareunmatched
  • Interpersonal Skillsunmatched
  • Leadershipunmatched
  • Machine Learningunmatched
  • Maintain Complianceunmatched
  • Mathematicsunmatched
  • Microsoft Product Familyunmatched
  • Microsoft Windows Azureunmatched
  • Organizational Skillsunmatched
  • Performance Tuning/Optimizationunmatched
  • Presentation/Verbal Skillsunmatched
  • Problem Solving Skillsunmatched
  • Process Improvementunmatched
  • Programming Toolsunmatched
  • Python Programming/Scripting Languageunmatched
  • Quality Managementunmatched
  • Quality Monitoringunmatched
  • Regulationsunmatched
  • SQL (Structured Query Language)unmatched
  • SQL Server Integration Services (SSIS)unmatched
  • Sales Pipelineunmatched
  • Scalable System Developmentunmatched
  • Snowflake Schemaunmatched
  • Source Code/Configuration Management (SCM)unmatched
  • Team Playerunmatched
  • Training Data Setsunmatched
  • Use Casesunmatched
  • Writing Skillsunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder