Combined Insurance - Whitehouse Station, NJ
posted 4 months ago
As a Sr ETL Developer on our Data Delivery team, you will serve as a critical resource in building and executing on Chubb's information strategy in support of our personal lines business. With us, you'll leverage your experience working across data warehousing and business intelligence environments to work with data sources spanning various platforms, sources, and data types. You'll build and execute complex ETL jobs that marry multiple, disparate sources together, bringing data from across the personal business into a central repository utilized by our stakeholder teams to conduct studies, develop reporting, and put together complex analysis that directly impacts the advancement of our business. In so doing, you will partner with peers as well as Data Analysts, Testers, and Report Developers to assess data requests made to our team, as well as to evaluate the up and downstream impacts of those changes within our environment. Your role will be instrumental as we acquire, cleanse, and transform the data that is at the core of our business. In this role, you will take ownership of your projects and deliver high-quality data-driven solutions. You will work across data sources and types to build, optimize, integrate, and/or troubleshoot the ETL jobs that bring data from across the personal lines business into a centralized repository. Collaboration with peers and stakeholders across business and technical teams will be essential to define requirements, identify source data, assist with high-level data designs, analyze, and troubleshoot data issues. You will conduct senior-level analysis utilizing SQL to facilitate the data integration process through profiling data, understanding relationships in the data, and validating the integrity of the data. Additionally, you will synthesize data, uncover inherent trends in data, assess impacts of data on business usage, and make recommendations for improvement. You will also create UNIX shell scripts to perform file-level validation and analysis, as well as create Jll files and utilize AutoSys for job orchestration, monitoring, and reporting.