See Job Openings

Software and Data Engineer

  • Location: Madison, Wisconsin
  • Type: Contract
  • Job #2304

Carex’s partner is a Madison, WI-based Health Insurer.  They are seeking a Software & Data Engineer to join their team. This position is open to both Contract and Direct Hire Arrangements.  Direct Hire candidates are limited to living in WI, IL, MO, or OK.

What you’ll do:

  • Establish and proof out software development templates and patterns, and develop software for real-time enterprise messaging and API-based data exchange.
  • Collaborate with Enterprise Architects, Data Architects, Database Administrators and Agile Delivery teams on designing and proofing patterns related to ELT (Extract-Load-Transform) and ETL (Extract-Transform-Load) for real-time data through enterprise messaging pipelines with compression and serialization.
  • Collaborate with Data Architects in data modeling for real-time Operational Data Stores
  • Analyze and provide resolutions to all data issues and coordinate with Data Architects, Data Analysts, and other stakeholders the delivery of highly efficient data solutions.
  • Provide technical knowhow and assistance to improve performance on data loads and retrievals from Operational Data Stores (ODS) and Data Warehouses including helping developers write efficient SQL statements
  • Position real time data for utilization within new high performing data pipelines
  • Develop frameworks for unit and performance testing to validate all data flows according to business requirements
  • Employ technologies like Change Data Capture (CDC), Kafka topics and KSQL, AVRO schemas, Spring Data, Hibernate to enable real-time ELT operations and API-based data exchanges.
  • Participate in the design, deployment and configuration of event streaming platforms on premise or running on cloud PaaS, IaaS or SaaS.
  • Design and implement performance tuning capabilities and error handling as they related to data into deliverables, to ensure service levels are met
  • Document data flow diagrams, database diagrams, as well as prepare all relevant project related documentation
  • Incorporate all business requirements into all design specifications

What you’ll bring:

  • Minimum of 5+ years of data focused software development experience is required with progressively challenging activities
  • API software development in Java, .Net or Python
  • ELT or message streaming process experience
  • Experience with real time data integration and real time data tools
  • Experience with designing real time data related APIs
  • Experience and working knowledge of Change Data Capture, Kafka event messaging, schema on demand, object-relational mapping (ORM) and data abstraction layer for real-time data integration
  • Ability to work with business partners, business analysts, other stakeholders to translate business requirements into design documents
  • Ability to develop code in alignment with company technical standards
  • Ability to write unit test cases that align with development changes

Preferred Skills:

  • Experience within Data Architecture, Data Modeling and API software development
  • Experience with KSQL, AVRO, Json, ORM and Spring Data
  • Experience with Oracle GoldenGate CDC, Oracle Goldengate Big Data

#LI-TB1

Attach a resume file. Accepted file types are DOC, DOCX, PDF, HTML, and TXT.

We are uploading your application. It may take a few moments to read your resume. Please wait!