Data Engineer - Snowflake, DBT and Epic Clarity

Overview

We ve made a lot of progress since opening the doors in 1942, but one thing has never changed - our commitment to serve, heal, lead, educate, and innovate. We believe that every award earned, every record broken and every patient helped is because of the dedicated employees who fill our hallways. At Ochsner Health, whether you work with patients every day or support those who do, you are making a difference and that matters.

Come make a difference at Ochsner Health and discover your future today!

This role designs, builds, and maintains data sources and pipelines for consumption by various analytical and business units. It collects, manages, and converts raw data into usable data sets accessible by developers and analysts. It automates, documents, and improves existing manual processes.

• Owns and supports data pipelines that power the organization s analytical and operational needs. Provides insights, monitors applications, handles user tickets, and analyzes and resolves data issues.
• Applies data expertise to help architect, build, and launch scalable data pipelines to support the organization s growing data processing and analytics needs.
• Provides production support to resolve critical data pipeline and application issues, mitigating or minimizing any impact on data products and downstream analytics tools.
• Works with functional departments to understand their priorities and requirements and translates them to develop and implement data solutions to assist with their objectives.
• Maintains and develops documentation to identify and define processes or procedures.
• Manages data by following enterprise and industry best practices.
• Supports and monitors data management and/or business intelligence systems and processes.
• Performs other related duties as assigned.

Education

• Required — Bachelor s degree in computer science, management information systems (MIS), business, or related field.
• Preferred — Master s degree in computer science or related field.

Work Experience

• Required — 6+ years of professional experience in data engineering or equivalent role with experience in Dev Ops capabilities (version control, automated builds, and release management tools using Azure Devops, Git, Jenkins, etc.). Of the required experience, the following should also be met:
• 3 years of experience in SQL development.
• 3 years of direct experience working with various relational databases (e.g. Oracle, SQL Server, Oracle Exadata, Teradata, etc.).

• Demonstrated Experience In The Following Areas
• Cloud computing (e.g., Microsoft Azure, AWS, Google Cloud).
• Building and orchestrating data pipelines and models using DBT/Airflow and/or Azure Data Factory (ADF) on Snowflake.
• Programming languages (e.g., Java, Python, PySpark, Scala).
• Agile Development experience

• Preferred
• Experience with Dimension modelling and ETL design
• Hands-on experience with performance tuning of SQL code and data pipelines
• Experience in cloud-based lake houses such as Snowflake, Databricks, AWS Athena etc.
• Experience with on-prem and relational database platforms like Oracle, SQL Server, and integration of Azure/Snowflake services with on-premises and other cloud technologies like AWS, GCP etc.
• Experience in leveraging Observability tools such as Splunk/Datadog or equivalent.
• Experience with Fin Ops and optimizing Snowflake compute
• Experience with acquisition and integration of semi-structured and unstructured datasets e.g. JSON, Parquet, HL7, FHIR messages, audio files, transcripts etc.
• Healthcare domain knowledge

• Knowledge
  
  Skills And Abilities
  
  (KSAs)
• Ability to develop, deploy, and maintain batch scripts and processes.
• Ability to transform raw data into usable, accurate and scalable data sets.
• Ability to see improvement opportunities and act on them.
• Knowledge of business intelligence concepts and ability to collaborate with end users to define data requirements.
• Advanced SQL skills and ability to quickly learn other scripting languages depending on team s needs.
• Knowledge of existing and emerging hardware and software technologies and an aptitude for learning new technical skills quickly.
• Ability to work independently and proactively in a fast-paced,…