Senior Data Engineer - Ropes & Gray LLP

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:

A successful Senior Data Engineer must possess superior analytical skills and be detail-oriented. This role requires the ability to communicate effectively as part of a larger team within the finance technology department. Additionally, you will need to explain complex technical concepts to non-technical staff. Since development of data models and logical workflows is common, a Senior Data Engineer must also exhibit advanced visualization skills, as well as creative problem-solving.

Responsibilities:

• Design, develop, implement, and maintain business intelligence, dashboard, and reporting solutions for the enterprise
• Design, develop, implement, and maintain enhancements to the data warehouse, master and reference data management capabilities, data integration layer, and enterprise data services shared across applications and reporting
• Partner with business sponsors, senior management and across IS teams to understand, document, and propose business intelligence and reporting solutions
• Develop and maintain accurate project and task estimates
• Stays current on technology best practices, trends in UI/UX
• Continuously drives process improvements and technical innovations
• Provide technical expertise and guidance on software development tools. technology, frameworks, and development methodologies
• Understand our business comprehensively, including the applications' functional and non-functional requirements and their impact on staffing
• Provide technical expertise to help resolve development and application issues, resolve performance problems, and drive career development
• As a member of the Data Management team, deliver high quality data management solutions through proactive testing and on-going quality monitoring
• Actively engage with business sponsors and stakeholders to review, provide feedback, and understand business requirements
• Identify, champion, and lead platform improvement opportunities of processes and tooling
• Actively participant in program development, be willing to investigate and present topics to the rest of the team
• Develop and maintain solutions adhering to business processes with defined data quality rules and bi-directional workflow integration with other data platforms
• Mentor junior developers on learning new technologies and approaches to data management 
• All other duties as assigned

 

 

ESSENTIAL CAPABILITIES:

• 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 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
• Appreciation of front-end UI aesthetics, functionality, design, and development
• Growing into BI Solutions Lead experience, strong work ethic, and analytical skills
• 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
• Legal services or professional services experience a plus

 

Qualifications:

• Bachelor's degree in Computer Science, Information Systems, or related field; or equivalent work experience
• A minimum of 7+ years' software development experience, with experience in .NET, C#, Asp.net, and MVC
• Minimum 7 years of experience in business intelligence and report development (4 years within Microsoft BI Stack)
• Experience working with Java Script frameworks and third-party components. Angular, React and Type Script is a plus
• 3 years of cloud technology experience, preferably with the Microsoft Azure data management and development platform
• Must have an in-depth understanding and experience with Front-End and Back-End development and databases
• Strong experience developing Windows, Apple, cloud-based applications; in addition to development of API integration with APl's, and other webhooks and services
• Proficient in MS SQL Server 2019 or later and related technologies (SSIS, SSRS, SSAS, MDM)
• Experience building data pipelines using programing languages such as .NET, Python, Java, Scala, or similar technologies.
• Experience with development, data management, and solution deployments in both on-prem and cloud technology platforms
• Experience with TFS or similar technology used for work management and coding repositories
• Strong troubleshooting and performance tuning skills - should be able to identify and resolve performance issues involving complex code
• Demonstrated understanding of relational and multi-dimensional database design and architecture
• Demonstrated ability to develop front-end data gathering, reporting and analytical solutions that meet business need
• Development experience with Tableau 10, MicroStrategy, PowerBI, Profisee a plus

Familiarity with Redgate, Git, Alteryx, Python, APIs a plus

Comprehensive 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 Boston: $100,000 - $151,000, NY: $105,000 - $158,000  which 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.  

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.