Senior Data Engineer

$151,323 - $155,000/Yr

Cna - Chicago, IL

posted about 2 months ago

Full-time
Remote - Chicago, IL
Professional, Scientific, and Technical Services

About the position

CNA is seeking an individual contributor who will provide a high level of expertise in the design, development, and integration of strategic, high-priority data applications across the entire software development lifecycle, particularly in an Agile environment. This role is crucial for building large-scale data processing systems and data lakes that are optimized for both computational and storage efficiency on the Google Cloud Platform. The successful candidate will be responsible for creating ETL processes that build warehouse tables to facilitate reporting on Insurance Policy and Claim domain data from Policy and Claim processing systems. In addition to these responsibilities, the role involves designing and implementing complex physical data models on columnar cloud databases such as BigQuery. The individual will lead the design, implementation, and automation of data pipelines that source data from both internal and external systems, transforming the data to meet the optimal needs of various systems and business requirements. A key aspect of this position is to ensure that robust unit testing is conducted to verify that deliverables match the design specifications, while also providing expertise to support subsequent release testing. The candidate will actively adhere to established quality and reliability standards, ensuring that the team also maintains these standards while working in an Agile development environment. Furthermore, the role includes leading the creation of integrated data views based on business or analytics requirements, researching, identifying, and implementing process improvements that address complex technology gaps, and building strong knowledge of technology enablers. Continuous professional and technical development is encouraged through educational workshops, reviewing professional publications, and participating in professional societies. This position allows for up to 80% telecommuting from anywhere in the United States, providing flexibility in the work environment. The role typically reports to a Director or above and is based in Chicago, Illinois, with a standard work schedule of Monday to Friday, 8:30 AM to 4:45 PM, totaling 37.5 hours per week.

Responsibilities

  • Build large-scale data processing systems and data lakes optimized for computational and storage efficiency on Google Cloud Platform.
  • Create ETL processes to build warehouse tables for reporting on Insurance Policy and Claim domain data.
  • Design and implement complex physical data models on columnar cloud databases like BigQuery.
  • Lead the design, implementation, and automation of data pipelines sourcing data from internal and external systems.
  • Transform data for optimal needs of various systems and business requirements.
  • Conduct robust unit testing to ensure deliverables match design specifications.
  • Support subsequent release testing with expertise.
  • Adhere to established quality and reliability standards in an Agile development environment.
  • Lead the creation of integrated data views based on business or analytics requirements.
  • Research, identify, and implement process improvements to address complex technology gaps.
  • Maintain professional and technical knowledge through continuous education and networking.

Requirements

  • Bachelor's degree in computer science, applied computer science, computer engineering, or related field.
  • 5 years of experience as a software developer, data engineer, consultant, or related role.
  • Experience building large-scale data processing systems and data lakes on Google Cloud Platform or AWS within the insurance domain.
  • Experience creating ETL processes for reporting on Insurance Policy and Claim domain data.
  • Experience designing and implementing complex physical data models on columnar cloud databases like BigQuery or Redshift.

Benefits

  • Comprehensive and competitive benefits package to support physical, financial, emotional, and social wellbeing.
  • Employee referral policy program.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service