Data Engineer - Snowflake, DBT and Epic Clarity

Overview

We2039;s commitment to serve, heal, lead, educate, and innovate continues to drive our work. 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 job designs, builds, and maintains data sources and pipelines for consumption by various analytical and business units. Collects, manages, and converts raw data into usable data sets accessible by developers and analysts. Automates, documents, and improves existing manual processes.

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential duties.

This job description is a summary of the primary duties and responsibilities of the job and position. It is not intended to be a comprehensive or all-inclusive listing of duties and responsibilities. Contents are subject to change at the company
039;s discretion.

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

• 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.).
• Required - 3 years of experience in SQL development.
• Required - 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 modeling 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).

• Healthcare domain knowledge is preferred.

• 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
  027s 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, dynamic environment while delivering outstanding customer-focused solutions.
• Ability to think outside the box when designing new approaches and solutions.
• Knowledge of dimensional modeling, ETL processes, and tools.
• Effective verbal and written communication skills and ability to present information clearly and professionally.
• Excellent problem-solving, organization, prioritization, and time management skills.
• Ability to effectively manage multiple demands in a rapidly changing, team-based environment.

• Works with functional departments to understand their priorities and requirements and translates them to develop and implement data solutions to assist with their objectives.
• Provides expertise in all facets of logical modeling and presentation solutions including prototyping and proof of concept, using best practices within the business intelligence and data management environments.
• Maintains and develops documentation to identify and define processes or procedures.
• Owns and supports data pipelines that power the organization
  027s 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
  027s 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.
• Manages data by following enterprise and industry best…