Senior Data Engineer

About Ropes & Gray

Ropes & Gray is a preeminent, global law firm. The firm has been ranked in the top-three on The American Lawyer's prestigious "A-List" for seven years and is ranked #1 on Law.com International's "A-List" in the U.K. - rankings that honor the "Best of the Best" firms. The firm has approximately 2,500 lawyers and professionals serving clients in major centers of business, finance, technology, and government in Boston, Chicago, Dublin, Hong Kong, London, Los Angeles, New York, San Francisco, Seoul, Shanghai, Silicon Valley, Singapore, Tokyo and Washington, D.C.The firm has consistently been recognized for its leading practices in many areas, including asset management, private equity, M&A, finance, real estate, tax, antitrust, life sciences, health care, intellectual property, litigation & enforcement, privacy & cybersecurity, and business restructuring. Ropes & Gray is an equal opportunity employer.

Overview

The Senior Data Engineer will enhance core data infrastructure through validations, transformations, normalizations, reports, extracts, and integration processes. The role demands superior analytical skills, attention to detail, and effective communication and collaboration with both technical and non-technical partners.

Expertise in Microsoft SQL 2019 stack and experience with REST API, Python, and .NET is required.

Responsibilities

• Collaborate with business sponsors, senior management, and Finance and IS teams to propose data solutions.
• Design, develop, implement, and maintain high-quality data integrations and real-time data services.
• Participate in program development and suggest improvements to team processes and tools.
• Communicate accurate project and task estimates and status.
• Mentor junior developers.

Essential capabilities:

• Maintain confidentiality of firm and client affairs.
• Present a customer service focus with internal and external clients.
• Be able to manage multiple concurrent objectives and prioritize effectively.
• Commit to meeting deadlines.
• Excel in an innovative, fast-paced environment.
• Possess strong leadership and interpersonal skills.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field; or equivalent work experience.
• Minimum 7 years of experience in business intelligence and report development (4 years with Microsoft BI Stack).
• Proficiency with MS SQL Server 2019 or later and related technologies.
• Experience building data pipelines using REST API, .NET, Python, Java, Scala, or similar.
• Experience with TFS or similar work management and coding repositories.
• Strong troubleshooting and performance tuning skills.
• Understanding of relational and multi-dimensional database design and architecture.
• Experience with Profisee, Redgate, Git, Alteryx is a plus.
• Ability to work independently, take ownership, and contribute to team success.
• Strong communication skills and ability to collaborate and build relationships

Compensation and Total Rewards Package

Ropes & Gray is proud to offer a comprehensive Total Rewards package to our business support team members. The firm also offers comprehensive health and well-being benefits, personal and professional development, career growth opportunities and a collegial and supportive culture. The anticipated pay range for this role is listed below and represents our good faith and reasonable estimate of the starting salary range at the time of posting. In addition, this role is eligible for a discretionary bonus based on performance. The actual offered rate for this position will be determined based on job-related, non-discriminatory factors, including qualifications and experience, geographic location, education, external market data and consideration of internal equity.

• Boston: $107,100 - 163,350

Working Conditions

This position requires hybrid on-site presence as an essential function of the role. Consistent and predictable on-site presence is required for ongoing business continuity, professional development and effective collaboration with colleagues and management.