Data Engineer Snowflake, DBT and Epic Clarity

Not Interested
Bookmark
Report This Job

profile Job Location:

New Orleans, LA - USA

profile Monthly Salary: Not Disclosed
Posted on: 19 hours ago
Vacancies: 1 Vacancy

Job Summary

Weve made a lot of progress since opening the doors in 1942 but one thing has never changed - our commitment to serve heal lead educate that every award earned every record broken and every patient helped is because of the dedicated employees who fill our hallways.

At Ochsner 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. The requirements listed below are representative of the knowledge skill and/or ability required. 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 companys discretion.

Education

Required - Bachelors degree in computer science management information systems (MIS) business or related field.

Preferred Masters degree in computer science or related field.

Work Experience

Required -

  • 6 years of professional experience in data engineering or equivalent role with experience in DevOps 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 FinOps 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 teams 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.

Job Duties

  • 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 organizations analytical and operational needs. Provides insights monitors applications handles user tickets and analyzes and resolves data issues.

  • Owns and supports data pipelines that power the organizations 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 organizations 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 practices.

  • Supports and monitors data management and/or business intelligence systems and processes.

  • May assist with administering business intelligence server(s) and/or processes.

  • Serves as a technical resource and support to multiple teams.

  • Performs other related duties as assigned.

The above statements describe the general nature and level of work only. They are not an exhaustive list of all required responsibilities duties and skills. Other duties may be added or this description amended at any time.

Remains knowledgeable on current federal state and local laws accreditation standards or regulatory agency requirements that apply to the assigned area of responsibility and ensures compliance with all such laws regulations and standards.

This employer maintains and complies with its Compliance & Privacy Program and Standards of Conduct including the immediate reporting of any known or suspected unethical or questionable behaviors or conduct; patient/employee safety patient privacy and/or other compliance-related concerns. The employer is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race color religion sex sexual orientation gender identity national origin protected veteran status or disability status.

Physical and Environmental Demands

The physical demands 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.

Medium Work - Exerting 20 to 50 pounds of force occasionally and/or 10 to 25 pounds of force frequently and/or greater than negligible up to 10 pounds of force constantly to move objects. (Constantly: activity or condition exists 2/3 or more of the time) to move objects. Physical demand requirements are in excess of those for Sedentary Work. Even though the weight lifted may be only a negligible amount a job should be rated Light Work: (1) when it requires walking or standing to a significant degree; or (2) when it requires sitting most of the time but entails pushing and/or pulling of arm or leg controls; and/or (3) when the job requires working at a production rate pace entailing the constant pushing and/or pulling of materials even though the weight of those materials is negligible. NOTE: The constant stress and strain of maintaining a production rate pace especially in an industrial setting can be and is physically demanding of a worker even though the amount of force exerted is negligible.

Normal routine involves no exposure to blood body fluid or tissue and as part of their employment incumbents are not called upon to perform or assist in emergency care or first aid.

The incumbent has no occupational risk for exposure to communicable diseases.

Because the incumbent works within a healthcare setting there may be occupational risk for exposure to hazardous medications or hazardous waste within the environment through receipt transport storage preparation dispensing administration cleaning and/or disposal of contaminated waste. The risk level of exposure may increase depending on the essential job duties of the role.

Are you ready to make a difference Apply Today!

Ochsner Health does not consider an individual an applicant until they have formally applied to the open position on this careers website.

Please refer to the job description to determine whether the position you are interested in is remote or on-site. Individuals who reside in and will work from the following areas are not eligible for remote work position: Colorado California Hawaii Illinois Maryland Massachusetts Minnesota New Jersey New York Vermont Washington and Washington D.C.

Ochsner Health endeavors to make our site accessible to all users. If you would like to contact us regarding the accessibility of our website or if you need an accommodation to complete the application process please contact our HR Employee Solution Center at (select option 1) or. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications.

Ochsner is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to any legally protected class including protected veterans and individuals with disabilities.


Required Experience:

IC

Weve made a lot of progress since opening the doors in 1942 but one thing has never changed - our commitment to serve heal lead educate that every award earned every record broken and every patient helped is because of the dedicated employees who fill our hallways. At Ochsner whether you work with ...
View more view more

Key Skills

  • Apache Hive
  • S3
  • Hadoop
  • Redshift
  • Spark
  • AWS
  • Apache Pig
  • NoSQL
  • Big Data
  • Data Warehouse
  • Kafka
  • Scala