Data Engineer I

Unum•Portland, ME

19d•$60,500 - $123,400•Hybrid

About The Position

This position for a Data Engineer who will design, build and maintain data systems and pipelines to allow data to be accessed and utilized optimally for analytics or visualization/insight generation purposes. The role requires technical expertise in the fields of computer programming, database management and data architecture; and relies on increasing business knowledge. With some support from manager, this individual will build and execute data engineering approaches to support business priorities.

Requirements

Bachelor’s degree in quantitative field or equivalent experience
2 years of professional experience or equivalent relevant work experience preferred
Knowledge in all of the following skillsets and deep expertise in at least two:
Data Engineering: Experience with at least one relevant ETL toolset (IICS, Python, SnowSQL, etc.).
Exposure to DevOps best practice including CI/CD, process automation and optimization.
Data Architecture and Infrastructure: Understanding of data architecture principles and related infrastructure requirements, covering on-prem and Cloud platforms.
Holistic Data Preparation: The ability to understand and present data, including a basic understanding of how the data will build towards a business solution.
Data Extraction, Transform & Load: Preferred skills include: Experience in writing complex SQL queries that join multiple tables/databases.
Experience exploring databases/tables or other legacy data content to identify best data sources to solve business problems.
Demonstrates ability to troubleshoot complex SQL queries with little guidance.
Demonstrates ability to create logical data models by combining data from multiple sources including internal and external data.
Domain Knowledge: Deep understanding of Fineos and experience with Snowflake Cortex AI preferred.
Core business capabilities: Demonstrated communication skills, experience in financial services, exposure to working with senior management and executive leadership, and attention to detail while effectively prioritizing work and managing multiple projects simultaneously.
Ability to understand and explain a problem and identify and communicate an appropriate solution.
Leadership Capabilities: Developing ability to coach or mentor team members, ability to commit quickly and positively to change.
Viewed as embracing change and leading proof of concept work and prototyping when necessary

Nice To Haves

Experience in writing complex SQL queries that join multiple tables/databases.
Experience exploring databases/tables or other legacy data content to identify best data sources to solve business problems.
Demonstrates ability to troubleshoot complex SQL queries with little guidance.
Demonstrates ability to create logical data models by combining data from multiple sources including internal and external data.
Deep understanding of Fineos and experience with Snowflake Cortex AI preferred.
Entrepreneurial self-starter, a thorough, results-oriented problem-solver, and a lifelong learner with voracious curiosity AND basic understanding of their organization

Responsibilities

Employ a variety of languages and tools to develop, construct, test and maintain data pipelines, ensuring they support the requirements of the business.
Integrate varying sizes of data from different sources (including Snowflake, Fineos, Web API and Teradata).
Apply validation, aggregation, and reconciliation techniques to create a rich data framework.
Work closely with the data scientists and business partners to understand the business problem they are trying to solve and the analytics solutions they plan to apply.
Use this understanding to create appropriate data structures tailored for the specific problem.
Create data assets that conform to scalability, extensibility, performance and maintainability requirements for the problem at hand.
Promotes development of solutions following appropriate engineering process that is fit to purpose for different use scenarios.
Understand and contribute to the evolution of the enterprise data architecture including the application of current and emerging data frameworks and tools (eg hosting data in Cloud).
Efficiently prepares results for interpretation and/or visualization and communicates findings and potential value to manager.
Support integration of solutions within existing business processes using automation techniques.
Understand theory and application of current and emerging software engineering practices.
Provides support to lower level Data Engineer peers.
Perform other related duties as assigned

Benefits

Award-winning culture
Inclusion and diversity as a priority
Performance Based Incentive Plans
Competitive benefits package that includes: Health, Vision, Dental, Short & Long-Term Disability
Generous PTO (including paid time to volunteer!)
Up to 9.5% 401(k) employer contribution
Mental health support
Career advancement opportunities
Student loan repayment options
Tuition reimbursement
Flexible work environments
healthcare benefits (health, vision, dental)
insurance benefits (short & long-term disability)
performance-based incentive plans
paid time off
a 401(k) retirement plan with an employer match up to 5% and an additional 4.5% contribution whether you contribute to the plan or not.