Expert Data Engineer

Jobs via Dice

Lincoln (NE)

Remote

USD 112,597 - 152,810

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

A leading company is seeking an Expert Data Engineer to design ETL jobs and optimize data processing workflows. In this mid-senior level role, you will work closely with business intelligence teams to ensure efficient data extraction and reporting in IBM Cognos Analytics. Candidates should have strong expertise in DB2 and AWS, along with experience in data warehousing. Apply now for this full-time position in Lincoln, Nebraska, with a competitive salary.

Qualifications

5+ years of experience in ETL development and data warehousing.
Strong hands-on experience with AWS services (S3, RDS).
Expertise in DB2 including SQL and performance tuning.

Responsibilities

Design and maintain ETL jobs for DB2 data warehouse.
Optimize data processing workflows using AWS.
Manage large-scale data migration projects.

Skills

ETL development

Data engineering

AWS services

DB2 database development

SQL

Python

Analytical skills

Problem-solving

Education

Bachelor's degree in computer science

Job description

Join to apply for the Expert Data Engineer role at Jobs via Dice

1 day ago Be among the first 25 applicants

Join to apply for the Expert Data Engineer role at Jobs via Dice

Get AI-powered advice on this job and more exclusive features.

Dice is the leading career destination for tech experts at every stage of their careers. Our client, INFT Solutions inc, is seeking the following. Apply via Dice today!

Job Title: Expert Data Engineer - 64439

Duration: 12+ Months

Location: Remote /Lincoln, Nebraska

Job Summary:

We are seeking a skilled Data Engineer with AWS experience to design and develop ETL jobs for a DB2 data warehouse to support Cognos reporting needs. The ideal candidate will work closely with business intelligence teams to ensure efficient data extraction, transformation, and loading processes while optimizing database performance. This role requires strong expertise in DB2, AWS, and ETL development.

Key Responsibilities:

Design, develop, and maintain ETL jobs to ingest, transform, and load data into the DB2 data warehouse for Cognos reporting.
Utilize AWS services (S3, EC2, RDS, Step Functions, etc.) to optimize data processing workflows.
Implement best practices for data modeling to ensure efficient reporting in IBM Cognos Analytics.
Work with business and reporting teams to gather data transformation requirements and build pipelines accordingly.
Develop and optimize SQL queries, stored procedures, and indexing strategies for DB2.
Ensure data integrity, quality, and performance tuning of ETL processes.
Manage large-scale data migration and integration projects between cloud and on-prem DB2 systems.
Automate data workflows using AWS services.
Monitor, troubleshoot, and optimize ETL processes for performance and reliability.
Support Cognos report developers in structuring data efficiently to meet reporting needs.
Implement security, compliance, and data governance best practices for handling sensitive data.

Qualifications:

5+ years of experience in ETL development, data engineering, and data warehousing.
Strong hands-on experience with AWS services (S3, RDS, Redshift, etc.).
Expertise in DB2 database development, including SQL, stored procedures, and performance tuning.
Proficiency in Python or Shell scripting for automation.
Experience with IBM Cognos Analytics and understanding of reporting structures.
Strong problem-solving, analytical, and communication skills.
Experience working in Agile and DevOps environments.

Preferred Qualifications:

Bachelor's degree in computer science, Information Systems, or a related field.
Experience in Medicaid and/or Healthcare Plan environment is strongly preferred.
Knowledge of DB2 on AWS Cloud.
AWS Certified Data Analytics Specialty or AWS Certified Solutions Architect is a plus.

Seniority level