Data Engineer

Inizio Partners Corp; Hartford (CT); On-site; USD 100,000 - 130,000; Full time

Job summary

A specialized analytics firm is seeking a Data Engineer in Hartford, Connecticut. The ideal candidate will have 5-7 years of experience in data analytics, focusing on insurance marketing. Responsibilities include building data pipelines, client engagement, and delivering analytics solutions. Proficiency in Python and SQL is essential, along with a strong understanding of the Auto and Home Insurance domain.

Qualifications

• 5 - 7 years of experience in data analytics, particularly in insurance marketing analytics.
• Expertise in the Auto and Home Insurance domain preferred.
• Strong knowledge of data modeling and visualization techniques.

Responsibilities

• Build and optimize data pipelines for analytics initiatives.
• Work with structured and unstructured data from multiple sources.
• Develop and maintain data pipelines using Python and SQL.
• Serve as a key point of contact for client stakeholder engagement.
• Design and deliver performance dashboards and reports.

Skills

SQL

Python

Analytical Thinking

Data Visualization

Education

Bachelor's degree in Computer Science or related field

Master's degree in a related technical discipline

Tools

Power BI

Tableau

ETL tools

Relational Databases

Linux OS

GIT

Job description

We are seeking a skilled and motivated Data Engineer with strong skills in Python, SQL to support our initiatives in Insurance and Marketing Analytics. This role demands a combination of technical expertise, deep domain knowledge and client-facing communication to successfully deliver enterprise-grade analytics and DevOps solutions. This role will focus on client engagement, innovation, and data-driven solutions, ensuring our clients receive cutting-edge analytics and AI solutions that enhance operational efficiencies and decision making.

As a Data Engineer, you will be responsible of building and optimizing data pipelines, ensure data quality to support our analytics initiatives. This role requires strong experience in data analytics, AI applications, and client engagement in the insurance industry.

Role & Responsibilities Overview:

• Project Requirement: Work with structured and unstructured data from multiple sources including customer data, campaign data and policy information. Work closely with cross-functional teams to incorporate analytics into business processes and decision-making.
• Technical Expertise: Develop and maintain data pipelines using Python and SQL tailored to insurance use cases. Write clean, reusable and efficient python code for data transformation and processing.
• Domain Expertise: Translate insurance domain problems into actionable data solutions. Leverage your expertise to identify client pain points, emerging trends, and analytics solutions that drive operational efficiency and competitive advantage.
• Client Engagement: Serve as a key point of contact for senior stakeholders at client organizations, understanding their business needs and ensuring high satisfaction with analytics and DevOps solutions.
• Innovation & Strategy: Identify opportunities for advanced analytics, automation in insurance operations.
• Project Delivery & Execution: Ensure the successful and timely delivery of analytics projects, including dashboards, and reporting tools. Ensure all projects are aligned with client goals and industry standards.
• Stakeholder Engagement: Act as a trusted advisor to clients, managing communication and expectations while keeping internal stakeholders updated on project progress, challenges, and successes.
• Risk & Issue Management: Identify potential project risks and issues, take proactive steps to mitigate them, and communicate effectively with all stakeholders to ensure smooth project execution.
• Market Insights: Stay up-to-date with the latest trends in Auto & Home insurance, data analytics to continuously drive innovation and best practices within the organization.
• Performance Reporting & Insights: Design and deliver performance dashboards, reports, and presentations that translate complex data into actionable insights, facilitating data-driven decision-making for clients.

Candidate Profile:

• Education: Bachelors degree in Computer Science, Information Technology, Engineering, Mathematics, or a related field. (Preferred) Masters degree in a related technical discipline.
• Experience: 5 - 7 years of experience in data analytics, with a strong focus on insurance marketing analytics. Expertise in the Auto and Home Insurance domain is strongly preferred.
• Technical Skills:
• Strong knowledge of SQL and experience working with Relational Databases.
• Proficiency in Python for data manipulation and scripting.
• Basic proficiency in Linux OS and familiarity with vi editor for configuration and scripting tasks.
• Experience with BI tools like Power BI, Tableau, Thoughtspot.
• Familiarity with ETL tools, version control (e.g. GIT)
• Experience with Generative AI and other advanced data analytics tools.
• Strong skills in data modeling, visualization, and data-driven decision-making.
• Analytical Thinking & Problem Solving: Ability to think strategically, analyze complex data, and provide innovative solutions to meet client objectives.