LPL Financial · 15 minutes ago
AWS Data Engineer II
LPL Financial is a leading firm in the financial advisor-mediated marketplace, empowering professionals to help clients achieve their financial goals. The AWS Data Engineer II will design, develop, and maintain data pipelines and integration solutions within the AWS cloud environment, collaborating with various stakeholders to ensure reliable data ingestion.
FinanceFinancial Services
Responsibilities
Develop, maintain, and enhance data ingestion pipelines within the Enterprise Data Integration Framework (EDIF)
Build and update AWS Glue ETL jobs in Python (PySpark) for validation, transformation, enrichment, and microbatch processing
Collaborate across engineering, QA, Cloud Operations, and vendor partners to implement new ingestion workflows
Contribute to architectural design, documentation, and best practices that improve EDIF scalability and resilience
Monitor, troubleshoot, and optimize ingestion workflow performance across AWS services (S3, Lambda, Glue, DynamoDB, PostgreSQL, Step Functions, CloudWatch, EventBridge, Athena)
Assist with the onboarding of new vendor feeds, schemas, and operational schedules into EDIF
Participate in platform release management, change control, and nightly batch support activities
Maintain ingestion observability through CloudWatch dashboards and EDIF event-monitoring tools
Provide technical support to ensure successful nightly data ingestion and data quality compliance
Qualification
Required
Bachelor's degree in Computer Science, Information Technology, Engineering, or related field
3+ years of hands-on experience in data engineering or ETL development
Experience with core AWS data and compute services, including S3, Lambda, Glue, DynamoDB, PostgreSQL, Step Functions, CloudWatch, IAM, Athena
Proficiency with Python and/or PySpark for data transformation
Experience working with relational databases (PostgreSQL, SQL Server, Oracle, etc.)
Understanding of data modeling, schema evolution, and data validation principles
Experience with Git-based version control and CI/CD workflows
Strong ability to analyze data structures and implement efficient transformations
Strong analytical, debugging, and problem-solving skills
Excellent communication and teamwork skills
Ability to work independently in a fast-paced environment
Experience with both agile and waterfall methodologies
Ability to meet tight deadlines while delivering high-quality results
Continuous improvement mindset and strong ownership of platform reliability
Ability to learn quickly and adapt to evolving ingestion requirements
Preferred
Experience with event-driven or serverless architectures
Hands-on familiarity with S3 → Lambda → Glue ingestion pipelines
Exposure to secure data-processing patterns (tokenization, encryption, PII governance)
Experience with mastering tools or vendor dataset onboarding
Experience in financial services or regulated data environments
Benefits
401K matching
Health benefits
Employee stock options
Paid time off
Volunteer time off
Company
LPL Financial
LPL Financial provides investment solutions and tools for independent financial advisors.
H1B Sponsorship
LPL Financial has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (106)
2024 (105)
2023 (122)
2022 (127)
2021 (65)
2020 (44)
Funding
Current Stage
Public CompanyTotal Funding
$2.5B2025-03-31Post Ipo Equity· $1.5B
2024-06-03Post Ipo Debt· $1B
2010-11-18IPO
Recent News
IndiaTimes
2026-02-05
2026-01-23
Company data provided by crunchbase