Responsibilities
- Hands on development and support of new or existing data applications.
- Works closely with the lead to create / review low level implementation designs, understand high level data flow designs developed by Data Architects.
- Provide technical guidance to the team and work on implementingplex data solutions.
- Provide support in the design, development, code reviews, test deploy and documentation of Data Engineering and Data Integration Applications.
- Scaling and optimizing schema and performance tuning SQL and ETL pipelines in data lake and data warehouse environments.
- Provide technical leadership and mentor junior data engineers.
- Work closely with Product Owners, Product Managers, Program Manager, Scrum Master, and Team Members in a Scaled Agile framework.
- Closely monitor the health of data pipelines and develop contingency plans for failures.
- Maintain detailed documentation to support downstream integrations.
- Provide support for production issues.
Qualifications
5-7 of experience in Data Warehousing, Data integration or Data Engineering projectsAbility to effectively work well with people in other departments and / or outside of the enterprise.Expert-level proficiency in Python, SQL, and Spark; strong experience with cloud platforms (Azure, AWS, or GCP).Expert level experience in Databricks and Delta Lake.Proven track record of building enterprise-scale data platforms supporting advanced analytics and machine learning.Experience with streaming architectures (Kafka, Kinesis) and event-driven data processing.Strong knowledge of data security, encryption, and access control in regulated environments.Advanced working knowledge of SQL and optimizing queries and databases for performance.Ability to debug and resolveplex issues internally and work with external vendors and service providers.Good understanding and hands on experience in developing and managing CI / CD pipelinesGood understanding of Data Structures and Data Models.Experienced in analytical platforms like - PowerBI, AzureML or SynapsePossesses excellentmunication skills.Good To Have :
P&C Insurance experience is highly desired.Bachelor's degree inputer science or related engineering field preferred.Certifications in cloud platforms (, AWS Certified Data Analytics, Azure Data Engineer Associate)Understanding of GenAI, LLM's and their implementation for business use cases.Total Rewards
Selective Insurance offers a total rewards package that includes apetitive base salary, incentive plan eligibility at all levels, and a wide array of benefits designed to help you and your family stay healthy, achieve your financial goals, and balance the demands of your work and personal life. These benefits includeprehensive health care plans, retirement savings plan withpany match, discounted Employee Stock Purchase Program, tuition assistance and reimbursement programs, and paid time off plans. Additional details about our total rewards package will be provided during the recruiting process.
The actual base salary is based on geographic location, and the range is representative of salaries for this role throughout Selective's footprint. Additional considerations include relevant education, qualifications, experience, skills, performance, and business needs.
Pay Range
USD $106, - USD $146, / Yr.
Additional Information
Selective is an Equal Employment Opportunity employer. That means we respect and value every individual's unique opinions, beliefs, abilities, and perspectives. We aremitted to promoting a weing culture that celebrates diverse talent, individual identity, different points of view and experiences - and empowers employees to contribute new ideas that support our continued and growing success. Building a highly engaged team is one of our core strategic imperatives, which we believe is enhanced by diversity, equity, and inclusion. We expect and encourage all employees and all of our business partners to embrace, practice, and monitor the attitudes, values, and goals of acceptance; address biases; and foster diversity of viewpoints and opinions. Job ID 3817