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 Lensa
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.
About the Global Law Firm
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 firm is widely recognized for its expertise in corporate law, litigation, intellectual property, life sciences, technology, and venture capital, advising on transformative deals, IPOs, and complex regulatory matters. The firm has earned numerous workplace accolades, including being named to Fortune's Best Companies to Work For and receiving honors such as Best Workplaces for Women, Best Workplaces for Flexibility, Best Workplaces for Giving Back, and Best Workplaces for Parents.
The Role: SQL Data Analyst
The SQL Data Analyst will join a team of three and be responsible for resolving integration issues for applications. While the firm plans to build out a data lake for internal and external data, the immediate focus is on troubleshooting existing application integrations. This is a year-long contract role with potential for extensions, operating remotely with a preference for EST hours (starting between 8-9 AM EST).
The analyst will respond to requests from various teams and departments seeking changes to existing integrations. Key responsibilities include analyzing requests, discovering errors and their origins, and developing solutions to modify existing SQL integrations and processing. This could involve database schema changes or handling ad hoc requests, such as validating new columns for existing application taxonomies within the SQL database to ensure correctness.
Compensation and Benefits
The compensation for this role is $45/hr to $50/hr. Exact compensation may vary based on several factors, including location, skills, experience, and education.
Employees 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, access to paid sick leave and other paid time off benefits will be provided as required by applicable law.
Diversity and Inclusion
The company is committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. As an equal opportunity/affirmative action employer, they believe 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.
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.
- Experience making database schema changes (adding/modifying columns and validating data integrity).
- Law firm background (experience with InTapp) is a plus.
Key skills/competency
- SQL
- T-SQL
- SQL Server
- Data Analysis
- Database Troubleshooting
- Schema Changes
- Data Integration
- Query Optimization
- Data Integrity
- Problem Solving
How to Get Hired at Lensa
- Research the Global Law Firm's culture: Study their mission, values, recent news, and employee testimonials on LinkedIn and Glassdoor.
- Tailor your resume for SQL Data Analyst roles: Highlight experience in SQL, T-SQL, database troubleshooting, and schema changes.
- Showcase relevant project experience: Emphasize successful data integration, query optimization, and problem-solving examples.
- Prepare for technical SQL interviews: Practice complex query writing, stored procedures, and SQL Server environment issue resolution.
- Demonstrate communication skills: Be ready to discuss how you analyze requests and present solutions to various teams effectively.
Frequently Asked Questions
Find answers to common questions about this job opportunity
Explore similar opportunities that match your background