Data Engineer I

When you join the team at Unum, you become part of an organization committed to helping you thrive. Here, we work to provide the employee benefits and service solutions that enable employees at our client companies to thrive throughout life's moments. And this starts with ensuring that every one of our team members enjoys opportunities to succeed both professionally and personally. To enable this, we provide: + 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 **_*All the benefits listed above are subject to the terms of their individual Plans_** **.** And that's just the beginning... With 10,000 employees helping more than 39 million people worldwide, every role at Unum is meaningful and impacts the lives of our customers. Whether you're directly supporting a growing family, or developing online tools to help navigate a difficult loss, customers are counting on the combined talents of our entire team. Help us help others, and join Team Unum today! **General Summary:** Unum is seeking a Data Engineer to design, build, and maintain data systems and pipelines that ensure data is accessible and optimized for analytics and insight generation. The role requires technical expertise in programming, database management, and data architecture, along with growing business acumen. The Data Engineer will be responsible for building and maintaining the data infrastructure necessary to support accurate, timely, and scalable reporting. With support from the manager, this individual will develop and implement data engineering strategies that align with business priorities. This position requires a minimum of 3 days in office in the following campus locations: Chattanooga, TN, Atlanta, GA, or Portland, ME. **Job Specifications** + Bachelor's degree in quantitative field is required, Master's is preferred + 2+ years of professional experience or equivalent relevant work experience preferred + Experience with tools and platforms such as Teradata, Snowflake, Alteryx, and Python. + **Core Data Engineer Capabilities:** Knowledge in all of the following skillsets and deep expertise in at least two: + Software Engineering: Experience in Python. 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 + **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 + **Preferred characteristics:** Entrepreneurial self-starter, a thorough, results-oriented problem-solver, and a lifelong learner with voracious curiosity AND basic understanding of their organization **Principal Duties and 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 DB2, SQL Server, Web API and Teradata, Snowflake). + 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 \#LI-TO1 ~IN1 \#LI-MULTI Unum and Colonial Life are part of Unum Group, a Fortune 500 company and leading provider of employee benefits to companies worldwide. Headquartered in Chattanooga, TN, with international offices in Ireland, Poland and the UK, Unum also has significant operations in Portland, ME, and Baton Rouge, LA - plus over 35 US field offices. Colonial Life is headquartered in Columbia, SC, with over 40 field offices nationwide. Unum is an equal opportunity employer, considering all qualified applicants and employees for hiring, placement, and advancement, without regard to a person's race, color, religion, national origin, age, genetic information, military status, gender, sexual orientation, gender identity or expression, disability, or protected veteran status. The base salary range for applicants for this position is listed below. Unless actual salary is indicated above in the job description, actual pay will be based on skill, geographical location and experience. $60,500.00-$123,400.00 Additionally, Unum offers a portfolio of benefits and rewards that are competitive and comprehensive including healthcare benefits (health, vision, dental), insurance benefits (short & long-term disability), performance-based incentive plans, paid time off, and 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. All benefits are subject to the terms and conditions of individual Plans. Company: Unum