SQL Data Analyst

SQL Data Analyst at a Global Law Firm

Lensa is a career site that helps job seekers find great jobs in the US. We are not a staffing firm or agency. Lensa does not hire directly for these jobs, but promotes jobs on LinkedIn on behalf of its direct clients, recruitment ad agencies, and marketing partners. Lensa partners with DirectEmployers to promote this job for Insight Global. Clicking "Apply Now" or "Read more" on Lensa redirects you to the job board/employer site. Any information collected there is subject to their terms and privacy notice.

A global law firm with nearly 1,400 lawyers and more than 3,000 employees across 19 offices in the United States, Europe, and Asia is looking for a SQL Data Analyst to join their data team. This team is responsible for resolving integration issues for various applications. The firm plans to build out a data lake for both internal and external data, but prior to that, all application integrations require thorough troubleshooting when issues arise. This is a year-long contract role with potential for extensions, offered remotely, though a preference for EST hours (starting between 8-9AM EST) is noted. The firm is highly regarded for its expertise in corporate law, litigation, intellectual property, life sciences, technology, and venture capital, handling transformative deals, IPOs, and complex regulatory matters. They have also received numerous workplace accolades, including being named to Fortune's Best Companies to Work For, and recognized as Best Workplaces for Women, Flexibility, Giving Back, and Parents.

Key Responsibilities

The SQL Data Analyst will join a team of three and primarily respond to requests from various internal teams and departments seeking changes to existing integrations. Responsibilities include:

• Analyzing requests to identify potential errors and their root causes.
• Troubleshooting error occurrences within SQL environments.
• Developing and implementing solutions to modify existing integrations and processing within SQL.
• Managing database schema changes, such as adding new columns.
• Handling ad hoc requests and validating data integrity, ensuring correctness of new or modified columns.

Compensation & Benefits

The compensation for this role ranges from $45/hr to $50/hr. Exact compensation may vary based on factors including location, skills, experience, and education. Employees in this role will receive a comprehensive benefits package starting on day one, including options for medical, dental, and vision insurance. Eligibility for the 401(k) retirement plan begins after 90 days of employment. Additionally, paid sick leave and other paid time off benefits are provided as required by applicable law.

About the Company

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com. To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

Skills and Requirements

• 2+ years of experience in SQL, including writing, optimizing, and troubleshooting complex T-SQL queries and stored procedures.
• Hands-on experience diagnosing and resolving issues within SQL Server environments.
• Proficiency in making database schema changes, such as adding/modifying columns and validating data integrity.
• A background in a law firm environment, with experience using InTapp, is preferred.

Key skills/competency

• SQL
• T-SQL
• Database Management
• Data Analysis
• Troubleshooting
• Data Integration
• Schema Design
• Data Validation
• SQL Server
• Stored Procedures