Engineer, Enterprise Data Systems

Weil invests in the training and development of its employees, fostering a collaborative environment that encourages growth and teamwork. Highly skilled administrative staff play a vital role in supporting attorneys and exceeding client needs.

About the role

The Engineer, Enterprise Data Systems works directly with IS management and staff to support the administration, maintenance, and enhancement of the Firm's Microsoft SQL Server database and related applications. This role ensures application availability, minimizes downtime, and participates in the development, testing, integration, maintenance, and support of all Firm systems that rely on SQL Server.

Responsibilities

• Assist in maintaining all SQL instances and databases to support system availability.
• Troubleshoot and resolve issues as they arise, providing support to application owners.
• Assist with configuration and installation of Microsoft SQL Server, including database mirroring and AlwaysOn Availability Group setup.
• Support SQL Server infrastructure administration, including performance tuning, system monitoring, and issue resolution.
• Maintain the Firm's Document Management System and its underlying databases, including periodic upgrades and enhancements.
• Support the Firm's financial application and related tasks.
• Develop and maintain data integrations and consistency across Firm systems.
• Assist in the analysis and delivery of data stored in Firm systems through SQL Server business intelligence tools.
• Perform installations, upgrades, and customizations for new and existing SQL systems.
• Follow group procedures and policies related to the SQL Server environment, including installations, configurations, backups, disaster recovery, and other operations.
• Handle other responsibilities or special projects as assigned by management.

Requirements

• 3+ years of experience administering Microsoft SQL Server in an enterprise environment.
• Familiarity with Windows server operating systems and an understanding of server hardware as it relates to SQL Server (CPU, RAM, I/O subsystems).
• Basic understanding of networking concepts.
• Extensive experience writing advanced SQL queries and stored procedures, and troubleshooting their performance.
• Thorough understanding of relational database design principles (key selection, relationships, normalization).
• Strong working knowledge of SQL Server business intelligence tools (SSIS, SSAS, SSRS, PowerBI).
• Ability to create Datasource/DataFlow, PowerBI Dashboards, and migrate SSRS reports to PowerBI (preferred).
• Ability to work well under minimal supervision.
• Strong project and time management skills, with the ability to prioritize multiple projects.
• Self-motivated with excellent verbal and written communication skills.
• Experience providing technical support for large, geographically dispersed organizations.
• Highly analytical with strong problem-solving skills.
• Fast learner who adapts quickly.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related discipline.
• Microsoft SQL Server or other RDBMS certifications (a plus).
• Azure Certifications (a plus).
• PowerPlatform certification (a plus).
• iManage Work (ICSE) certifications (a plus).
• Experience with SQL Server in the Azure platform (a plus).
• Experience with scripting/programming languages such as PowerShell, .Net, and C# (a plus).
• Experience managing and administering iManage Work document management system (a plus).
• Experience working with Intapp Integrate / Integration Builder, Intapp Time, and Intapp Walls (a plus).

Pay

Estimated salary range is $125,000 - $145,000. Compensation decisions within the range depend on skills, experience, and qualifications.

Benefits

• Competitive compensation package including base pay and discretionary year-end bonus.
• Medical, dental, and vision coverage.
• Disability and life insurance.
• Flexible spending plan.
• 401K plan.
• Generous paid time off and holidays.