Sr. Data Engineer

Selective Insurance Company of America; Charlotte (NC); Hybrid; USD 106,000 - 146,000; Full time

Benefits offered by this job

Competitive base salary

Incentive plan eligibility

Comprehensive health care plans

Retirement savings plan with company-m

Discounted Employee Stock Purchase

Tuition assistance and reimbursement

20 days of paid time off

Job summary

Selective Insurance Company of America in Charlotte, NC is seeking a Sr. Data Engineer to support customer analytics within the Information Management group. You will develop data applications, partner with stakeholders, and guide data flow designs across teams to resolve issues and drive scalable solutions.

The role requires 5–7 years in data engineering, strong SQL, Azure experience, and proficiency with Powercenter, Cognos, and analytics platforms like PowerBI or Databricks.

Qualifications

• 5–7 years of experience in data warehousing, data integration, or data engineering projects.
• Experience with Azure ecosystem.
• Experience with Informatica Powercenter and/or IICS.
• Experience with Cognos and Netezza Performance servers.
• Experience with at least one analytics platform: PowerBI, AzureML, Databricks, or Synapse.
• Excellent communication skills.
• Bachelor's degree in computer science or related engineering field preferred.

Responsibilities

• Develop and support new and existing data applications.
• Partner with business stakeholders and analysts to understand data and business processes; recommend best practices or long-term solutions to resolve current issues and inform future system design.
• Collaborate with Application and Enterprise Architects to create and review low-level implementation designs and to understand high-level data flow designs created by data architects.
• Provide technical guidance for implementing complex data solutions.
• Support the design, development, code reviews, testing, deployment, and documentation of data engineering and data integration applications.
• Maintain detailed documentation to enable downstream integrations.
• Provide support for production issues.
• Perform scrum master activities.
• Identify technology trends and explore opportunities for adoption within the organization.

Skills

SQL

Communication

Cross-functional collaboration

Stakeholder partnering

Education

Bachelor's degree in computer science or related engineering field

Tools

Informatica Powercenter

IICS

Cognos

Netezza Performance servers

PowerBI

AzureML

Databricks

Synapse

Python

Scala

Azure DevOps

GitHub

Job description

Selective Insurance Company of America is seeking a hands-on, collaborative Sr. Data Engineer to support data and analytics efforts for the Customer Analytics team within the Information Management group.

Responsibilities

• Develop and support new and existing data applications.
• Partner with business stakeholders and analysts to understand data and business processes; recommend best practices or long-term solutions to resolve current issues and inform future system design.
• Collaborate with Application and Enterprise Architects to create and review low-level implementation designs and to understand high-level data flow designs created by data architects.
• Provide technical guidance for implementing complex data solutions.
• Support the design, development, code reviews, testing, deployment, and documentation of data engineering and data integration applications.
• Maintain detailed documentation to enable downstream integrations.
• Provide support for production issues.
• Perform scrum master activities.
• Identify technology trends and explore opportunities for adoption within the organization.

Requirements

• 5 to 7 years of experience in data warehousing, data integration, or data engineering projects.
• Ability to work effectively with people across other departments and/or outside the enterprise.
• Strong SQL skills.
• Experience working within the Azure ecosystem.
• Experience with Informatica Powercenter and/or IICS.
• Experience with Cognos and Netezza Performance servers.
• Experience with at least one analytical platform: PowerBI, AzureML, Databricks, or Synapse.
• Experience using Python or Scala.
• Experience with Azure DevOps and GitHub is preferred.
• P&C Insurance experience is preferred.
• Excellent communication skills.
• Bachelor's degree in computer science or related engineering field preferred.

Technologies

• SQL
• Azure
• Informatica Powercenter
• IICS
• Cognos
• Netezza Performance servers
• PowerBI
• AzureML
• Databricks
• Synapse
• Python
• Scala
• Azure DevOps
• GitHub

Location

• Charlotte, NC (hybrid)

Compensation

• USD 106,000 - 146,000 per year
• Pay Range: USD $106,000.00 - USD $146,000.00 /Yr.

Benefits

• Competitive base salary
• Incentive plan eligibility at all levels
• Comprehensive health care plans
• Retirement savings plan with company match
• Discounted Employee Stock Purchase Program
• Tuition assistance and reimbursement programs
• 20 days of paid time off

Additional Information

• Equal Employment Opportunity employer.
• For Massachusetts Applicants: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment.