Senior Data Engineer

What if you could build a career where ambition meets innovation? At LPL Financial, we empower professionals to shape their success while helping clients pursue their financial goals with confidence. What if you could have access to cutting-edge resources, a collaborative environment, and the freedom to make an impact? If you're ready to take the next step, discover what’s possible with LPL Financial.

Job Overview:

As a Senior Data Engineer, you will engage with various development and support teams to ensure the delivery of stable, high-quality solutions. We are seeking a professional who is enthusiastic about maintaining and enhancing robust data systems, ensuring reliability, and delivering an exceptional customer experience and who enjoys working with SQL technologies and cloud technologies (e.g., AWS) through self-study and company-provided training. We value strong collaborators who are passionate about operational excellence and continuous improvement. Ideal candidates thrive in fast-paced environments, are client-focused, team-oriented, and bring a mindset geared toward stability, scalability, and long-term system health and be comfortable working independently to support and improve existing systems, while also collaborating with team members to uphold best practices.

Responsibilities:

• Understand and interpret business requirements to support data operations

• Maintain and optimize complex T-SQL queries for performance and reliability

• Support report development using SSRS, OBIEE, or Tableau

• Develop and maintain ETL workflows using Informatica or SSIS

• Create and manage ad-hoc queries, stored procedures, and SQL Agent Jobs

• Perform performance tuning and query optimization using native SQL Server tools

• Monitor and support data platform operations, on Prem and on AWS, ensuring system health and uptime

• Leverage AWS-native tools (e.g., CloudWatch, S3, RDS, Lambda) to ensure platform stability and performance

What are we looking for?

We want strong collaborators who can deliver a world-class client experience. We are looking for people who thrive in a fast-paced environment, are client-focused, team oriented, and are able to execute in a way that encourages creativity and continuous improvement.

Requirements:

• 3+ years of experience in Information Technology

• 3+ years of experience in Data Warehouse Applications using SQL Server and Oracle

• Experience supporting data platforms in AWS environments is highly desirable

Core Competencies:

• Ability to work collaboratively across teams to support and improve data platforms

• Strong interpersonal skills to resolve issues professionally and build consensus

• Ability to multitask, adapt to evolving priorities, and learn quickly

• Execute tasks within established guidelines and procedures

• Strong analytical and problem-solving skills with a focus on operational reliability

Preferences:

• Experience with ETL tools, Informatica (including IDMC), and data modeling is a plus

• Familiarity with SSIS, SSMS, and SSRS

• Familiarity with AWS services such as EC2, RDS, S3, Lambda, and CloudWatch is a plus

#LI-PA

 

Pay Range:

$93,788-$156,313/year

 

Actual base salary varies based on factors, including but not limited to, relevant skill, prior experience, education, base salary of internal peers, demonstrated performance, and geographic location. Additionally, LPL Total Rewards package is highly competitive, designed to support your success at work, at home, and at play – such as 401K matching, health benefits, employee stock options, paid time off, volunteer time off, and more. Your recruiter will be happy to discuss all that LPL has to offer!

 

Company Overview:

LPL Financial Holdings Inc. (Nasdaq: LPLA) is among the fastest growing wealth management firms in the U.S. As a leader in the financial advisor-mediated marketplace. LPL supports over 29,000 financial advisors and the wealth-management practices of 1,100 financial institution, servicing and custodying approximately $1.9 trillion in brokerage and advisory assets on behalf of approximately 7 million Americans. The firm provides a wide range of advisor affiliation models, investment solutions, fintech tools and practice management services, ensuring that advisors and institutions have the flexibility to choose the business model, services, and technology resources they need to run thriving businesses