SQL Data Analyst
Lensa
Job Overview
Who's the hiring manager?
Sign up to PitchMeAI to discover the hiring manager's details for this job. We will also write them an intro email for you.
Job Description
About the Role
Lensa, a career site helping job seekers, promotes this SQL Data Analyst position on behalf of its partner, Insight Global, who is recruiting for a prominent global law firm. This role is a year-long contract with potential for extensions, operating remotely with a preference for EST hours (starting between 8-9 AM EST).
The Firm
The global law firm, a leader in corporate law, litigation, intellectual property, life sciences, technology, and venture capital, boasts nearly 1,400 lawyers and over 3,000 employees across 19 offices worldwide. Recognized for its exceptional workplace culture, the firm has received accolades such as Fortune's Best Companies to Work For, Best Workplaces for Women, Best Workplaces for Flexibility, Best Workplaces for Giving Back, and Best Workplaces for Parents.
Key Responsibilities
As a SQL Data Analyst, you will join a team of three to address requests from various departments regarding existing application integrations. Your primary responsibilities will include:
- Analyzing requests to identify and resolve errors within existing integrations.
- Troubleshooting issues related to data processing and schema changes within SQL environments.
- Designing and implementing solutions for integration modifications and ad hoc requests.
- Validating data integrity, particularly when adding or modifying columns in the SQL database to ensure correctness.
- Contributing to the foundational work needed before the firm builds out a comprehensive data lake.
Compensation and Benefits
This contract position offers a competitive hourly rate of $45 to $50. Employees will receive a comprehensive benefits package starting day one, including medical, dental, and vision insurance options. Eligibility for 401(k) retirement plan begins after 90 days. Paid sick leave and other paid time off benefits are provided as required by applicable law.
Required Skills and Experience
- 2+ years of hands-on experience in SQL, focusing on writing, optimizing, and troubleshooting complex T-SQL queries and stored procedures.
- Proven ability to diagnose and resolve issues efficiently within SQL Server environments.
- Practical experience in making database schema changes, including adding/modifying columns and validating data integrity.
- A background working within a law firm environment, with experience using InTapp, is highly preferred.
Key skills/competency
- SQL
- T-SQL
- Data Analysis
- Troubleshooting
- Database Schema
- Data Integrity
- Integration
- SQL Server
- Query Optimization
- Problem Solving
How to Get Hired at Lensa
- Research Insight Global's role: Understand Insight Global's position as a recruitment partner and their client's (the law firm) specific needs for SQL Data Analysts.
- Tailor your resume: Customize your resume to highlight 2+ years of SQL, T-SQL, and database troubleshooting experience relevant to a legal environment.
- Showcase problem-solving skills: Prepare examples demonstrating your ability to diagnose and resolve complex data integration and schema issues.
- Emphasize law firm fit: If you have InTapp or law firm experience, make it prominent; otherwise, show adaptability and quick learning for regulated environments.
- Prepare for technical SQL questions: Be ready to discuss query optimization, stored procedures, and data integrity challenges during interviews.
Frequently Asked Questions
Find answers to common questions about this job opportunity
Explore similar opportunities that match your background