SQL Data Manager

Job Description

At K&L Gates, we are looking for smart, imaginative and hard-working people with diverse backgrounds, experiences and ideas to join us.  Perhaps our search for talented visionaries and your search for important and impactful work lead to the same place.

We are seeking a SQL Data Manager to join the firm.  The SQL Data Manager implements, administers, and manages SQL Server databases supporting the Financial Reporting and Planning team’s operations. This role ensures data accuracy, accessibility, performance, governance, and enables advanced analytics and reporting. Collaborating closely with the Financial Reporting and Planning team, the SQL Data Manager oversees technical data infrastructure and supports data-driven initiatives. Responsibilities include extracting, analyzing, and interpreting data from diverse sources using SQL to deliver actionable insights. These insights play a vital role in informing strategic financial decisions and enhancing the Firm's overall reporting capabilities.

KEY RELATIONSHIPS
Finance and Information Technology

ESSENTIAL DUTIES
• Planning, coordinating, and administering all functions supporting the Financial Reporting and Planning team’s database environments, including definitions, structures, documentation, and data standards.
• Managing software installations, upgrades, user security, and performance optimization within the database environments for the Financial Reporting and Planning team.
• Crafting complex SQL queries to extract, manipulate, and analyze data from relational databases. Creating reports to present summarized data insights.
• Ensuring data integrity and consistency across platforms. Cleaning, validating, and transforming large datasets for analysis and reporting purposes. Monitoring data performance and troubleshooting issues related to extraction and consistency.
• Developing data models to organize, structure, and define relationships within datasets for streamlined analysis and efficient database management.
• Collaborating with cross-functional teams to establish metrics, KPIs, and foundational business principles.
• Optimizing SQL queries and suggesting improvements to enhance performance and scalability.
• Documenting processes, data sources, structures, definitions, and assumptions ensure transparency and maintains consistency.
• Collaborating with the Finance team to understand business needs and translating those needs into specific data requirements.
• Performing additional responsibilities as directed.


EXPERIENCE SKILLS REQUIRED
• Demonstrate expertise in understanding and managing business operations, strategies, and financial principles to achieve organizational goals effectively.
• Specify programming languages (e.g., Python, Java, C++).
• Understand ETL tools and processes.
• Build and manage systems for storing, organizing, and analyzing large volumes of structured and unstructured data efficiently.
• Able to work in teams and collaborate across functional departments
• Demonstrate a focus on data precision and accuracy
• Manage various priorities effectively.
• Facilitate clear and concise communication.
• Demonstrate abilities to solve problems effectively.
• Demonstrate excellent ability to analyze complex data effectively.
• Possess experience with Oracle, Essbase, SSMS and SSRS
• Demonstrate over five years of experience managing SQL with a focus on BI, supporting data warehousing and business intelligence solutions.
 

Compensation salary $94,000 - $141,000

The compensation salary for this position will be determined during the interview process and will vary based on multiple factors, including but not limited to prior experience, relevant expertise, current business needs, and market factors.

ABOUT THE FIRM

K&L Gates is a fully integrated global law firm with lawyers located across five continents in more than 40 offices. We have experienced dramatic growth in the past decade and now rank among the largest U.S. based law firms in the world.  We take pride in constantly striving for innovation, imagination and an entrepreneurial spirit. We come up with big ideas and then roll up our sleeves to get the job done, guiding our clients through their most complex issues in a variety of industry sectors and across multiple regions of the world. 

The industry recognition the firm has garnered emanates from the foundation of a global community aligned on behalf of our clients. The people at K&L Gates are committed to working together to create a legacy for each other, the firm, our clients, and the communities in which we serve. We thrive in an inclusive and socially conscious environment that embraces diversity and takes a holistic approach to the career evolution of all our professionals.

For more information or to view other job opportunities, please click here to go back to our careers page.

Notice: We participate in E-Verify in certain Firm locations for purposes of verifying employment eligibility.

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

BENEFITS

K&L Gates offers our personnel a comprehensive suite of benefits to help meet your needs now and in the future. Depending on your eligibility, options for full-time personnel include:

EQUAL EMPLOYMENT OPPORTUNITY

The Firm is an equal opportunity employer. It is the policy of the Firm that employment decisions shall be based on merit, qualifications and competence. Employment practices will not be influenced or affected by virtue of a person’s race (including traits associated with race, including hair texture and protective hairstyles such as afros, braids, locks, and twists), religion, creed, color, national origin, ancestry, citizenship, physical disability, mental disability, medical condition, genetic information, marital status, sex, pregnancy, childbirth, breastfeeding, gender, parental status, gender identity, gender expression, sexual orientation, age, familial status, domestic violence victim status, military and veteran status, or any other characteristic protected by applicable federal, state, or local law. This policy governs all aspects of employment including, without limitation, recruiting, hiring, compensation, benefits, promotion, assignment, and dismissal. In addition, it is the Firm’s policy to provide an environment that is free of prohibited harassment of any kind including, without limitation, that which is based on sex, race, age, disability, ethnic background, or any other category protected by law (including the categories listed above). The Firm complies with federal and state disability laws and makes reasonable accommodations for applicants and employees with disabilities. If you require reasonable accommodation in completing this application, interviewing, or otherwise participating in the employee selection process, please contact askHR@klgates.com.