About the role

Python ETL Lead managing data integration solutions as part of Business Intelligence team at Protective. Supporting comprehensive data integration and transforming data according to business rules in a hybrid work environment.

Responsibilities

This role is required to transform data according to Business Rules and MDM and to work with the Enterprise Data Management team to assure attributes are properly governed and loaded into Cloud and operational models.
The role is also required to analyze sources of data, determine optimal data integration methodologies, map and model to relational and analytical layer data models, identify enhancements, and other needs relative to the Enterprise Data Integration space.
The role additionally has input into the Enterprise Data Integration architecture, procedures and workflow.
The role is expected to have a strong business acumen in order to provide effective and efficient solutions. Individuals in this role are expected to have a strong ability to multitask on various projects and priorities and keep them all moving forward.
The role influences others in IT through sharing of specialized technical knowledge and mentors junior developers and reporting analysts in proper techniques, procedures and code performance adjustments.
This role is expected to support and expand a culture of operational excellence.
This position requires a highly technical individual that has the ability to communicate clearly with Management, Business and Data Analysts, Operations Support, Developers and other IT professionals using technically sound terminology and excellent communication skills.

The ideal candidate will be a strong leader and self starter working in a fairly autonomous environment.
They will need to have a high level of experience coding technically sound solutions following industry best practices specifically around Enterprise Data Integration solutions, while exhibiting the ability to communicate in a non-technical or business manner.
This candidate will have leadership qualities that will be utilized to mentor junior developers and the ability to simultaneously address multiple units of work within a given timeframe to ensure timeline is adhered to, quality requirements are documented and followed, as well as acceptance criteria is met.
The candidate will possess strong institutional knowledge of Enterprise Data Integration industries in order to craft the most effective and efficient solutions for the business.
The ability to understand complex business needs, logical problem solving skills, and strong written and verbal communication skills are required.
An expert level understanding of database methodology, the MS BI Stack, Python, Cloud Data Lake technologies and other industry solutions are required. (5+ years' experience)

We aim to protect the wellbeing of our employees and their families with a broad benefits offering.
In addition to offering comprehensive health, dental and vision insurance, we support emotional wellbeing through mental health benefits and an employee assistance program.
Work/life balance is important and Protective offers a variety of paid time away benefits (e.g., paid time off, paid parental leave, short-term disability, and a cultural observance day).
The financial health of our employees is just as important as physical and emotional health.
Some of the financial wellbeing benefits include contributions to healthcare accounts, a pension plan, and a 401(k) plan with Company matching.
All employees are encouraged to protect their overall wellbeing by engaging in ProHealth Rewards, Protective’s platform to improve wellbeing while earning cash rewards.