Sr. Data Engineer

Make an impact at Goodwin, where we partner with our clients to practice law with integrity, ingenuity, agility and ambition. We are in the business of building authentic, long-term relationships with our clients, who are 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. Our immersive understanding of these industries ? combined with our expertise across high-stakes litigation and dispute resolution, world-class regulatory compliance and advisory services, and complex transactions ? sets us apart. Our Global Operations Team ? all business professionals of the firm ? was named the ?Best Business Team? by The American Lawyer. The role of Senior Data Engineer is essential for the successful modernization of our data platforms and practices. This role will play a crucial role in the following, but not limited to, areas: What You Will Do... Data Platform Management: Evaluate, enhance, and modernize Goodwin?s data platforms, including exploring emerging technologies and cloud-based solutions to improve scalability, accessibility, and security. Process Optimization: Contribute to establishing and optimizing 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 (Mostly, but not limited to Microsoft SQL Server), data engineering processes, identifying areas for improvement, and driving innovation to enhance data processing efficiency, data quality, and overall system performance. Who You Are: BS in Computer Science or related field is preferred. 5 or more years of experience as Database Architect/Data Engineer. Proven track-record working 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. Data Factory experience preferred as well. Advanced SSRS. Advanced Powershell Scripting for DB operations and automation. C# Scripting in SSIS (Script Task). Experience in Data Warehousing. Experience working with cloud based data platforms (Azure preferred). Familiarity with OpenAI technologies and how to leverage data for successful use of those technologies. Strong knowledge of the Microsoft Azure Data Platform. Expertise in using and administering the Azure ?Power? platform tool chain as it relates to data and automation. 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. Some knowledge of Python required. Experience working in an Agile workflow. 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 DBs like Aderant Expert, iManage, WestKM, Foundation, etc. Experience with Idera SQL Diagnostics Manager for SQL Monitoring, and troubleshooting. #LI-MS1 Benefits and More At Goodwin, you will discover your next career opportunity with a rewarding compensation package and comprehensive benefits, including: 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 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. 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. Please note: Various agencies of the United States government require employers to collect information on applicants and employees. The National Association of Law Placement (NALP) and certain clients request us to keep track of certain aggregate information regarding lawyers. EEO information requested on this application is for purposes of compliance with these recordkeeping and reporting requirements and to determine recruiting and employment patterns. Submission of this information is voluntary and refusal to provide it will not subject you to any adverse treatment. This position is eligible for overtime: No Target Salary Range: Boston $112,400 - $168,700 | Los Angeles $112,400 - $168,700 | New York $119,200 - $178,800 | Philadelphia $105,700 - $158,500 | San Francisco $125,900 - $188,800 | Santa Monica $112,400 - $168,700 | Silicon Valley $125,900 - $188,800 | Washington DC $112,400 - $168,700 Professional career paths at Goodwin offer you more ? and less ? than you might expect. You?ll find less hierarchy and more meritocracy. You?ll have more chances to work across departments and offices, and fewer roadblocks to getting the job done. We believe people are happiest when they?re not limited by a ?that?s how we?ve always done it? approach, so we encourage a more imaginative and collaborative working environment. Our Global Operations Team ? what we call our GO! Team ? brings a level of professionalism, enthusiasm and commitment to work each and every day. 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. Introduce yourself to our recruiters and we'll get in touch if there's a role that seems like a good match. Servicing more than 1,000 pro bono clients a year. Through innovation and leadership the firm's pro bono program leverages our lawyers' interests and skillsets to help individuals and nonprofit organizations who could not otherwise afford legal assistance. Explore Our Pro Bono At Goodwin, we seek to paint a picture of diversity, equity, and inclusion (DEI) across various facets of our firm, the legal industry, and the communities in which we live. Through our ?Exploring the Art of Inclusion? initiative, we highlight opportunities to dismantle barriers to inclusion and further advancement throughout the talent lifecycle ? and how we can collectively make a concrete difference in the journey toward belonging for all. Explore With Us Our core principles are our foundation. They ground us and bind us together as a firm. Our commitment to these values is what drives us and what enables our success. Explore Our Core Principles