Connor Roth

Data Engineer | Building reliable, scalable data solutions and connecting the dots that move the bottom line

Philadelphia, Pennsylvania, United States

About

I love solving complex problems and building data systems that stand the test of time. New and different challenges make me thrive, especially when I can bring structure to teams and help them see how the pieces connect. I've always seen value in being both deeply technical and business-minded - understanding how the engineering decisions made under the hood translate into real results. That dual perspective lets me design with purpose: ensuring every pipeline, model, and report not only performs well but drives meaningful impact. I take pride in being reliable and detail-oriented, while staying curious enough to keep learning and improving what I build. At Marsh McLennan Agency East as a Data Engineer, I am eager to keep streamlining, scaling, and finding better ways to turn data into business value.

Experience

  • Data Engineer at Marsh McLennan Agency
    Oct 2025 - Present · 9 mos

  • Data Engineer Associate at Chubb
    Jun 2023 - Oct 2025 · 2 yrs 5 mos

    - Served as lead engineer for high-visibility projects typically assigned to senior staff, advising a team of 7 offshore developers and resolving complex data engineering blockers. - Spearheaded the design and optimization of ETL data pipelines for underwriting and analytics datasets, incorporating data governance controls and pipeline performance monitoring to ensure scalability and reproducibility. - Owned data health initiatives, accounting for nearly 50% of the team’s monthly workload, by developing a flexible Python-based data health report and leading all data health ticket resolutions. - Recognized as a team expert in SQL and EDA; regularly consulted by stakeholders and upstream teams to resolve blockers and ensure successful delivery.

  • Data Analyst Co-Op at Berkley Technology Services
    Jun 2022 - Apr 2023 · 11 mos

    - Built and optimized Azure Data Factory and Databricks ETL pipelines, integrating data quality controls, pipeline performance monitoring, and cloud-native architecture. - Automated 80+ recurring SQL reports via Python, improving efficiency and reducing manual workload. - Conducted EDA to uncover inefficiencies in customer experience and drive stakeholder decisions. - Led stakeholder meetings to uncover business requirements, creating detailed Jira tickets and effectively prioritizing backlog items to align development efforts with business goals.

  • Quantitative Consultant at BioVid Corporation
    Sep 2021 - May 2022 · 9 mos

    - Provided internal advisory support to research teams, offering guidance on quantitative methodology and best practices. - Assisted in designing and refining surveys, questionnaires, and discussion guides to ensure analytical rigor. - Conducted advanced quantitative analyses using SPSS and other statistical tools, supporting team deliverables. - Developed clear, impactful data visualizations and executive summaries to aid team reporting and presentations. - Supported junior team members through guidance on analysis approaches, interpretation of results, and methodological improvements.

  • BioVid Corporation (Full-time · 2 yrs 4 mos)
    • Engagement Manager
      Mar 2021 - Jul 2021 · 5 mos

      - Promoted to lead high-impact research projects, including six-figure demand forecasting using proprietary methodologies. - Designed and executed advanced quantitative analyses in SPSS, generating actionable insights for client strategy and reporting. - Produced clear, visually impactful data visualizations and executive summaries delivered in client-ready PowerPoint presentations. - Led weekly client meetings and larger team presentations, engaging up to 30 stakeholders to communicate findings and recommendations. - Mentored and trained new hires, providing regular coaching, feedback, and guidance on research best practices.

    • Associate Engagement Manager
      Mar 2020 - Mar 2021 · 1 yr 1 mo

      - Promoted to lead research projects, drafting research materials aligned with business objectives and analytical requirements. - Held regular client meetings to provide updates, build relationships, and ensure alignment with project goals. - Designed and executed complex quantitative analytical frameworks, delivering actionable insights for client strategies. - Presented findings collaboratively with senior client stakeholders, translating analysis into impactful business recommendations. - Mentored and guided junior quantitative researchers through weekly coaching, best-practice sessions, and iterative feedback.

    • Senior Project Coordinator
      Apr 2019 - Mar 2020 · 1 yr

      - Collaborated on first drafts of questionnaires and discussion guides presented to the client. - Conducted qualitative interviews with physicians and patients to better understand their perceptions, motivations, and hard-wiring as human beings. - Crafted bespoke quantitative analyses utilizing SPSS that powered insights drawn into final reports. - Elevated insights through a series of clean, impactful data visualizations backed up by pithy summaries of key findings, neatly packaged in PowerPoint form.