Data Engineer II

Are you looking for more than just a job? Do you want to have a voice and feel a sense of belonging? At ICW Group, we hire innovative people who consistently adapt, grow and deliver. We believe in hard work, a fun work environment, and embracing creativity that only comes about when talented people collaborate to develop solutions. Our mission is to create the best insurance experience possible.

Headquartered in San Diego with regional offices located throughout the United States, ICW Group has been named for seven consecutive years as a Top 50 performing P&C company offering the stability of a large, profitable and growing company combined with a small-company entrepreneurial spirit. Our purpose-driven ethos provides team members with opportunities to contribute, develop, and belong.

PURPOSE OF THE JOB

The Data Engineer II will design, develop, and implement data pipelines, data integration and data storage solutions such as data warehouses, data lakes, relational and non-relational databases. The role will partner closely with IT Managers, Enterprise Business Intelligence, Data Governance and Data Science teams to solve business-significant data problems and enable data-driven decision-making, automation, and optimization. Data is central to ICW Group's business strategy and digital evolution, and the Data Engineer ensures optimal data delivery architecture is consistent throughout all projects.

ESSENTIAL DUTIES AND RESPONSIBILITIES

Builds data solutions that ensure data integrity and information usability for enterprise-wide digital solutions and decision making.

• Creates and maintains scalable data pipelines and solutions (batch and / or streaming) that make the best use of traditional and cloud platforms (AWS or similar) by understanding the business, technology, and data landscape including real time data processing.
• Provides analysis of complex data elements and systems, data flow and in development of conceptual, logical, and physical data models as well as verification and implementation of ETL / ELT mappings and transformation logic.
• Designs, supports and peer reviews the data models and schemas for new and existing data sources for the data warehouse.
• Conducts unit, integration, and system tests on our data sources to validate data against source systems, and continuously optimize performance to improve query speed and reduce cost.
• Builds pipelines that are reliable, efficient, testable, and maintainable.
• Maintains a good understanding of the current landscape and assists in the analysis of data deficiencies, gaps, and opportunities.
• Contributes to building the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using 'big data' technologies and tools.

Partners with various teams in implementing overall data solutions.

SUPERVISORY RESPONISBILITIES

This role does not have supervisory responsibilities.

EDUCATION AND EXPERIENCE

Bachelor's degree in Computer Science, Applied Mathematics, Engineering, or any other technology related field required, or equivalent combination for education and experience. Minimum 3 years of experience in a data integration (Cloud / Traditional) engineering related role required. Insurance experience a plus.

CERTIFICATES, LICENSES, REGISTRATIONS

KNOWLEDGE AND SKILLS

PHYSICAL REQUIREMENTS

This job operates in a professional office environment. While performing the duties of this job, the employee is regularly required to talk or hear. The employee frequently will sit, stand, walk, and bend during working hours. Requires manual and finger dexterity and eye-hand coordination. Required to lift and carry relatively light materials. Requires normal or corrected vision and hearing corrected to a normal range. Ability to work additional hours, as required.

WORK ENVIRONMENT

This position operates in an office environment and requires the frequent use of a computer, telephone, copier and other standard office equipment.

We are currently not offering employment sponsorship for this opportunity.

LI-TP1 #LI-HYBRID

The current range for this position is

95,378.98 - $160,850.17

This range is exclusive of fringe benefits and potential bonuses. If hired at ICW Group, your final base salary compensation will be determined by factors unique to each candidate, including experience, education and the location of the role and considers employees performing substantially similar work.

WHY JOIN ICW GROUP?

ICW Group is committed to creating a diverse environment and is proud to be an Equal Opportunity Employer. ICW Group will not discriminate against an applicant or employee on the basis of race, color, religion, national origin, ancestry, sex / gender, age, physical or mental disability, military or veteran status, genetic information, sexual orientation, gender identity, gender expression, marital status, or any other characteristic protected by applicable federal, state or local law.

Salary : $95,379 - $160,850