Data Engineer

Description

Snowflake

Ab Initio

SQL

Healthcare background preferred

Responsibilities

• Document and test moderate data systems that integrate data from disparate sources, making it available to data scientists and other users.
• Write and refine code to ensure performance and reliability of data extraction and processing.
• Participate in requirements-gathering sessions with business and technical staff to distill technical requirements from business needs.
• Develop SQL queries to extract data for analysis and model construction.
• Own delivery of moderately sized data engineering projects.
• Design and develop scalable, efficient data pipeline processes for data ingestion, cleansing, transformation, integration, and validation.
• Ensure performance and reliability of data processes.
• Document and test data processes, including performing data validation and verification.
• Collaborate with cross-functional teams to resolve data quality and operational issues, ensuring timely delivery of products.
• Develop and implement scripts for database and data process maintenance, monitoring, and performance tuning.
• Analyze and evaluate databases to identify and recommend improvements and optimization.

Educational Requirements

• Bachelor’s degree and 3 years of experience with Data Integration, Data Warehouses, Operational Data Stores, Data Lakes, and Big Data platforms; or 5 years of the same experience in lieu of a degree.
• Direct experience with at least one ETL development language/technology such as Ab Initio, DataStage, Informatica, Python, or R.
• Advanced SQL knowledge and experience with database technologies like Snowflake, DB2, and AWS.