Skip Navigation
Search Our Jobs

Search Our Jobs

Click Here to View All Available Opportunities at LPL Financial

Senior Data Analyst

Job ID: R-002607 Date posted: 04/13/2018 Primary Location SC-Fort Mill
JustificationSenior Data Analyst

We are currently looking to hire a Senior Data Analyst within the Enterprise Data and Information Services team, which is a part of LPL’s Technology organization. This position is responsible for supporting high profile projects and efforts as a senior data analyst, adhering to an enterprise-wide data governance framework to achieve the required level of consistency, quality, understanding, and protection of data.

Essential Functions:
• Perform data analysis and profiling using standard toolsets (such as Informatica IDQ or Global ID) as well as manual analysis methods to interpret trends or patterns, identify relationships, understand anomalies, assess data quality, and add context to requirements.
• Perform data mapping and gap analysis.
• Document Data Requirements Specifications based on interpretation of Business Requirements, discussions with stakeholders, and overall knowledge of the data.
• Create and maintain Data Feed Specifications which capture the layout and metadata of all incoming and outgoing data feeds.
• Maintain in-depth knowledge of data across all domains and entities.
• Provide clarity for business terminology and relationships to data structures.
• Assist with root cause analysis and remediation of production support issues related to data integrity.
• Provide support for metadata initiatives, including, but not limited to
─ Business Glossary updates
─ Data Dictionaries for physical table structures
─ Data Feed Specifications for incoming and outgoing file deliveries
─ Data Models (Conceptual, Logical and Physical)
─ Data Lineage within metadata repository
• Focus on continuous improvement of data lifecycle processes, procedures, standards, and usages.


Other Job Duties:
• Mentor and provide leadership to more junior members of the team.
• Maintain relationships with interface partners and vendors to assess or communicate impacts specific to upstream or downstream data changes.
• Create data models at the conceptual and logical level depending on experience.


Qualifications:
• 7-10 years’ experience as a Data Analyst, Systems Analyst, or Developer role in a Data Management organization.
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Strong knowledge of SQL or other query languages.
• Familiar with data modeling practices and standards across conceptual, logical, and physical levels.
• Familiar with database design and development methodologies.
• Familiar with Data Definition Language (DDL) and Data Manipulation Language (DML) SQL commands.
• Experience maintaining metadata for complex data environments and ensuring data integrity.
• Highly organized with strong communication, problem-solving, documentation, and presentation skills.
• Proven ability to be proactive, possess flexible attitude, learn new skills, and manage ambiguity.
• Experience in financial services.

Additional Requirements:
• Experienced in both waterfall and agile project methodologies.
• Ability to work independently in a fast-paced environment.

Our Company:

LPL Financial, the nation’s largest independent broker/dealer since 1996* and the fourth largest broker/dealer overall, serves as an enabling partner to more than 14,000 independent financial advisors and approximately 700 financial institutions. Since its formation decades ago, LPL has focused on one primary mission -- enabling independent financial advisors to bring objective and un-biased financial advice to millions of Americans.

Headquartered in Boston, San Diego, and Charlotte, and powered by more than 3,300 client-centric employees, LPL is financially strong and growing.

Our Culture:

If you join LPL, you will join a culture that believes in delivering a world-class client experience and looks to all employees to contribute to that goal by sharing their creativity, experience, and passion for continuous improvement. As a destination of choice, our top priorities are growth and development, social responsibility, and financial health for our employees.

We offer competitive compensation and industry leading benefits, including a wellness facility with onsite fitness classes, healthy meal choices, and a walk-in clinic. We support employee financial health through a 401k match, ESPP, and employee discounts. Work/life balance is our foundation and is supported through paid holidays, and paid time off (including time to volunteer). We foster a diverse work environment through Employee Resource Groups and diverse strategic partnerships.

Join the LPL team and help us make a difference by turning life’s aspirations into financial realities. Please login or create an account to apply to this position. Principals only. EOE

* As reported by Financial Planning magazine, June 1996-2016, based on total revenue.

About LPL Financial:

LPL Financial is a leader in the retail financial advice market and the nation’s largest independent broker/dealer*. We serve independent financial advisors and financial institutions, providing them with the technology, research, clearing and compliance services, and practice management programs they need to create and grow thriving practices. LPL enables them to provide objective guidance to millions of American families seeking wealth management, retirement planning, financial planning and asset management solutions. LPL and its affiliates have more than 3,700 employees with primary offices in Boston, Charlotte, and San Diego.

Our Culture:

If you join LPL, you will join a culture that believes in delivering a world-class client experience and looks to all employees to contribute to that goal by sharing their creativity, experience, and passion for continuous improvement. As a destination of choice, our top priorities are growth and development, social responsibility, and financial health for our employees. 

We offer competitive compensation and industry leading benefits, including a wellness facility with onsite fitness classes, healthy meal choices, and a walk-in clinic. We support employee financial health through a 401k match, ESPP, and employee discounts. Work/life balance is our foundation and is supported through paid holidays, and paid time off (including time to volunteer). We foster a diverse work environment through Employee Resource Groups and diverse strategic partnerships.  

Join the LPL team and help us make a difference by turning life’s aspirations into financial realities. Please login or create an account to apply to this position. Principals only. EOE

*As reported by Financial Planning magazine, June 1996-2017, based on total revenue.

Sign Up for Email Alerts!

Areas of InterestStay up-to-date about the latest opportunities at LPL Financial! Choose at least one category and/or location from the auto-suggestions and click 'Add' to subscribe.

  • All, Fort Mill, South Carolina, United StatesRemove
  • Compliance, Fort Mill, South Carolina, United StatesRemove
  • Information Technology, Fort Mill, South Carolina, United StatesRemove