Data Engineer (Redshift)- $130K (Tampa / 3 days onsite)

Confidential Jobs; Orlando (FL); On-site; USD 80,000 - 120,000; Full time

Job summary

Join a forward-thinking company as a Data Engineer where you'll play a crucial role in developing and maintaining robust data warehouse solutions. This full-time position emphasizes your expertise in Amazon Redshift and AWS services, allowing you to create insightful reports with Amazon QuickSight. You'll work with both structured and unstructured data, ensuring data integrity and high performance. This role is perfect for those passionate about data engineering and looking to make a significant impact in the IT services industry. If you have a strong background in data warehousing and are ready to take on new challenges, this opportunity is for you.

Qualifications

• 7+ years of experience in data engineering with a focus on data warehouse development.
• Strong background in SQL and Amazon Redshift; QuickSight experience is a plus.

Responsibilities

• Design and maintain data warehouse solutions using Amazon Redshift.
• Develop ETL processes to enhance data extraction and transformation.

Skills

Data Engineering

SQL

Data Warehouse Architecture

ETL Processes

Data Modeling

Healthcare Data (FHIR, HEDIS, HL7)

Education

Bachelor's Degree in Computer Science or related field

Tools

Amazon Redshift

Amazon QuickSight

AWS Glue

AWS Lambda

AWS Step Functions

AWS Athena

AWS DMS

MySQL

Job description

This is a full-time permanent position that will focus on the development, implementation, and maintenance of our data warehouse using Amazon Redshift. The ideal candidate will have a strong background in data engineering, experience with AWS infrastructure, and expertise in managing data sourced from structured and unstructured data sources. Additionally, you will be responsible for creating insightful reports using Amazon QuickSight.

Duties:

• Design, develop, and maintain robust data warehouse solutions utilizing Amazon Redshift.
• Define, create, and optimize ETL processes to enhance data extraction, transformation, and loading using AWS services.
• Develop and maintain data pipelines and workflows using AWS tools such as Glue, Lambda, Step Functions, Athena, DMS, Redshift, and others.
• Utilize Amazon QuickSight to design, develop, and publish dynamic reports and dashboards for business analytics.
• Maintain data integrity and ensure high availability and performance of data storage systems.
• Implement data governance practices to ensure compliance and security of data assets.

Required:

• Minimum of 7 years’ experience as a Data Engineer, with a focus on data warehouse architecture and development.
• SQL, Amazon Redshift are required. QuickSight experience is a PLUS
• Experience with Healthcare data (FHIR, HEDIS, HL7) is preferred.
• Familiarity with data extraction and transformation using MySQL databases and Parquet files.
• Strong understanding of data modeling, database management, and data warehousing concepts.
• Experience with ETL tools and frameworks.
• Permanent Work Authorization in the US is required.

Seniority level

Mid-Senior level

Employment type

Full-time

Job function

Information Technology

Industries

IT Services and IT Consulting