Senior Data Engineer

Data Engineer Must have • Technical Skills: moving to the cloud – SQL, Python, Microsoft Azure. Microsoft shop. • Must come from white glove service company, like a law firm. And has worked in a fast paced environment. • Living in EST hours already Job Title Senior Data Engineer C/CTH/Perm + Duration 6 Month Contract 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. Notes from our meeting The data team at GP has a few people out of office right now and they are also trying to increase their FTE head count. While those FTE people are being hired and trained up to speed, they need a few extra hands to come in and make sure everything still gets deployed on time. • Project: They're moving everything to the cloud (Azure), so the projects are all tied to that initiative right now. They have the frameworks done, just need to move over the data. • Technical Skills: moving to the cloud – SQL, Python, Azure. Microsoft shop. • Soft Skills: culture - – white glove service/law firm. Fast paced environment. • Duration: 6 months – open to remote for these roles / Living in EST hours is ideal • Location: open to remote but can go onsite at any of their locations if they wish • Interview Process: With a manager and 1 engineer (1-2 rounds) • PERK: Free lunch Tues-Thurs in the office if they choose to go in on any of those days • US Locations: LA, NYC, Boston, Philly, San Fran, Santa Monica, Silicon Valley, DC Job Description: The role of Senior Data Engineer, Temporary 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: Data Platform Modernization: Manage, evaluate and enhance our existing data platforms, identifying opportunities to leverage emerging technologies and cloud-based solutions. By modernizing our data infrastructure, we can improve scalability, accessibility, turnaround times, and security, paving the way for advanced analytics and driving data-based insights. Process Creation and Optimization: Contribute to the establishment of standards, and procedures for data governance, integration, quality management, and lifecycle management. By optimizing these processes, we will ensure data consistency, accuracy, and timeliness, enabling reliable decision-making across the organization. Collaboration: As a point of contact for the Data Services Team, the Senior Data Engineer, Temporary will collaborate with IT teams, business units, and senior management to drive change and foster a data-driven culture. They will provide expert guidance, informed research, and support, ensuring successful implementation and stakeholder engagement throughout the lifecycle of data projects. What You'll 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 • 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. • General Linux experience. • Experience with common law firm application DBs like iManage, WestKM, Foundation, etc. • Experience with Idera SQL Diagnostics Manager for SQL Monitoring, and troubleshooting.