LPL Financial provides investment solutions and tools for independent financial advisors. They are seeking an Analyst in Data Infrastructure to develop analytic solutions, mentor peers, and collaborate with business units to enhance data-driven decision-making.
Develop & Deploy complex and continuous analytic solutions using the Analytic Development Lifecycle (ADLC). Typically, descriptive and diagnostic analytics – with a future focus on predictive analytics.
Business Understanding – Work with Business Units to understand and interpret the request into a User Story and Acceptance Criteria.
Data Understanding – Identify appropriate data sources, perform data quality validations and highlight known limitations and assumptions.
Data Preparation – Access, mine, join and extract data from one or multiple data sources in LPL’s data ecosystem. Highlight known limitations and assumptions.
Data Output Analysis – Leverage data visualization tools to assist in telling a story.
Data Extract-Transfer-Load – Leverage the Data Build Tool (DBT) to extract, transform, and load data into the Snowflake data warehouse.
Evaluation of Output – Based on risk, document data sources, filter/join selections, perform Test Case Scenarios, receive first level analytic manager approval, and obtain Business Unit approval.
Qualification
Required
Bachelor’s degree in Data Science, Computer Science, Economics, Finance, Engineering, Statistics, Mathematics, Physics, Actuarial Sciences, or other highly quantitative discipline.
2+ years of experience or Master’s Degree plus 1+ years of experience
2+ years of experience developing analytic solutions
Technical experience in at least 1 visualization tool (Tableau, PowerBI, etc.)
Technical experience in at least 1 data analytic language (SQL, SAS, etc.)
Intermediate experience in at least 1 scripting language (Python, SAS, Alteryx, etc.)
Proficient in at least 1 data Extract-Transform-Load (ETL) language (DBT Core, DBT Cloud etc.)
Knowledge or ability following the Analytic Development Lifecycle (ADLC)
Knowledge or ability to follow Agile 'sprints' project management methodology
Positive attitude with an appetite for learning, tenacious in overcoming obstacles as well as for seeking, embracing, and applying feedback
Knowledge or developing ability to identify problems, locate root cause, escalating with solutions in hand
Knowledge or ability collaborating, consulting and building relationships with solution requestors (Business Units) and ultimately creating results for our advisors and their clients.
Knowledge or ability to identify tactical and strategic solutions evidencing the ability to value progress over perfection and considering the big picture
Preferred
Benefits
401K matching
Health benefits
Employee stock options
Paid time off
Volunteer time off
LPL Financial provides investment solutions and tools for independent financial advisors.
