It's more than a career, it's a calling.
MO-SSM Health Mission Hill
Worker Type : Contractor
Contractor
Job Summary :
Independently formulates and defines system scope based upon defined data functional requirements. Devises Extract Transform, Load (ETL) and Extract, Load, and Transform (ELT) components to solve complex problems.
Works with peers to ensure highly robust and sustainable solutions are devised with low maintenance requirements. Populates technical specifications leveraging defined templates based upon business requirements.
Participates in sprint activities through designing, coding, debugging, testing, and documenting ETL / ELT resources constructed.
Independently creates extracts, imports, and APIs. May work with SQL Server Integration Services, Microsoft Data Factory, and interface engines.
Establishes tables with indices with pre-calculated datasets to augment BI activities. Provides input on team strategy and vision.
Supports and helps manage external resources, such as service providers and vendor support. Participates in strategic and tactical planning discussions.
Job Responsibilities and Requirements :
PRIMARY RESPONSIBILITIES
- Works autonomously to define and create ETL / ELT (Extract, Transform, Load / Extract, Load, Transform) resources.
- May work directly with subject matter experts to define or troubleshoot data migration issues.
- Works with external partners to ensure the health of data extracts.
- Possesses an understanding of PHI / PII (Protected Health Information / Personally Identifiable Information) principles and how they apply to data engineering.
- Collaborates with peers, team and functional leaders to categorize and segregate data. Provides guidance and training to less experienced staff.
- Develops templates and standards for ETL / ELT (Extract, Transform, Load / Extract, Load, Transform) development.
- Possesses a strong understanding of existing ETL / ELT processes and can quickly troubleshoot and remediate issues.
- Exhibits an understanding of health system data, principles, and coding standards (CPT, ICD, LOINC).
- Reviews new technologies and makes recommendations for adoption to management.
- Performs other duties as assigned.
EDUCATION
Bachelor’s degree
EXPERIENCE
Six years’ experience
PHYSICAL REQUIREMENTS
- Frequent lifting / carrying and pushing / pulling objects weighing 0-25 lbs.
- Frequent sitting, standing, walking, reaching and repetitive foot / leg and hand / arm movements.
- Frequent use of vision and depth perception for distances near (20 inches or less) and far (20 feet or more) and to identify and distinguish colors.
- Frequent use of hearing and speech to share information through oral communication. Ability to hear alarms, malfunctioning machinery, etc.
- Frequent keyboard use / data entry.
- Occasional bending, stooping, kneeling, squatting, twisting and gripping.
- Occasional lifting / carrying and pushing / pulling objects weighing 25-50 lbs.
- Rare climbing.
Work Shift :
Day Shift (United States of America)
Job Type : Contingent Worker
Contingent Worker
Decision Support Analyst (Data Engineer)
Performs modeling of data sources and flows, works with data management staff to define an operational framework that will define, develop and implement policies and security frameworks to ensure precise and secure delivery of knowledge and information. Perform modeling of data sources and flows, wo...
Senior Civil Engineer - Data Center
As a Senior Civil Engineer on our Data Center Civil Team, you will be a part of the firm’s largest and most complex projects. Olsson currently has several opportunities for a Senior Civil Engineer to support our Data Center Site Design group. You will serve as a project manager on some projects and ...
Sr. Data Engineer - Remote
SQL and/or Python for data warehouse management, data integration, and data lake management Expert proficiency in Microsoft SQL Server OLAP solutions and/or Azure Synapse Analytics, Deep working knowledge in SQL development using T-SQL code to design, implement, and optimize complex database objects...
Analytic Data Engineer – Databricks
This role within the 'Data Engineering & Self-Service Products' team involves architecting and engineering analytic data solutions, including designing and developing data marts in Databricks using PySpark or Spark SQL, building interactive Power BI dashboards to visualize KPIs and trends, and creat...
AWS Data Engineer
A leading IT Consultancy are looking to strengthen their Data Engineering team, the successful candidate will have hands-on design and engineering background in AWS, across a wide range of AWS services with the ability to demonstrate working on large engagements. Experience of developing enterprise ...
Senior Data Engineer
Work closely with data analysts, data scientists, and other stakeholders to understand data requirements and deliver robust data solutions. The ideal candidate will possess extensive expertise in data warehousing, ETL processes, cloud-based data platforms, SQL, Python programming, data visualization...
Senior Civil Engineer - Data Center
As a Senior Civil Engineer on our Data Center Civil Team, you will be a part of the firm’s largest and most complex projects. Olsson currently has several opportunities for a Senior Civil Engineer to support our Data Center Site Design group. We are Olsson, a team-based, purpose-driven engineering a...
Data Engineer
Possesses an understanding of PHI/PII (Protected Health Information/Personally Identifiable Information) principles and how they apply to data engineering. Independently formulates and defines system scope based upon defined data functional requirements. May work with SQL Server Integration Services...
Data Engineer II
This position is responsible for designing, evaluating, and creating systems to support data science projects across the O'Reilly organization, as well as expanding and optimizing our data and data pipeline architecture. Build processes supporting data transformation, data structures, metadata, depe...
Sr Business Intelligence Data Engineer
Excellent knowledge of data warehouse concepts, technologies, and best business practices to include data sourcing, data transformation, data loading, data cleansing, data integrity checking, and end-user tools. The Sr Business Intelligence Data Engineer is responsible for the delivery of the corpor...