See Job Openings

Lead Data Engineer (Remote)

  • Location: Madison
  • Type: Direct Hire
  • Job #2992

Carex is looking to hire a Lead Data Engineer for a partner.  The Lead Data Engineer is responsible for the design, development, testing, implementation and maintenance of data and analytic solutions. SQL database skills and Business Intelligence/Reporting systems and solution experience are critical. The position performs and oversees definition of data models, identifies sources of master data, drives database administration and development, creates data pipelines, creates CI/CD pipelines, recommends and follows best practices for development, testing, implementation and maintenance of data related activities. This position is also responsible for assisting with troubleshooting and solving advanced production problems as necessary. Identification and implementation of improvements related to issues is key. Work assigned to this position require an in-depth understanding of the business processes and solution requirements, as well as the ability to identify and foresee problems, and the ability to perform analyses to recommend a resolution. Incumbent must be able to work in a changing, fluid environment that is dedicated to continuous improvement.

What you’ll do:

Data, Software, and Analytic Development

  • Produce effective data and analytic solutions, with input from stakeholders that will turn data into knowledge. Formulate specifications and prototypes of: Database Design, Data Model, Data Lineage, ETL, Scheduling and Automation, Reports and Visualizations.
  • Develops in-depth understanding of data environment, including source system data, and leverages knowledge to build robust, scalable solutions.
  • Use testing results from system analysts to identify sources of defects and remedy any issues in the development or production Database and Reporting systems.
  • Develops subject matter expertise (Insurance data and processes/ID3/LifePro) and applies to development of solutions.
  • Performs data research / profiling and applies results to solution design. Stays abreast of data privacy and security requirements and incorporates into data model and data designs.
  • Collaborates with developers to transform backlog items into high-functioning, well-designed, testable and efficient code. Ensure data is secure throughout full lifecycle.
  • Write and maintain technical documentation to describe BI and Data Warehouse development, logic, coding, testing, changes, history and corrections.
  • Perform code/design reviews; strive for continuous improvement of code quality and development practices
  • Build and implement test automation to validate new and existing code
  • Provide architectural, technical and systems expertise in the design, development, implementation, evaluation and upgrade of software, systems and solutions.
  • Evaluate and recommend tools and methods to improve Database Systems management and automation.

Production Support

  • Perform routine and non-routine database maintenance and upgrades to make systems more secure and efficient, and to adapt them to any new requirements.
  • Document processes and train BI Database Developers to ensure they fully understand and can perform maintenance on all of NGL’s SQL databases and database applications.
  • Anticipate system/application challenges and propose solutions; recommend improvements to existing database servers and software as necessary.
  • Ensure all database servers are backed up, Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
  • Plan and perform maintenance of NGL’s SQL databases and database applications.
  • When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
  • Install and configure new SQL Servers,
  • Troubleshoot and resolve outages and database issues for both internal and third-party business customers, including after-hours and weekends.
  • Assist with issue identification, investigation, and resolution process of support incidents.
  • Provide off-hours support of scheduled production processing and system maintenance.

M&A Support

  • Collaborate with the team and business areas to develop, coordinate and execute plans to ensure successful acquisition project. Identify new data sources, data redundancy, and develop plans to incorporate data into enterprise data environment.
  • Participate in efforts to convert and implement merged or acquired business.


  • Share ownership of the solution deployment, testing, quality, monitoring and operational excellence with the rest of the team.
  • Participate in team ceremonies, meetings, and presentations to stakeholders.
  • Continually develop skill-sets and abilities to keep them relevant, current and applicable to NGL's current and future needs.
  • Follow software development life cycle and quality assurance best practices and governance.
  • Ensure data security and data privacy stay top of mind across team
  • Perform other duties and responsibilities as needed.
  • Mentor peers in Data Engineering and best practices / patterns
  • Follow software development life cycle and quality assurance best practices and governance.
  • Ensure data security and data privacy stay top of mind across team
  • Perform other duties and responsibilities as needed.
  • Mentor peers in Data Engineering and best practices / patterns

What you’ll bring:

  • Critical thinking; analytical, decision-making, and problem-solving skills; strong technical and non-technical communication (verbal and written) and interpersonal skills; ability to work independently and in a team; excellent organizational skills and time/priority management; ability to understand high-level architecture and design content, and how it relates to implementation deployment; advanced knowledge and understanding of relevant business and system operations, policies, and procedures; ability to disagree with coworkers and come to an agreement.
  • Preferred: Bachelor's degree in Computer Science Information Technology/systems, or other related field, or 5 years equivalent work experience.
  • PostgreSQL and Transact-SQL
  • Python
  • Tableau
  • AWS Glue, Lambda, S3, Redshift, EC2
  • Transact-SQL and SQL Server Management Studio
  • SSIS/ SSRS development
  • SSAS Multidimensional and Tabular
  • Iac using CloudFormation or Terraform??


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!