Data Engineer

1 week ago

Lincoln, NE, United States United IT Solutions Full time
Title: Data Engineer
Location: Lincoln, Nebraska - Remote

Local Candidates or nearby States Only

Job Summary:

We are seeking a highly experienced Data Engineer to support the development and maintenance of an AWS-based Data Warehouse that enables advanced business analytics and reporting in a Medicaid data environment. The engineer will be responsible for developing and managing ETL/data pipeline jobs, transforming data to align with defined DB2 Warehouse schemas, and ensuring consistent data quality and availability for downstream Cognos reports. The role involves working with IBM DataStage, DB2 Warehouse, and AWS-native services to deliver performant and reliable data solutions.

Key Responsibilities:
• Design, develop, and maintain ETL pipelines using IBM DataStage to ingest and transform Medicaid-related data.
• Implement batch and incremental data jobs to populate DB2 Warehouse target tables in alignment with reporting and analytics requirements.
• Support data modeling activities to ensure data structures meet the needs of Cognos reports and business users.
• Collaborate with business analysts, report developers, and data stewards to translate reporting requirements into data solutions.
• Conduct data profiling, validation, and cleansing activities to ensure data accuracy, completeness, and consistency.
• Utilize AWS services (e.g., S3, EC2, Glue, Lambda) where applicable to enhance data processing and orchestration capabilities.
• Monitor data job performance and troubleshoot issues to maintain operational SLAs.
• Maintain technical documentation and data flow diagrams for ETL jobs and target schemas.
• Support testing, deployment, and version control of data jobs in DEV, TEST, and PROD environments.
• Ensure compliance with HIPAA and Medicaid data security and privacy requirements.

Required Qualifications:
• Minimum 7 years of experience in Data Engineering, ETL development, or Data Warehousing.
• Hands-on experience with IBM DataStage or a similar ETL tool in a production environment.
• Proficiency with DB2 Warehouse including writing complex SQL queries, stored procedures, and schema design.
• Familiarity with AWS Cloud architecture and services relevant to data processing (e.g., S3, Glue, Lambda, CloudWatch).
• Strong analytical and troubleshooting skills; ability to work with large datasets and optimize performance.
• Experience supporting Cognos or similar BI/reporting tools in data preparation.
• Understanding of data governance, metadata management, and regulatory compliance (e.g., HIPAA).
• Proficiency in shell scripting or Python for job orchestration is a plus.

Preferred Qualifications:
• Experience with Medicaid data and Medicaid Data Warehouses is strongly preferred.
• AWS certification (e.g., AWS Certified Data Analytics - Specialty, AWS Solutions Architect Associate).
• IBM Data Stage Certifications
• Familiarity with Agile/Scrum methodologies and Jira/Confluence tools.

  • Data Engineer

    5 days ago

    Lincoln, NE, United States FMNE Insurance Company Full time

    FMNE Insurance (Formerly Farmers Mutual of Nebraska) is seeking a Data Engineerforour IT Department. - an exceptional individual who is intuitive, motivated, and skilled. We're experiencing incredible growth and are on the search for individuals who would like to grow with us. With a competitive salary and excellent benefits package, expanding beyond health...

  • Data Engineer

    7 days ago

    Lincoln, NE, United States FMNE Insurance Company Full time

    FMNE Insurance (Formerly Farmers Mutual of Nebraska) is seeking a Data Engineerforour IT Department. - an exceptional individual who is intuitive, motivated, and skilled. We're experiencing incredible growth and are on the search for individuals who would like to grow with us. With a competitive salary and excellent benefits package, expanding beyond health...

  • Data Engineer

    1 day ago

    Lincoln, NE, United States FMNE Insurance Company Full time

    FMNE Insurance (Formerly Farmers Mutual of Nebraska) is seeking a Data Engineerforour IT Department. - an exceptional individual who is intuitive, motivated, and skilled. We're experiencing incredible growth and are on the search for individuals who would like to grow with us. With a competitive salary and excellent benefits package, expanding beyond health...

  • Data Engineer

    3 days ago

    Lincoln, NE, United States FMNE Insurance Company Full time

    FMNE Insurance (Formerly Farmers Mutual of Nebraska) is seeking a Data Engineerforour IT Department. - an exceptional individual who is intuitive, motivated, and skilled. We're experiencing incredible growth and are on the search for individuals who would like to grow with us. With a competitive salary and excellent benefits package, expanding beyond health...

  • Data Engineer

    2 days ago

    Lincoln, NE, United States FMNE Insurance Company Full time

    FMNE Insurance (Formerly Farmers Mutual of Nebraska) is seeking a Data Engineerforour IT Department. - an exceptional individual who is intuitive, motivated, and skilled. We're experiencing incredible growth and are on the search for individuals who would like to grow with us. With a competitive salary and excellent benefits package, expanding beyond health...

  • Senior Data Engineer

    4 days ago

    Lincoln, NE, United States Nebraska Staffing Full time

    Software Engineer Specializing In Data Engineering We're looking for an experienced software engineer specializing in data engineering to join our growing team focused on building, supporting, and enhancing the OCI Data Center telemetry big data and analytics platform. This platform is at the heart of driving hardware quality, reliability, and efficiency as...

  • Senior Data Engineer

    5 days ago

    Lincoln, NE, United States Nebraska Staffing Full time

    Software Engineer Specializing In Data Engineering We're looking for an experienced software engineer specializing in data engineering to join our growing team focused on building, supporting, and enhancing the OCI Data Center telemetry big data and analytics platform. This platform is at the heart of driving hardware quality, reliability, and efficiency as...

  • Senior Data Engineer

    3 days ago

    Lincoln, NE, United States Nebraska Staffing Full time

    Software Engineer Specializing In Data Engineering We're looking for an experienced software engineer specializing in data engineering to join our growing team focused on building, supporting, and enhancing the OCI Data Center telemetry big data and analytics platform. This platform is at the heart of driving hardware quality, reliability, and efficiency as...

  • Senior Data Engineer

    3 days ago

    Lincoln, NE, United States Nebraska Staffing Full time

    Software Engineer Specializing In Data Engineering We're looking for an experienced software engineer specializing in data engineering to join our growing team focused on building, supporting, and enhancing the OCI Data Center telemetry big data and analytics platform. This platform is at the heart of driving hardware quality, reliability, and efficiency as...

  • Senior Data Engineer

    4 days ago

    Lincoln, NE, United States opendorse Full time

    Senior Data Engineer Location Remote (US-based) or at our headquarters in Lincoln, Nebraska Overview At Opendorse, we sit on more athlete and NIL data than anyone in the industry - and we're just getting started. As the leading platform for athlete-brand partnerships, we've helped more than 140,000 athletes and thousands of brands connect and thrive in...