Data Engineer (4122-1) Milford or Milwaukee, WI hold

ESR Healthcare; Milwaukee (WI); On-site; USD 85,000 - 115,000; Full time

Job summary

A leading company in healthcare technology is looking for a Data Engineer to join their team in Milwaukee. The role involves designing and implementing ETL processes, utilizing AWS tools, and ensuring efficient data management through advanced analytics and cloud technologies. Successful candidates will be adept in data warehousing, data integration, and various database management systems, ready to take on exciting challenges in a dynamic environment.

Qualifications

• Experience with AWS tools and ETL processes is crucial.
• Familiarity with SQL and Unix environments.
• Ability to design and optimize ETL jobs.

Responsibilities

• Design, develop, and implement data warehousing applications.
• Create and maintain ETL pipelines for efficient data processing.
• Work with cloud infrastructure and various databases.

Skills

ETL tools

AWS infrastructure

Python

R

Unix shell scripting

Tools

IBM DataStage

Oracle

DB2

SQL Server

Teradata

Job description

Job Title: Data Engineer (4122-1) - Milford or Milwaukee, WI

Job Summary:

• Design, develop, and implement large-scale and medium-scale data warehousing applications.
• Utilize ETL tools such as IBM Infosphere Information Server DataStage, SQL, and Unix for data processing.
• Work with a broad portfolio of AWS Infrastructure tools (EBS, S3, EC2, Elastic IP, Route 53, VPC) and manage cloud infrastructure automation technologies.
• Handle structured, semi-structured, and unstructured data.
• Engage with modern data and analytics architectures, including Big Data and Cloud technologies.
• Use advanced analytics tools such as Python and R.
• Develop scripts (shell, Python, Ruby) for monitoring and automation tasks.
• Create and maintain efficient ETL pipelines for data extraction, transformation, and loading.
• Design and optimize ETL jobs using IBM DataStage, including familiarity with IIS Suite tools like Information Analyzer and Quality Stage.
• Perform performance tuning of ETL jobs and SQL queries.
• Work with various databases including Oracle (10g/9i/8i), DB2, SQL Server, and Teradata.
• Write PL/SQL stored procedures, functions, and packages.
• Proficient in Unix shell scripting and experienced with Unix operating systems.
• Load data from flat files, XML, Oracle, and DB2 into databases, performing various transactions and transformations using DataStage stages.