Senior Data Engineer / Architect
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/Architect will architect, develop, and implement enhancements to our core data infrastructure through data validations, transformations, normalizations, reports and extracts, and integration processes that strengthen internal business applications and client reporting functions.
This individual will also be responsible for working with internal customers to prioritize projects and ensure alignment with business goals. 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 understand, document, and propose data solutions.
- Design, develop, implement, and maintain high-quality data integrations and real-time data services in support of enterprise applications and reporting.
- Architect data infrastructure enhancements to support evolving business needs.
- Work with internal customers to prioritize projects and ensure alignment with business goals.
- Actively participate in program development, be willing to identify and investigate improvements to team processes and tools, and present topics.
- Maintain and effectively communicate accurate project and task estimates and status.
- Mentor junior developers on learning new technologies and approaches to data management.
Essential capabilities include:
- Ability to maintain strict confidentiality of the firm’s internal and personnel affairs as well as those of our clients.
- Customer service focused with internal and external clients with the ability to develop effective partnerships across the organization.
- Ability to organize, plan, and carry out multiple concurrent objectives or activities, and effectively make judgments in prioritizing and time allocation in a high-pressure environment.
- Ability to commit to and deliver on deadlines.
- Excels in an innovative, intellectually challenging, and fast-paced environment.
- Excellent communication skills (written & verbal) and be equally effective interacting with both business and IT professionals.
- Strong leadership and interpersonal skills
Qualifications:
- Bachelor's degree in Computer Science, Information Systems, or related field; or equivalent work experience.
- Minimum 10 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: $123,200 - $187,950
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.