Engineer II, Data Warehouse

Overview

Engineer II in Data Warehousing & Automation Engineering, partnering with a team of data professionals to deliver data warehousing initiatives across LPL Financial.

What you'll do

• Develop solutions to deliver on the data warehousing strategy, aligned with business objectives and data-driven decision-making.
• Oversee the integration of data products in Snowflake and dbt, ensuring seamless data flow, quality and accessibility.
• Design and develop data replication and transformation pipelines leveraging solutions such as HVR.
• Configure and manage HVR instances for optimal performance and scalability.
• Develop, automate and implement data quality checks and monitoring procedures.
• Manage and optimize Snowflake data warehouse, data mart and application-based solutions for high performance, scalability and reliability.
• Implement cost management strategies to optimize data warehousing expenses while maintaining high service levels.
• Ensure data security, compliance and governance are integrated into all data warehousing processes.
• Establish and maintain robust metadata management practices.
• Work closely with cross-functional teams, including IT, marketing and customer service, to support business goals.
• Emphasize rapid prototyping and continuous process improvement.
• Stay up-to-date on industry and technology advancements and bring insights to the team.

What you'll need

• 7+ years of experience in both on-prem and cloud-based data warehousing and data marts.
• At least 4 years focused on leadership of warehousing team(s).
• Bachelor's degree in Data Science, Computer Science or related field.
• Demonstrable hands-on experience with Snowflake and AWS S3 at minimum.
• Data governance and cataloging experience.
• Programming in Python and/or SQL (production code, reusable libraries, tests).
• Pipeline development and orchestration with HVR, Airflow, Step Functions, dbt and others.
• DevOps for data: Terraform/CloudFormation, CI/CD, monitoring and runbook creation.
• Strong understanding of data modeling, data quality, and secure data onboarding/governance.
• Experience with both batch and real-time data processing.
• Excellent communication and stakeholder management skills.

Nice to have

• Master's degree.
• Snowflake developer certifications.
• AI engineering experience: Snowflake Cortex, AWS Bedrock, etc.
• Demonstrated use of AI/ML tools to augment engineering productivity (code generation, LLMs for docs/tests, query optimization).

Details

• Location: Hyderabad.