AVP Data Engineer

Job Summary:
The AVP Data engineer will support all aspects of data engineering activities, including data design, development, testing, debugging, documentation, deployment, and production support. The individual will apply software engineering methods and techniques to perform code reviews, unit testing, integration testing, and documentation. They will also contribute to technical roadmap planning and work closely with the Lead Software Engineers to ensure timely delivery of new features and maintenance releases.  

Responsibilities: 
• Lead the development of end-to-end data pipelines including ETL/ELT, data quality, data governance, metadata management, data modeling, and master data management.
• Applies data engineering skills and knowledge of industry standard practices to develop scalable, reliable, fault-tolerant systems and processes that meet business requirements.  
• Collaborates with project managers, architects, developers, testers, operations staff, product owners, and end users to analyze business requirements, identify problems, propose solutions, prioritize features, estimate costs and time, and communicate risks and status.  
• Maintains awareness of emerging technologies and trends; demonstrates flexibility and willingness to learn new technologies as needed.  
• Applies understanding of concepts and procedures within own area and basic knowledge of other areas to resolve issues that have impact beyond immediate area.  
• Performs code reviews, unit testing, integration testing, and documentation.  
• Collaborates with development team members and customers to troubleshoot and resolve application issues in production environments.  
• Utilizes knowledge of system architecture and data models to maintain existing applications and work on new projects.  
• Identifies opportunities for operational improvements and efficiency gains.  

Requirements: 
• Bachelor’s degree in Computer Science or related field; Master’s degree preferred 
• Experience working in Agile/Scrum environment 
• Ability to understand complex technical specifications and translate into functional code 

Technical Competencies:

• Strong understanding of data modeling concepts of different normalization methods, and hands-on working experience in OLTP/OLAP environments

• Proficiency in one or more programming languages (e.g., Python .NET) and API management

• Hands-on experience working with databases and SQL (e.g., Oracle DBMS, PostgreSQL, DynamoDB,MySQL etc).

• Deep understanding of modern software/data management practices, including Domain-Based Design, DevSecOps, Continuous Delivery, and Agile methodologies, with an emphasis on Lean principles

• Proficiency in architecting Event-Driven solutions encompassing event brokers, data streams, and serverless functions to sophisticated event processing and analytics using container and orchestration technologies, including but not limited to AWS Kinesis, Kafka, Glue, and AWS Lambda.

Preferences:

• Financial industry experience, particularly in wealth management, securities, and trading.

• AWS cloud architecture experience. AWS Solution Architect certification is a plus.

 

Pay Range:

$140,475-$234,125/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) was founded on the principle that the firm should work for advisors and institutions, and not the other way around. Today, LPL is a leader in the markets we serve, serving more than 23,000 financial advisors, including advisors at approximately 1,000 institutions and at approximately 580 registered investment advisor ("RIA") firms nationwide. We are steadfast in our commitment to the advisor-mediated model and the belief that Americans deserve access to personalized guidance from a financial professional.

At LPL, independence means that advisors and institution leaders have the freedom they deserve to choose the business model, services, and technology resources that allow them to run a thriving business. They have the flexibility to do business their way. And they have the freedom to manage their client relationships, because they know their clients