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.
Solar Project Engineer delivering design and problem - solving services to project teams at Solar Landscape, a leading commercial rooftop solar developer.
Field Validation & Verification Engineer testing GNSS products at Topcon. Perform validation and verification testing of surveying solutions in a controlled environment.
Senior Engineer managing condition based maintenance in the East Carolinas Region for Duke Energy. Mentoring analysts and leading CBM program development and execution across the fleet.
Engineer at FIT Solutions providing innovative IT services and support. Collaborating with clients to troubleshoot and resolve technical issues as part of a hybrid work environment.
5G O - RAN Orchestration & SMO Engineer responsible for management plane of onboard 5G stack. Delivering secure satellite connectivity services in a cutting - edge environment.
Modern Workplace System Engineer at Swiss Re developing and supporting Microsoft Windows - based workplaces. Supporting Digital Workplace and enhancing technology solutions for over 17,000 employees globally.
Forensic Fire Engineer providing in - house consulting services for electrical fire origin and cause investigations. Collaborating with claims professionals to enhance risk evaluation and prevention strategies.
Project Engineer coordinating interior systems and collaborating with clients and suppliers in the automotive industry. Managing engineering documentation and overseeing production builds.
Project Engineer working with EDAG and clients on Body Exterior Systems in the automotive sector. Supporting engineering projects, maintaining documentation, and collaborating with suppliers and teams.