Salary Range: 81000 to 124550 (Currency: USD) (Pay period: per-year-salary)
The work we do has an impact on millions of lives, and you can be a part of it.
We help protect our customers against life’s uncertainties. Regardless of where you work within the company, you’ll be helping provide protection and peace of mind when our customers need it most.
The Sr. Data Engineer will work as part of the Enterprise Data Integration team under the direction of the Enterprise Data Integration Manager. The position relies on experience and judgment to support, enhance and create ETL processes, requiring a broad degree of independence, knowledge and problem solving skills.
The ideal candidate for the Sr. Data Engineer position is a technical resource that has experience building comprehensive data integration solutions representing data from relational and analytical source systems or models, analyzing complex SQL and Python code, and creating and optimizing batch application workloads.
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.
Responsibilities:
- 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.
- Additionally, an expert level understanding of database methodology, the MS BI Stack, Python, Cloud Data Lake technologies and other industry solutions are required.
Work Experience, Education, Certification / Training Required:
- Bachelor’s degree or equivalent certifications / experience required
- 5+ years IT development experience required. Operational and Incident management experience required
- 3+ years of Business Intelligence application delivery using the Microsoft Business Intelligence stack (SSIS, SSAS, SSRS, SQL Server, Power BI) required
- Strong experience in relational and dimensional data modeling required
- 2+ years of Cloud Data Lake Technology experience required
- 2+ years of Python experience preferred
- Strong database and SQL experience required. Microsoft T-SQL preferred
- Experience working with CI/CD
- Experience working on a project team using agile SDLC methodology required (Agile preferred)
- Strong experience with Microsoft SQL Server required. SQL Server 2012 Required and 2016 a plus
- Experience in the Insurance industry and/or LOMA coursework
- ITIL Foundation V3 Certification a plus
- Experience with Workload Automation Tools – (Control-M V9 Preferred)
Employee Benefits:
We aim to protect our employees’ wellbeing through a broad benefits offering. For example, we protect physical wellbeing through health, dental and vision insurance. We protect mental wellbeing through mental health benefits and an employee assistance program. We protect time away from work with a variety of paid time away benefits (e.g., paid time off, paid parental leave, short-term disability, and a cultural observance day). We protect financial wellbeing through 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.
Eligibility for certain benefits may vary by position in accordance with the terms of the Company’s benefit plans.
Diversity and Inclusion:
At Protective, we are committed to providing an inclusive culture where all employees are able to fully contribute and thrive. Our goal is to grow and develop our people, attract diverse talent and support strong, diverse communities.
We support diversity, equity, and inclusion by working to develop a culture of inclusion and belonging led by leaders who develop potential and embrace all skills and abilities. Our aim is to create an equitable environment for all leaders and employees that will drive performance and impact business strategy. In this way, we can increase overall diversity for leadership roles and pipelines of talent by maturing our hiring practices, robust development opportunities and focus on retention of key talent.
We are proud to be an equal opportunity employer committed to being inclusive and attracting, retaining, and growing the talents of a diverse and inclusive workforce.
Accommodations for Applicants with a Disability:
If you require an accommodation to complete the application and recruitment process due to a disability, please email [email protected] information will be held in confidence and used only to determine an appropriate accommodation for the application and recruitment process. Please note that the above email is solely for individuals with disabilities requesting an accommodation. General employment questions should not be sent through this process.
