Sr. Data Engineer

Join Goodwin's Global Operations TeamJoin Goodwin's Global Operations Team, and make a real impact on a global scale. At Goodwin, we work with some of the world's most successful and innovative investors, entrepreneurs and disruptors in the life sciences, private equity, real estate, technology and financial industries, and where they converge. As part of the Global Operations Team all business professionals at the firm you'll collaborate with colleagues from varied backgrounds and experiences, fostering an environment where cross-functional learning, networking, and collaboration are at the core of what we do.Here, we're not just supporting a law firm; we're partnering with attorneys and clients to deliver cutting-edge solutions in high-stakes litigation and dispute resolution, world-class regulatory compliance and advisory services, and complex transactions. Our commitment to integrity, ingenuity, agility, and ambition drives us, and we're proud to have been recognized as the "Best Business Team" by The American Lawyer.This is your opportunity to grow professionally in a dynamic, global environment, surrounded by forward-thinking peers.The Role of Senior Data EngineerThe Senior Data Engineer is essential for the successful modernization of our data platforms and practices. The ideal candidate will have expertise in cloud technologies, data architectures and agile development principles. Key responsibilities include leading data architecture initiatives, supporting hybrid data integrations and implementing advanced analytics solutions. This role will play a crucial role in the following, (though not limited to: areas):Data Platform Modernization:Process Improvement and Automation:Collaboration:Data Platform Management:Process Optimization:Stakeholder Collaboration:Performance and Innovation:Who You AreThe ideal candidate will have:BS in Computer Science or related field is preferred.5 or more years of experience as 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 SkillsThe ideal candidate will also have: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.Benefits and MoreAt Goodwin, you will discover your next career opportunity with a rewarding compensation package and comprehensive benefits, including:Flexible work arrangements and hybrid work scheduleHealth, dental, and vision insuranceLife and disability insuranceRetirement & Savings PlanEmergency back-up child and adult carePaid vacation, sick time off, and holidaysProfessional development and career advancement opportunitiesEmployee recognition and reward programsEmployee wellness and assistance programsEmployee discounts and perksConsistent 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.Goodwin Procter LLP is an equal opportunity employer. This means that Goodwin Procter LLP considers applicants for employment, and makes employment decisions without unlawful discrimination on the basis of 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 or by phone at 617-570-1800. 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 you provide will be in the strictest confidence, and only used for the purpose of providing the accommodations needed. Requesting accommodations will not adversely affect the outcome of your application.This position is eligible for overtime: No. 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