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
Job Summary: SQL Data Analyst
Lensa is promoting a unique opportunity for a skilled SQL Data Analyst to join the data team of a global law firm. This role is a year-long contract with potential for extension, operating remotely with a preference for EST hours (starting between 8-9 AM EST). The firm, renowned for its expertise in corporate law, litigation, and intellectual property, boasts a strong reputation for its workplace culture, earning accolades like Fortune’s Best Companies to Work For.
As a SQL Data Analyst, you will be an integral part of a three-person data team, focusing on resolving integration issues for critical applications. Before the development of a comprehensive data lake, your primary responsibility will involve troubleshooting application integrations when issues arise. You will process requests from various teams, analyze them for errors, pinpoint the source of these errors, and devise solutions to modify existing SQL integrations and processing. This includes managing database schema changes and fulfilling ad hoc requests, such as validating new columns for existing application taxonomies to ensure data integrity.
Key Responsibilities
- Analyze requests from various teams for changes to existing application integrations.
- Diagnose and pinpoint errors occurring within SQL integrations and processing.
- Develop and implement solutions to modify existing integrations.
- Manage database schema changes, including adding or modifying columns.
- Validate data integrity for new and existing columns within SQL databases.
- Troubleshoot and resolve complex T-SQL queries and stored procedures.
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 experience in diagnosing and resolving issues within SQL Server environments.
- Experience with database schema changes, including adding/modifying columns and validating data integrity.
- Familiarity with a law firm background and experience with InTapp is a plus.
Compensation and Benefits
The compensation for this role ranges from $45/hr to $50/hr, with exact compensation potentially varying based on location, skills, experience, and education. Employees will receive a comprehensive benefits package from day one, including medical, dental, and vision insurance options. Eligibility for the 401(k) retirement plan begins after 90 days of employment. Paid sick leave and other paid time off benefits are also provided as required by applicable law.
Key skills/competency
- SQL
- Data Analysis
- T-SQL
- Query Optimization
- Troubleshooting
- Database Schema
- Data Integrity
- SQL Server
- Integration Management
- InTapp (nice to have)
How to Get Hired at Lensa
- Research Insight Global's reputation: Study how Insight Global partners with top companies and prepares candidates.
- Tailor your SQL Data Analyst resume: Highlight extensive experience with T-SQL, schema changes, and troubleshooting SQL environments.
- Showcase problem-solving skills: Emphasize past successes in diagnosing and resolving complex data integration issues.
- Prepare for technical interviews: Practice SQL query optimization, stored procedures, and data integrity validation questions.
- Demonstrate adaptability for remote work: Discuss your experience with remote collaboration, especially if working with EST teams.
Frequently Asked Questions
Find answers to common questions about this job opportunity
Explore similar opportunities that match your background