
Data Engineer
The Hartford
full-time
Posted on:
Location Type: Hybrid
Location: Hartford • Connecticut • Illinois • United States
Visit company websiteExplore more
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