Data Solutions Senior Engineer (Hybrid)

We are a Firm where people truly believe in what they do and strive to achieve the highest standards of performance and success.

General Description:

The Data Solutions Senior Engineer supports the development and management of the Firm's data warehouse / lakehouse, data analytics platforms, and related processes. This role contributes to the implementation and on-going support of the firm's cloud data systems and analytics tools and processes.

The Engineer works with technology, knowledge, business services, and practice teams to discover the firm's key operational data, assess intelligence and analytics needs, develop and communicate plans for data lake and analytics platform implementation, execute technical implementation of data platforms, and provide ongoing service, support, and planning for continued enhancements and user engagement. This role within our Data Strategy function partners closely with the Information Technology department and data and intelligence solutions teams in the development and delivery of the firm's data platforms. This role contributes to digital transformation programs, provides technical and business process support, and serves as a contact for internal resources, such as the Information Technology department, as well as external resources including vendors and consultants.

Key Responsibilities and Essential Job Functions:

• Support the design, development, and maintenance of data platforms. This role will be responsible for configuring and maintaining data warehouse / lakehouse and related code base and schemas for the firm, including integrations with Finance, HR, Marketing, and other firm-related database applications.
• Develop, document, and maintain key data integration processes in support of projects and ongoing services. Provide data integration services in support of local and hosted environments for enterprise applications including the use of APIs and other connection methods.
• Design, implement and maintain scalable and reliable data pipelines, data quality and transformation processes, and databases to support a variety of data and analytics needs.
• Designing and implementing scalable and secure data processing pipelines using Azure Data Factory, Azure Databricks, and other Azure services.
• Managing and optimizing data storage using Azure Data Lake Storage and Azure SQL Data Warehouse.
• Developing data models and maintaining data architecture to support data analytics and business intelligence reporting.
• Ensuring data quality and consistency through data cleaning, transformation, and integration processes.
• Proactive monitoring and troubleshooting data-related issues within the Azure environment to maintain high availability and performance.
• Collaborating with data scientists, business analysts, and other stakeholders to understand data requirements and implement appropriate data solutions.
• Implementing data security measures, including encryption, access controls, and auditing, to protect sensitive information.
• Automating data pipelines and workflows to streamline data ingestion, processing, and distribution tasks.
• Support the appropriate sourcing, evaluation, selection, and utilization of data engineering tools, particularly emerging artificial intelligence-enabled products.
• Support the custom development and implementation of proprietary Machine Learning, LLM and AI enabled products, including the selection and engagement of solutions partners, development of grounding, RAG, vectorizing, and related technical protocols and procedures. Support to use-case evaluation and product design and implementation.
• Optimize data processing systems to enhance performance, improve reliability and optimize cost.
• Participate in cross-functional relationships with software engineers, solutions engineers, and other business stakeholders to collaboratively create solutions, development standards, and support business processes.
• Partner with the broader Data Strategy team in the development and maintenance of a comprehensive and up-to-date data catalog by overseeing the capture of end-to-end data flows and the creation of source-to-target documentation, ensuring a detailed and accessible repository that enhances data understanding and transparency across the organization.
• Support a culture of excellence in data transformations and clear schema design, ensuring alignment with operational and analytical business requirements.
• Ensure our data architecture is secure and compliant per company policies and industry standards. Support information and data governance roles in applying appropriate firm policies.
• Collaborate among a team of data engineers and liaise closely with data solutions analysts and database administrators with a strong focus on high-quality solution delivery and team culture.
• Partner with IT staff, vendors, and other third parties to address system-level technical issues, manage internal and external integrations, and implement upgrades and enhancements.
• Support data and intelligence solutions teams as we establish COE and best practices for analytics and data dashboard and application design and development.
• Develop standard metrics reporting and analyze trends to measure the quality and quantity of data maintained within the data platform.
• Contribute to standard configuration documentation and related guides for data consumers. Collaborate to design end-user training, onboarding, and user adoption programs and communications.
• Special project and duties as assigned.

Required Skills:

