Data Engineer

All Boston Mutual employees who interact with our policyholders, our producers, and our BML associates embrace the principles of our brand and service philosophy.
We are all brand ambassadors.
Both our words and our behaviors matter.
We share a common service philosophy and pride ourselves in living the BML brand promises every day, one interaction at a time.
The following statements represent what Boston Mutual stands “FOR” – it is what makes us different and better in the market we serve.
We are FOR being a progressive life insurance company offering financial peace of mind to working Americans and their families.
We are FOR providing practical and affordable products designed for those we serve.
We are FOR making it easy to secure a level of financial protection with a portfolio of products – beginning with life insurance.
We are FOR providing a personalized customer experience to our policyholders and producers.
We are FOR acting in the best interests of our policyholders, producers, employees and the communities in which we live and serve – representing the goodness of mutuality in all we do.
We do our best to: Demonstrate a desire to assist Listen for understanding and respond empathetically Explain things in a manner that is easy to understand Be knowledgeable students of our business Take full ownership to resolve questions and issues Be professional, polite and courteous Leave our customers and associates “better than where we found them” The Data Engineer reports directly to the Director - Data and Analytics The primary responsibilities of a Data Engineer are to focus on building our data lake using Databricks, Synapse Analytics and Azure Data Factory in the Azure ecosystem.
In this role you will work with a team of developers, data product owners, scrum masters, business analysts and business customers in an agile environment.
You will participate in the entire software development lifecycle, including: working with various departments on requirements gathering, translating business requirements into detailed system and technical requirements, functional and technical design, development, testing, deployment, and support.
You will contribute to all data management aspects, including data governance, data quality management, master data management, enterprise data integration by analyzing raw data, writing data pipelines in Azure Data Factory, SQL, Python, and Spark, and solving data issues as they arise during development and after deployment.
The Data Engineer is expected to: Design, develop and implement scalable batch/real-time data pipelines to integrate data from a variety of sources into an Azure data warehouse and data lake Partner with analytics and actuarial team to understand the current use cases and supply clean and consistent data models Build consistent data models that act as the source of truth for all metrics within the company Identify data needs & build comprehensive business intelligence solutions to help the team make faster & better decisions, backed by data Handle ad hoc data and analytics requests, while addressing long-term stakeholder needs and driving insights for the executive leadership team Proactively manage stakeholder expectations, monitor and manage data integrity, and resolve data issues Create and maintain technical documentation.
Guide and deliver meaningful and thorough code reviews.
Design, code, test, document, and troubleshoot deliverables Maintain awareness of and ensure adherence to the standards regarding security and privacy.
Ability to perform Data Analysis and Data Quality tests and create audits for the ETLs.
Perform Continuous Integration and deployment using Azure DevOps and git Must be a very good communicator and should be analytically sound Create and maintain optimal data pipeline/flow architecture.
Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
Qualifications & Knowledge Requirements Education: Bachelor’s degree or equivalent work experience required.
Experience: 1- 5+ Years similar work experience Knowledge Requirements: Strong experience with tools like Azure Databricks, Azure Synapse Analytics and Azure Data Factory, Delta Lake, Parquet, and Spark SQL Experience implementing and managing Data Lakes, Data Warehouses, Data Marts, and Dimensional Data Models.
Experience with Tableau, Power BI, Qlik or similar as visualization tool development Experience building and maintaining production data pipelines,,ETL, or databases Excellent written and verbal communication skills Strong SQL skills Experience using Python, Powershell and Spark Extensive experience working with Microsoft BI stack (SSIS/SSRS/SSAS) and Microsoft SQL Server.
Well-versed with agile development methods Experience with code management – e.
g.
git Demonstrated ability in starting and managing work tasks Demonstrated ability to work independently Experience in training, mentoring and developing team members Hybrid Work Model At our Canton location, employees will be on site Monday - Thursday starting 5/1/23.
At our Omaha location, employees will be on site 2 days per week.
Boston Mutual is an equal opportunity employer.
Boston Mutual is an equal opportunity employer, and does not discriminate on the basis of race, color, age, religious creed, national origin, ancestry, sex, sexual orientation, gender identity, genetic information, disability, military service, veteran status, family status, pregnancy, or any other characteristic protected by federal or state laws.
Boston Mutual is a drug-free workplace.
#LI-Hybrid ** Salary is based on location.
**