"Alerted.org

Are you looking to make an impactful difference in your work, yourself, and your community? Why settle for just a job when you can land a career? At ICW Group, we are hiring team members who are ready to use their skills, curiosity, and drive to be part of our journey as we strive to transform the insurance carrier space. We're proud to be in business for over 50 years, and its change agents like yourself that will help us continue to deliver our mission 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 ten consecutive years as a Top 50 performing P&C organization offering the stability of a large, profitable and growing company combined with a focus on all things people. It's our team members who make us an employer of choice and the vibrant company we are today. We strive to make both our internal and external communities better everyday! Learn more about why you want to be here!

PURPOSE OF THE JOB

The Data Engineer I 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

Creates and maintains 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.

+ Assists in analysis of 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.

+ Supports data model design 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.

+ Understands the current application and data landscape and assists in analysis of data deficiencies, gaps, and opportunities.

+ Creates deployment scripts and provides deployment and technical documentation.

+ 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.

Collaborates with various teams in implementing overall data solutions.

+ Collaborates with the Business and IT Project teams in the creation, refinement and review of functional and non-functional requirements, and specifications.

+ Collaborates with Quality Assurance Engineers to ensure sufficient test coverage.

+ Collaborates with Senior Data Engineers to ensure the output of the physical models meet required needs— e.g., collaborates on data definition, data structure, data content and data usage.

+ Collaborates with the Enterprise Architecture team to adopt tooling and standards.

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 of education and experience. Minimum 1 year of experience and/or training in a data engineering (Cloud/Traditional) related role.

CERTIFICATES, LICENSES, REGISTRATIONS

+ AWS Cloud certifications preferred.

+ Insurance domain certifications preferred.

KNOWLEDGE AND SKILLS

+ Competency in at least 1 database technology, traditional or cloud (MS SQL, MySQL, PostgreSQL, DynamoDB etc.).

+ Good database design knowledge and instincts.

+ Basic understanding of API or stream-based data extraction processes, data modeling and performance tuning.

+ Experience with troubleshooting and debugging data quality issues.

+ Familiar with AWS technologies like Redshift, S3, EC2, Glue, EMR, Kinesis, Lambda, DynamoDB, etc.

+ Prefer experience with data movement tools – SSIS, Profisee, Alteryx, Informatica.

+ Prefer experience with big data tools: Hadoop, Spark, Kafka, Spark & Kafka Streaming, Python, Scala, Talend etc.

+ A self-starter mentality that thrives in a rapidly changing, fast-paced environment and tolerates ambiguity while demonstrating problem-solving.

+ Good analytical and time management skills. Self-motivated, organized, detail oriented, and able to multi-task.

+ Strong verbal and written communication skills.

+ Experience working under an agile methodology a plus.

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-TM1

#LI-HYBRID

The current range for this position is

$39.91 - $67.31

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?

* Challenging work and the ability to make a difference

* You will have a voice and feel a sense of belonging

* We offer a competitive benefits package, with generous medical, dental, and vision plans as well as 401K retirement plans and company match

* Bonus potential for all positions

* Paid Time Off with an accrual rate of 5.23 hours per pay period (equal to 17 days per year)

* 11 paid holidays throughout the calendar year

* Want to continue learning? We’ll support you 100%

_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._

At ICW Group we offer a work environment that encourages entrepreneurialism and celebrates success. Our team members are hands-on contributors who are given the opportunity to make an impact. It's our people who make us an employer of choice and the vibrant company we are today.

Job Category:** **IT

Job Type:** **Full time

Req ID:** **JR100885