Law Firm
Boston, MA
Legal Staff Other in Boston, MA
Legal Staff
Min 5 yrs required
No
Job Title: Sr. Data Engineer
Job Responsibilities:
The Senior Data Engineer plays a pivotal role in modernizing data platforms and practices at the law firm. The responsibilities include:
- Data Platform Modernization: Managing, evaluating, and enhancing existing data platforms to leverage emerging technologies and cloud-based solutions, particularly Microsoft Azure/Fabric. This aims to improve scalability, accessibility, turnaround times, and security, facilitating advanced analytics and data-based insights.
- Process Improvement and Automation: Establishing standards and procedures for data management, integration, quality management, and process improvement. Documenting and optimizing these processes ensures data consistency, accuracy, and timeliness, which supports reliable decision-making across the organization.
- Collaboration: Serving as a point of contact for the Data Services Team, collaborating with IT teams, business units, and senior management to drive change and foster a data-driven culture. Providing expert guidance, informed research, and support ensures successful implementation and stakeholder engagement throughout the lifecycle of data projects.
- Data Platform Management: Evaluating, enhancing, and modernizing the firm's data platforms by exploring emerging technologies and cloud-based solutions to improve scalability, accessibility, and security.
- Process Optimization: Contributing to the establishment, documentation, and optimization of standardized procedures for data management, data governance, integration, quality management, and lifecycle management to ensure data consistency, accuracy, and timeliness.
- Stakeholder Collaboration: Collaborating with cross-functional teams, business units, and senior management to drive data-driven initiatives, foster a data-driven culture, and ensure alignment with organizational goals.
- Performance and Innovation: Monitoring and optimizing the firm’s data platforms, data engineering processes, identifying areas for improvement, and driving innovation to enhance data processing efficiency, data quality, and overall system performance.
Education and Experience Information:
- A BS in Computer Science or a related field is preferred.
- 5 or more years of experience as a Database Architect.
- 2-3 years of experience with data cloud technologies.
- Microsoft SQL Server Certification is preferred.
- Expertise with GenAI technologies (OpenAI/CoPilot preferred) and how to leverage data for successful use of those technologies.
- Expertise with Microsoft Fabric / Microsoft Azure Data Platform.
- Advanced Microsoft Azure Data Factory experience.
- Expertise in designing and implementing a cloud-based Data Lake/Lakehouse (Azure preferred).
- Expertise with Microsoft PowerBI.
- Expertise in Microsoft Azure Spark platform.
- Expertise with the Microsoft Azure Data Warehouse platform.
- Advanced knowledge of Python required.
- Advanced Powershell Scripting for DB operations and automation.
- Expertise with Microsoft SQL Server databases, including experience with related technologies.
- Expertise in Microsoft data development tools (SSMS, Visual Studio Data Tools).
- Advanced T-SQL development, troubleshooting, and optimization.
- SQL Server Performance Monitoring, and tuning.
- Advanced SSIS integration experience.
- High level expertise of ETL/ELT design.
- Expert knowledge of Data Pipeline design and creation.
- Advanced SSRS.
- Manage operations for proper Master Data Management (Profisee MDM) for data stewards.
- Support proper metadata management for the enterprise data catalog (Microsoft Purview) providing a centralized view of the firm’s data assets.
- Experience with C# scripting.
- High level technical expertise regarding the use of data models, database design and architecture techniques.
- Expertise in data warehouse design and management using the Kimball approach.
- Expert data visualization and data analysis skills required (Tableau, and PowerBI experience preferred).
- Experience working in an Agile workflow.
- Experience using Git for source control.
- Experience working with API calls and handling return data in JSON and XML.
- Intermediate to advanced HTML and CSS.
- Ability to work independently without close supervision.
- Genuine interest in and curiosity for database technologies, and data analytics.
- Strong knowledge of project management methodologies.
- Excellent organizational, teamwork, customer service and problem-solving skills required.
- Excellent written, verbal and interpersonal communication skills.
- Excellent time management skills.
Preferred Skills:
- General Linux experience.
- Experience with common law firm application databases like iManage, WestKM, Foundation, etc.
- Experience with Idera SQL Diagnostics Manager for SQL Monitoring, and troubleshooting.
Salary Information:
The target salary range for this position varies by location and is commensurate with relevant experience:
- Boston: $115,800 - $173,700
- Los Angeles: $121,600 - $182,400
- New York: $121,600 - $182,400
- Philadelphia: $108,800 - $163,300
- San Francisco: $129,700 - $194,500
- Santa Monica: $121,600 - $182,400
- Silicon Valley: $129,700 - $194,500
- Washington DC: $115,800 - $173,700
Benefits and More:
At the law firm, a rewarding compensation package and comprehensive benefits include:
- Flexible work arrangements and hybrid work schedule
- Health, dental, and vision insurance
- Life and disability insurance
- Retirement & Savings Plan
- Emergency back-up child and adult care
- Paid vacation, sick time off, and holidays
- Professional development and career advancement opportunities
- Employee recognition and reward programs
- Employee wellness and assistance programs
- Employee discounts and perks
Legal and Equal Opportunity Statements:
Consistent with the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance, an arrest and conviction record will not automatically disqualify a qualified applicant from consideration. Consistent with the SF Fair Chance Ordinance, an arrest and conviction record will not automatically disqualify a qualified applicant from consideration.
The law firm is an equal opportunity employer. This means that the law firm considers applicants for employment and makes employment decisions without unlawful discrimination based on race, color, gender, gender identity or expression, age, religion, national origin, citizenship status, disability, medical condition, genetic information, marital status, sexual orientation, military or veteran status, or other legally protected status.
To request a reasonable accommodation to participate in the job application or interview process in the US, contact the Benefits Department by email. To request any disability or neurodivergence-related accommodations to participate in the job application or interview process in the UK or Germany, please email the Recruiting Department. Any information provided will be kept in the strictest confidence and only used for the purpose of providing the accommodations needed. Requesting accommodations will not adversely affect the outcome of the application.
This position is not eligible for overtime.
Jun 16, 2025
|
Tell us where to send your access instructions: