The Hartford

Data Engineer

The Hartford

full-time

Posted on:

Location Type: Hybrid

Location: HartfordConnecticutIllinoisUnited States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $100,960 - $151,440 per year

About the role

  • Participate in developing high quality, scalable software modules for next generation analytics solution suite
  • Engage in activities with cross-functional IT unit stakeholders (e.g., database, operations, telecommunications, technical support, etc.)
  • Formulates logical statements of business problems and devises, tests and implements efficient, cost-effective application program solutions
  • Identify and validate internal and external data sources for availability and quality
  • Work with SMEs to describe and understand data lineage and suitability for a use case
  • Create data assets and build data pipelines that align to modern software development principles for further analytical consumption
  • Perform data analysis to ensure quality of data assets
  • Perform preliminary exploratory analysis to evaluate nulls, duplicates and other issues with data sources
  • Assist in developing code that enables real-time solutions to be ingested into front-end systems and platforms
  • Produce code artifacts and documentation using GitHub for reproducible results and hand-off to other data science teams.

Requirements

  • 2+ years of relevant experience recommended
  • Bachelor’s degree in Computer Science, Engineering, IT, Management Information Systems, or a related discipline
  • Experience in Python and SQL
  • Experience in ingesting data from a variety of structures including relational databases, Hadoop/Spark, cloud data sources, XML, JSON
  • Experience in ETL concerning metadata management and data validation
  • Experience in Unix and Git
  • Experience in Automation tools (Autosys, Cron, Airflow, etc.)
  • Exposure to AWS or GCP services a plus
  • Experience with Cloud data warehouses, automation, and data pipelines (i.e. Snowflake, Redshift) a plus
  • Experience with ELT tools (i.e. DBT, Talend) a plus
  • Able to communicate effectively with both technical and non-technical teams
  • Able to translate complex technical topics into business solutions and strategies
  • Candidate must be authorized to work in the US without company sponsorship.
Benefits
  • Other rewards may include short-term or annual bonuses
  • long-term incentives
  • on-the-spot recognition

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
PythonSQLETLdata analysisdata validationdata pipelinesUnixGitHadoopSpark
Soft skills
communicationproblem-solvingcollaborationanalytical thinkingtechnical translation