ICW Group · 2 hours ago
Data Engineer III
San Diego, CA
Full-time
Onsite
Mid, Senior Level
$122K/yr - $218K/yr
6+ years expICW Group is a long-established insurance carrier that is transforming the industry through innovative data solutions. The Data Engineer III will design, develop, and implement data pipelines and storage solutions, collaborating with various teams to enable data-driven decision-making and optimize data delivery architecture.
Financial ServicesInsurance
No H1B
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
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
Qualification
Required
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
Expertise with database & data warehouse design, using MS-SQL, PostgreSQL etc
Knowledge of Model and Design of DB schemas for read and write performance
Working knowledge of API or stream-based data extraction processes
Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
Background in data modeling and performance tuning in relational and no-SQL databases
Experience with AWS technologies like Redshift, S3, EC2, Glue, EMR, Kinesis, Lambda, DynamoDB, etc
Experience with modern data architectures and modern data platforms like Snowflake, Databricks etc
Experience with data technologies: Hadoop, Spark, Kafka, Spark & Kafka Streaming, Python, Scala, Talend etc
Knowledge and experience with data movement tools – SSIS, Profisee, Alteryx, Informatica
Working knowledge of multiple data management domains such as data modeling, integration, warehousing, data quality, security, and governance
A self-starter mentality that thrives in a rapidly changing, fast-paced environment and tolerates ambiguity while demonstrating problem-solving with limited supervision
Strong analytical and time management skills
Self-motivated and able to handle tasks with minimal supervision
Must be organized, detail oriented, and able to multi-task
Ability to work well under pressure and deliver results with tight deadlines and under changing priorities
Ability to cross collaborate with multiple teams and offer value-added solutions to meet objectives
Ability to motivate and inspire team for maximum performance
Strong verbal and written communication skills
Preferred
Experience with data practices (security, data management and governance) preferred
Experience in operations research, machine learning or optimization a plus
Insurance experience a plus
Data architecture or data engineering related certification strongly desired
AWS Cloud Practitioner or more advanced AWS certification preferred
DAMA certifications preferred
Benefits
Generous medical, dental, and vision plans
401K retirement plans and company match
Bonus potential for all positions
Paid Time Off
Paid holidays throughout the calendar year
We’ll support you 100%
Company
ICW Group
ICW Group Insurance Companies is a top-tier, national, multi-line Property & Casualty insurance company, providing comprehensive coverage to safeguard our customers’ world.
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
Rob deViere
Vice President, Head of Distribution & Marketing
Iva Yuan
Chief Actuary, Head of Reserving, Pricing and Product
Recent News
2025-10-09
Company data provided by crunchbase