• Excellent written and verbal communication skills. Excellent organizational, teamwork, customer service and critical thinking skills required.

Required Qualifications & Education:

• Bachelor's degree in relevant field.
• 15+ years' experience in a law firm, corporate legal department, or professional services environment, particularly within an innovation or KM function.
• 15+ years of direct experience in data management activities such as building data pipelines and database administration, data engineering, data sciences, and database administration.
• Excellent proficiency in business intelligence, data warehousing, application development, and data visualization.
• Strong knowledge and understanding of the legal technology landscape, including trends, tools, and industry standards. Extensive experience working with legal technology, workflow systems, legal project management, and practice management tools.
• Deep understanding of law firm structure and business practices, as well as practice-specific terminology. Experience working with a broad array of legal practices including transactional, litigation, and regulatory.
• Expert level of knowledge in SQL Server using the full Microsoft SQL Server stack including Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and PowerShell
• Expert knowledge in scalable and secure data processing pipelines using Azure Data Factory, Azure Databricks, and other Azure services.
• Expert knowledge in managing and optimizing data storage using Azure Data Lake Storage and Azure SQL Data Warehouse.
• Experience with, and willingness to learn more about, emerging Microsoft OneLake, Fabric, Power and related concepts and applications.
• In-depth knowledge of database systems, data warehousing concepts and data modeling techniques. Extensive experience with data management, process, and data system design in a legal or professional services firm
• Strong proficiency in programming languages such as Python and data processing framework such as Airflow.
• Proficiency with .NET and comparable developer tools.
• Exceptional proficiency working with MS Office and Power platform especially for analyzing and communicating data-related concepts.
• Experience in leveraging automation and AI-related technologies, such as Machine Learning and LLMs, to drive innovation in legal services.
• Proficiency with cybersecurity best practices and compliance requirements in the legal industry and for clients such as financial and governmental institutions
• Ability to develop effective and collaborative relationships among business teams, lawyers, firm administrative departments, and vendors.
• Demonstrated ability to support multiple complex assignments with competing deadlines and priorities. Experience supporting projects from inception through planning, execution, and delivery phases.

Preferred Qualifications & Education:

• Master's or related coursework strongly preferred.

Physical Requirements:

• Ability to sit or stand for extended periods of time.
• Moderate or advanced keyboard usage

This position may be filled in the District of Columbia or New York. In accordance with the District of Columbia Wage Transparency Law, New York State Pay Transparency Law, and New York City Human Rights Law, the pay range for this position in the District of Columbia is $141,700-$212,500/yr, New York State is $123,200 - $221,800/yr, and in New York City is $147,800 - $221,800/yr. These ranges are specific to these locations and may not be applicable to other locations. An individual's actual compensation will depend on the individual's qualifications and experience.

Benefits: Our goal is to promote a work environment in which individuals have access to the resources they need to be at their best both professionally and personally, which includes resources that encourage individuals to focus on their health and well-being. Below is a list of just some of the benefits we offer: generous paid time off; eleven paid holidays per year; time off for bereavement or jury duty; paid leave for new parents; comprehensive medical (PPO and HDHPs), dental and vision plans including coverage for domestic partners; life and AD&D insurance; short and long term disability insurance; tax-advantaged accounts for health care expenses, including FSA or HSA; FSA for dependent care; supplemental AFLAC policies for medical care; excess liability coverage; health advocacy services; behavioral health and counseling resources for all family members; 401(k); profit sharing; pre-tax transit and parking program; backup care for children and adults; senior care planning support; and resources for individuals with development disabilities and their caregivers.

Benefits may vary by position and office.

Holland & Knight is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Opportunity Employer, making decisions without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability status, age, marital status, protected veteran or any other protected class.

Personal Information collected from applicants will be used for the purpose of processing the application throughout any recruitment or employment process, as well as inclusion in a personnel file. Categories of data collected may include name, address, phone numbers, email, Social Security Number, and signature. Holland & Knight may collect further information if you consent to a background check. This includes criminal background, employment, and certifications. Please visit Legal Information Portal for Holland & Knight LLP's privacy policies.