SQL Data Analyst (REMOTE EST)
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.
Job Description
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 responsible for resolving integration issues for applications. They eventually will build out a data lake to encompass both internal and external data but before then all the application integrations need to be troubleshot when where are issues. The role is a year contract with potential extensions and is remote but prefer to work EST hours starting between 8-9AM EST. The 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 analyst will join a team of three. The role will at requests from various teams and departments that are trying to make changes to existing integrations and they must analyze the request, discover if there are any errors and where the error is occurring, and come up with solutions to change existing integrations /processing within SQL. This may be database schema changes or ad hoc requests. For example, the SQL database may have existing taxonomy for apps and time to time they may want to add additional columns and this resource will need to validate columns to make sure they are correct.
Compensation
$45/hr to $50/hr.
Exact compensation may vary based on several factors, including location, skills, experience, and education.
Employees in this role will enjoy a comprehensive benefits package starting on day one of employment, including options for medical, dental, and vision insurance. Eligibility to enroll in the 401(k) retirement plan begins after 90 days of employment. Additionally, employees in this role will have access to paid sick leave and other paid time off benefits as required under the applicable law of the worksite location.
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 [email protected] 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
• experience 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)
If you have questions about this posting, please contact [email protected]
Apply tot his job
Apply To this Job
Job Description
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 responsible for resolving integration issues for applications. They eventually will build out a data lake to encompass both internal and external data but before then all the application integrations need to be troubleshot when where are issues. The role is a year contract with potential extensions and is remote but prefer to work EST hours starting between 8-9AM EST. The 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 analyst will join a team of three. The role will at requests from various teams and departments that are trying to make changes to existing integrations and they must analyze the request, discover if there are any errors and where the error is occurring, and come up with solutions to change existing integrations /processing within SQL. This may be database schema changes or ad hoc requests. For example, the SQL database may have existing taxonomy for apps and time to time they may want to add additional columns and this resource will need to validate columns to make sure they are correct.
Compensation
$45/hr to $50/hr.
Exact compensation may vary based on several factors, including location, skills, experience, and education.
Employees in this role will enjoy a comprehensive benefits package starting on day one of employment, including options for medical, dental, and vision insurance. Eligibility to enroll in the 401(k) retirement plan begins after 90 days of employment. Additionally, employees in this role will have access to paid sick leave and other paid time off benefits as required under the applicable law of the worksite location.
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 [email protected] 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
• experience 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)
If you have questions about this posting, please contact [email protected]
Apply tot his job
Apply To this Job