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.
Senior Software Algorithm Engineer developing algorithms across technical domains for customer missions. Leading a team of developers in a high - performing environment to support national security objectives.
Packaging Engineer designing and validating packaging solutions for next - generation networking systems at Nexthop Systems. Focused on innovative problem - solving and industry standards compliance.
Senior Fire Protection Engineer leading design efforts for complex building projects at IMEG. Collaborating with engineers and clients to develop fire protection solutions while mentoring team members.
Senior Water Resources Engineer leading projects for water infrastructure solutions. Collaborating with multidisciplinary teams to deliver high - quality sustainable water management designs.
Mid - level design engineer supporting San Francisco office in sustainable water management and civil engineering projects. Collaborate on multidisciplinary design teams for site development projects.
Sr. Project Development Engineer ensuring technical success of utility - scale renewable projects. Collaborates across teams for evaluations, designs, and M&A transitions in clean energy.
Engineer conducting structural analysis of rotor blades for wind energy plants. Responsible for design improvement, load requests in production, and certification documentation.
Asset Engineer providing expertise for lab and process equipment in CAR - T therapy. Supporting commissioning and qualification in clinical and commercial cell therapy manufacturing in Belgium.
Power Studies Engineer at EVS supporting advanced electrical system modeling and analysis across utility projects. Collaborating with teams to deliver high quality power system studies.
Project Engineer at Honeywell designing and delivering turbomachinery control systems. Engage in full project lifecycle, collaborating across teams to ensure operational efficiency and client satisfaction.