Data Engineer

Cozen O'Connor

Data Engineer responsible for building and maintaining systems to store and deliver firm data at Cozen O'Connor. Collaborating with teams to ensure accurate and secure data access.

Posted 4/30/2026full-timePhiladelphia • Pennsylvania • 🇺🇸 United StatesMid-LevelSenior💰 $120,000 - $140,000 per yearWebsite

Tech Stack

Tools & technologies

CloudETLSQL

About the role

Key responsibilities & impact

Learn and maintain a deep understanding of the firm’s transactional system data, including how it is structured, used, and integrated across business applications.
Develop, manage, and monitor ETL/ELT data integration pipelines to ensure high quality data and seamless movement between systems and platforms.
Write, test, and optimize SQL queries, stored procedures, functions, and scripts to extract, transform, and retrieve data efficiently and reliably.
Develop, manage and maintain business intelligence and reporting tools (operational reports, dashboards, ad-hoc analysis) to support the business objectives of the firm.
Apply best practices in data governance and metadata management to support consistency, transparency, and compliance across the data ecosystem.
Create and maintain clear, well organized technical documentation that supports ongoing development, troubleshooting, and knowledge sharing.
Collaborate with the IS Compliance team to provide required evidence for audits and to support ongoing ISO certification renewals.

Requirements

What you’ll need

Degree in Information Systems, Information Technology or other related field and/or commensurate work experience.
3-5 years of TSQL development experience, focused on ETL/ELT development. Experience includes parsing, validation, transformation, and storage of JSON data structures within on-premises and cloud-based SQL Server implementations.
Experience with Microsoft Fabric and modern data warehouse architecture.
Experience with data cleansing and preparation for AI-based systems.
Experience in the legal industry is strongly preferred, but not mandatory.
Experience in a hybrid on-premises and cloud-based environment is preferred.
Strong analytical and problem-solving skills, with the ability to operate in fast-paced, distributed environments.
Excellent communication and collaboration skills, with experience working across cross-functional teams.

Benefits

Comp & perks

🌐 Worldwide ❌ Jobs You've Hidden ⭐️ Saved Jobs ✅ Applied Jobs ✉️ Email Alerts 👤 Account Cozen O'Connor Website LinkedIn All Job Openings 1001 - 5000 employees Founded 1970 🤝 B2B 📋 Compliance B2B
Legal
Compliance Cozen O'Connor is a global law firm that provides a wide range of legal services, including litigation, corporate law, and regulatory compliance. With professionals across various sectors, the firm is dedicated to serving the needs of businesses and individuals by navigating complex legal issues and ensuring client success through strategic counsel and representation. Data Engineer 🔥 15 minutes ago 🏢🏡 Philadelphia – Hybrid 💵 $120k - $140k / year ⏰ Full Time 🟡 Mid-level 🟠 Senior 🚰 Data Engineer Cloud ETL SQL Apply Now Find Hiring Managers Customize resume for this job Report problem ☆ Save ☑️ Mark as applied ❌ Hide 📋 Description
Learn and maintain a deep understanding of the firm’s transactional system data, including how it is structured, used, and integrated across business applications.
Develop, manage, and monitor ETL/ELT data integration pipelines to ensure high quality data and seamless movement between systems and platforms.
Write, test, and optimize SQL queries, stored procedures, functions, and scripts to extract, transform, and retrieve data efficiently and reliably.
Develop, manage and maintain business intelligence and reporting tools (operational reports, dashboards, ad-hoc analysis) to support the business objectives of the firm.
Apply best practices in data governance and metadata management to support consistency, transparency, and compliance across the data ecosystem.
Create and maintain clear, well organized technical documentation that supports ongoing development, troubleshooting, and knowledge sharing.
Collaborate with the IS Compliance team to provide required evidence for audits and to support ongoing ISO certification renewals. 🎯 Requirements
Degree in Information Systems, Information Technology or other related field and/or commensurate work experience.
3-5 years of TSQL development experience, focused on ETL/ELT development. Experience includes parsing, validation, transformation, and storage of JSON data structures within on-premises and cloud-based SQL Server implementations.
Experience with Microsoft Fabric and modern data warehouse architecture.
Experience with data cleansing and preparation for AI-based systems.
Experience in the legal industry is strongly preferred, but not mandatory.
Experience in a hybrid on-premises and cloud-based environment is preferred.
Strong analytical and problem-solving skills, with the ability to operate in fast-paced, distributed environments.
Excellent communication and collaboration skills, with experience working across cross-functional teams. Apply Now 📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score 🌐 Worldwide Built by Lior Neu-ner. I'd love to hear your feedback — Get in touch via DM or support@remoterocketship.com Search Search Jobs by country Search jobs by city Search jobs by job title Search entry-level jobs Search junior-level jobs Search senior-level jobs Search jobs by tech stack Search jobs by contract type Search remote internships Search remote part-time jobs Remote jobs Anywhere in the World Companies Hiring Anywhere in the World Companies Hiring Sales People Anywhere in the World Companies Hiring Software Engineers Anywhere in the World Resources Advice Tips for finding remote jobs Interview questions and answers Resume examples Cover letter examples Post a job Affiliates Privacy policy Terms of service Job board SEO course AI Apply Copilot OpenClaw job finder Jobs by Country Remote jobs anywhere in the world (Worldwide remote jobs) Remote jobs United States Remote jobs Australia Remote jobs Brazil Remote jobs Canada Remote jobs France Remote jobs Ireland Remote jobs Germany Remote jobs Netherlands Remote jobs Spain Remote jobs UK Popular Jobs Remote data analyst jobs Remote customer support jobs Remote executive assistant jobs Remote marketing jobs Remote product designer jobs Remote product manager jobs Remote project manager jobs Remote recruiter jobs Remote sales jobs Remote software engineer jobs Jobs by Type Remote full-time jobs Remote part-time jobs Remote contract jobs Remote internship jobs Remote entry-level jobs Remote jobs with no experience required Remote junior jobs (1-3 years of experience) Digital nomad jobs Remote jobs with no degree required Freelance remote jobs Temporary remote jobs Remote jobs hiring now Stay at home mom jobs

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

ETLELTTSQLSQL queriesstored proceduresdata integrationdata cleansingmetadata managementdata governanceJSON data structures

Soft Skills

analytical skillsproblem-solving skillscommunication skillscollaboration skills

Certifications

ISO certification