Expert-level proficiency in Python and data engineering libraries (pandas, PySpark, SQLAlchemy).
Strong SQL skills for complex analytical queries and performance tuning across multiple platforms.
Experience with Apache Spark/PySpark for developing and debugging distributed data processing jobs.
Hands-on experience with Databricks, including notebooks and Delta Lake.
Familiarity with core Azure data services like Azure Data Factory and Azure Synapse Analytics.
Practical experience with Snowflake warehousing and data loading patterns.
Bachelor's degree in a quantitative field with 2-4 years of relevant experience.
Responsibilities
Design, build, and maintain production ETL pipelines for predictive modeling.
Develop and optimize PySpark jobs on Databricks for performance and reliability.
Write complex SQL for data transformation and reporting across various platforms.
Collaborate with data scientists to translate data requirements into engineering solutions.
Monitor pipeline health and troubleshoot failures to improve data quality.
Document data flows and pipeline logic for institutional knowledge.
Present project progress and architecture decisions to business stakeholders.
Benefits
Comprehensive benefits package including health, dental, and vision insurance.
Participation in a discretionary annual incentive program.
Opportunities for professional development and training.
Collaborative and fast-paced work environment.
Access to cutting-edge technology and tools.
Full Job Description
Job Description
Chubb's PRS Data Science team builds data pipelines and analytical solutions that power predictive models directly supporting our insurance products and business partners. We operate in a fast-paced, collaborative environment where engineers own work end-to-end-from ingestion and transformation to delivery of production-ready datasets consumed by data scientists and decision-makers across the organization.
We are looking for an early to mid-career Data Engineer who is passionate about building reliable, scalable pipelines and who thrives at the intersection of engineering and business impact.
Responsibilities
Design, build, and maintain production ETL pipelines for predictive modeling workloads.
Develop and optimize PySpark jobs on Databricks, ensuring performance and reliability at scale.
Write complex, well-structured SQL for data transformation, validation, and reporting across SQL Server, Synapse Analytics, and Snowflake.
Collaborate with data scientists to understand data requirements and translate them into robust engineering solutions.
Monitor pipeline health, troubleshoot failures, and implement improvements to data quality and observability.
Document data flows, schemas, and pipeline logic to maintain institutional knowledge.
Present project progress, architecture decisions, and results to business stakeholders in a clear, concise manner.
Partner with platform and cloud engineering teams on Azure infrastructure and Databricks workspace management.
Qualifications
Technical Skills
Python: Expert-level proficiency; strong command of data engineering libraries (pandas, PySpark, SQLAlchemy), code quality practices, and packaging.
SQL: Expert-level; able to write complex analytical queries, window functions, CTEs, and performance-tune queries across multiple platforms.
Apache Spark / PySpark: Comfortable developing and debugging distributed data processing jobs; understands Spark execution model and optimization basics.
Databricks: Hands-on experience with notebooks, Delta Lake, Jobs/Workflows, and cluster configuration.
Azure: Working experience with core Azure data services (Azure Data Factory, Azure Data Lake Storage, Azure Synapse Analytics, or equivalent).
SQL Server & Synapse Analytics: Experience querying and loading data; understanding of schema design and indexing strategies.
Snowflake: Practical experience with Snowflake warehousing, data loading patterns, and role-based access.
Windows: Comfortable working in a Windows-based development environment.
Education & Experience
Bachelor's degree in Computer Science, Information Systems, Mathematics, Engineering, or a related quantitative field.
2-4 years of professional experience in a data engineering, analytics engineering, or software engineering role with a significant data focus.
Soft Skills
Strong written and verbal communication skills; able to present technical concepts to non-technical business audiences.
Collaborative team player who engages proactively with data scientists, analysts, and business partners.
Detail-oriented with a bias toward clean, maintainable, and well-tested code.
Comfortable managing multiple priorities in a fast-paced delivery environment.
Nice To Have
CLI tools: Familiarity with shell scripting, command-line data tools, and working in Linux environments.
Version control: Experience with Git-based workflows in a team setting.
Orchestration: Exposure to workflow orchestration tools (e.g., Apache Airflow, Azure Data Factory pipelines, Databricks Workflows).
Insurance / financial services domain: Prior experience in a regulated industry is a plus but not required.
CI/CD: Familiarity with automated testing and deployment pipelines for data assets.
The pay range for the role is $82,000 to $92,000. The specific offer will depend on an applicant's skills and other factors. This role may also be eligible to participate in a discretionary annual incentive program. Chubb offers a comprehensive benefits package, more details on which can be found on our careers website. The disclosed pay range estimate may be adjusted for the applicable geographic differential for the location in which the position is filled.
About Chubb
Chubb Limited is a Swiss-based global insurance company that provides commercial and personal property and casualty insurance, personal accident and supplemental health insurance (A&H), reinsurance, and life insurance to a diverse group of clients. Chubb operates in 54 countries and territories and is the world's largest publicly traded property and casualty insurance company. The company has a long history, dating back to 1882, and has grown through a series of mergers and acquisitions. Chubb is known for its high-quality insurance products and services, as well as its strong financial performance and commitment to corporate social responsibility.
