About the role

  • Data Services Engineer at Cozen O'Connor responsible for building and maintaining data systems. Focus on ETL processes and data accuracy while working in a hybrid environment.

Responsibilities

  • 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.

Job title

Data Services Engineer

Job type

Experience level

Mid levelSenior

Salary

$120,000 - $140,000 per year

Degree requirement

Bachelor's Degree

Tech skills

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job