Senior Analyst, Data Infrastructure

2 weeks ago Be among the first 25 applicants

Are you a team player? Are you curious to learn? Are you interested in working on meaningful projects? Do you want to work with cutting-edge technology? Are you interested in being part of a team that is transforming and doing things differently? If so, LPL Financial is the place for you!

Job Overview:

The Sr. Analyst, Data Infrastructure will be responsible for the Data Infrastructure of the Reporting, Analytics and Insights group within LPL's Customer Care organization. This role involves deploying internal ETLs and Data infrastructure, as well as defining requirements for enterprise data warehouse solutions focused on Customer Care.

Responsibilities:

• Gather data requirements and translate them into specifications for data warehouse solutions.
• Analyze technical system and business model designs to ensure they meet business needs.
• Research information sources for limitations in reliability or usability.
• Support data quality, integrity, and standardization initiatives.
• Participate in proof of concept activities by assembling large data sets and creating data pipelines.
• Identify and implement process improvements, automate manual processes, optimize data delivery, and enhance ETL processes.
• Lead the technical design and implementation of dashboards and reporting capabilities.
• Collaborate with IT on Customer Care projects and monitor project deliverables.
• Perform user acceptance testing.
• Evaluate and influence ETL and database tool selection and deployment.

What are we looking for?

We seek strong collaborators who can deliver a world-class client experience. Ideal candidates thrive in a fast-paced, client-focused, team-oriented environment, and are capable of fostering creativity and continuous improvement.

Requirements:

• 2+ years experience with SQL, relational databases, and familiarity with various databases.
• 2+ years experience with ETL/Visualization tools such as Informatica, Alteryx, and Tableau.
• 2+ years experience with data warehouse architecture and design.
• Experience in root cause analysis on data and processes.
• Proven ability to manage data warehouse projects from start to finish.
• Excellent multitasking and task management skills.
• Ability to meet multiple deadlines.
• Analytical mindset and attention to detail.
• Exceptional interpersonal and communication skills.

Core Competencies:

• Extensive SQL experience.
• Data Warehouse Architecture and Design.
• Experience with ETL/Visualization tools: Informatica, Alteryx, Tableau.

Preferences:

• MS SQL Server experience.
• Snowflake experience.
• Additional experience with Tableau, Alteryx, Liquibase, Octopus Deploy.

Pay Range:

$83,400-$139,000/year. Actual salary depends on skills, experience, education, location, and internal factors. LPL offers a competitive total rewards package including 401K matching, health benefits, stock options, paid time off, and more. Discuss with your recruiter for details.

Company Overview:

LPL Financial Holdings Inc. (Nasdaq: LPLA) is dedicated to serving advisors and institutions, supporting over 23,000 financial advisors nationwide. We are committed to an advisor-mediated model, providing personalized guidance and independence to our clients.

Join LPL Financial: Where Your Potential Meets Opportunity

We believe everyone deserves objective financial guidance. Our platform combines cutting-edge technology, brokerage, and investment services.

Why LPL?

• Innovative Environment: Supportive leadership and growth opportunities.
• Limitless Career Potential: No limits, only potential.
• Unified Mission: Focused on supporting advisors and their clients.
• Impactful Work: Make a real difference.
• Commitment to Equality: Embracing diversity and inclusion.
• Community Focus: Engaging with and supporting our communities.
• Benefits and Total Rewards: Competitive packages supporting your life at work and home.

Apply via login or account creation. Principals only. EOE.

Information on Interviews:

LPL communicates only from an @lplfinancial.com email address and will never conduct online or chatroom interviews or request payment or banking information. Contact our HR Solutions Center at (855) 575-6947 for questions.

Additional Details:

• Seniority level: Mid-Senior level
• Employment type: Full-time
• Job function: Information Technology