Data Engineer III - Data Operations & Infrastructure

ICW GROUP HOLDINGS; Baxter Village (SC); On-site; USD 110,000 - 140,000; Full time

Job summary

ICW Group is seeking a Data Engineer III to design and implement data pipelines, data integration, and storage solutions across data warehouses and data lakes. You will partner with IT, BI, and Data Governance to enable data-driven decisions and automate data processing.

In this role you will lead scalable pipelines (batch/streaming) on cloud platforms such as AWS, develop data models, and ensure data quality while advancing enterprise data architecture and governance.

Qualifications

• Bachelor's degree and 6+ years of data integration/engineering experience.
• Experience designing scalable data pipelines and data models.

Responsibilities

• Design, develop, and implement data pipelines and storage solutions (data warehouses/lakes).
• Partner with BI, Data Science, and Data Governance teams to enable data-driven decisions.
• Lead batch and streaming data pipelines on cloud and on-prem platforms like AWS.
• Analyze complex data elements, model data flows, and validate ETL/ELT mappings.
• Prototype and evaluate new data technologies, ensuring data quality and governance.
• Collaborate with Enterprise Architecture to standardize data tooling and practices.

Skills

Data engineering

ETL/ELT

Big data

Cloud platforms (AWS, GCP)

Education

Bachelor's degree in Computer Science, Applied Mathematics, Engineering or related field

Tools

AWS

Job description

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 it's 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 the twelfth consecutive year in a row and for the 20th time overall 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 III 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. In the process, the role will have the opportunity to act as a Data Advisory member for the Actuarial, Business Intelligence (BI), Data Science, and Data Engineering teams, as well as a collaborator and contributor to Enterprise Data Architecture. 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.
• Leads the design and build of 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 the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using 'big data' technologies and tools.
• Leads data initiatives to ensure pipelines are reliable, efficient, testable, and maintainable.
• Maintains a strong understanding of the current landscape and proactively leads the analysis of the current environment to detect data deficiencies, gaps, and opportunities.
• Drives the improvement of engineering team processes via data architecture, engineering, test, and operational excellence best practices.
• Collaborates in implementing components of data strategy - Master Data Management (MDM), data virtualization etc.
• Partners with various teams in delivering overall data solutions.
• Works closely with BI and Data Science teams in implementing various data streams.
• Partners with Enterprise Architecture, Technology, and Project teams to ensure consistency of solutions approach while maintaining data governance requirements.
• Contributes to data governance and data quality best practices including design reviews, unit testing, code reviews, and continuous integration and deployment.
• Collaborates with data architects to ensure the output of the physical models meet required needs- e.g., collaborates on data definition, data structure, data content and data usage.
• Evaluates and conducts POC on new technologies for fitment in next generation data platform ecosystem.
• Collaborates with the Enterprise Architecture team to drive tooling and standards to improve the productivity and quality of output for data engineers across the company.

SUPERVISORY RESPONISBILITIES

This role does not have supervisory responsibilities but may mentor and/or train other team members. Acts as a resource for team members.

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 6 years of experience in a data integration (Cloud/Traditional) engineering related role required.