Skip Navigation
Search Our Jobs

Search Our Jobs

Click Here to View All Available Opportunities at LPL Financial

Sr Engineer - Physical Data Modeller

Job ID: R-002610 Date posted: 04/17/2018 Primary Location SC-Fort Mill

Sr Engineer - Physical Data Modeler

We are currently looking to hire a Senior Engineer – Physical Data Modeler 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 modeler, adhering to an enterprise-wide data governance framework to achieve the required level of consistency, quality, understanding, and protection of data.

Essential Functions:

  • Create, update, and optimize logical and physical data models along with corresponding metadata.
  • Define and leverage data modeling and design standards, tools, and best practices.
  • Ensure naming convention standards are followed, data proliferation is minimized, and data governance processes are followed.
  • Perform reverse engineering of data models from databases and SQL scripts.
  • Design and implement data technology solutions in the areas of master data, metadata, and reference data.
  • Participate in the evaluation of new tools and techniques to improve data management for the enterprise.
  • Partner with business analysts, data analysts, and other technology resources to interpret business and data requirements and translate into data models.
  • Collaborate with data architects, technical leads, developers, and DBAs to design and implement data solutions.
  • Maintain in-depth knowledge of data across all domains and entities.
  • Provide support for metadata initiatives, including, but not limited to
    • Business Glossary updates
    • Data Dictionaries for physical table structures
    • Data Models and Data Flow Diagrams
    • Data Lineage within metadata repository

Other Job Duties:

  • Mentor and provide leadership to more junior members of the team.

Qualifications:

•     7-10 years’ experience in applying data management principles and industry standards to design, build, and maintain complex data model assets in Transactional/ Operational, ODS, Data Warehouse and Data Mart applications.

  • Bachelor’s degree in Computer Engineering, Computer Systems, Computer Science, Software Engineering, or related field.
  • Expertise in data modeling principles, including conceptual, logical and physical data models.
  • Experience using data analysis and modeling tools, such as Power Designer, ERWin, and ER/Studio.
  • Experience with RDBMS platforms, including SQL Server and Oracle.
  • Familiar with Data Definition Language (DDL) and Data Manipulation Language (DML) SQL commands.
  • Experience maintaining metadata for complex data environments and ensuring data integrity.
  • Demonstrated ability to work as part of a high-performing team and influence others within the technology organization.
  • Flexible and able to successfully navigate ambiguity and succeed in a rapidly-changing, fast-paced, deadline-driven environment with multiple priorities.
  • 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:

  • Experience with both waterfall and agile project methodologies.
  • Experience with Big Data technologies – such as Hadoop, Python, and Spark – are a plus but not required.

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.

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