Engineer 1 - Data Warehouse

LPL Financials; Hyderabad; Hybrid; INR 800,000 - 1,200,000; Full time

Job summary

LPL Financials, Hyderabad, India, seeks an Engineer I in Data Warehousing & Automation Engineering to join a data-focused team delivering warehousing initiatives across the organization. You will build data solutions as strategic assets to enhance decision-making, drive innovation, and ensure data quality, governance, and security across platforms including Snowflake, dbt, and AWS.

The role emphasizes rapid prototyping and continuous improvement, with strong collaboration across stakeholders to

Qualifications

• 3+ years of experience in on-prem and cloud data warehousing with 2+ years in team leadership.
• Hands-on with Snowflake, AWS S3, data governance/cataloging, Python/SQL production code.

Responsibilities

• Engineer solutions to deliver on LPLs data warehousing strategy.
• Develop data products in Snowflake and dbt ensuring data quality and accessibility.
• Develop data replication and transformation pipelines using HVR; configure HVR instances for performance.
• Develop, automate and implement data quality checks and monitoring procedures.
• Manage and optimize Snowflake data warehouse and data marts for performance and reliability.
• Ensure data security, governance, and regulatory compliance across processes.
• Emphasize rapid prototyping and continuous improvement to enhance capabilities.
• Stay up-to-date with industry advancements and bring insights to the team.

Skills

Python

SQL

Leadership

Communication

Data governance

Data modeling

Education

Bachelor’s degree in Data Science/Computer Science

Master’s degree preferred

Tools

Snowflake

AWS S3

dbt

Airflow

HVR

Terraform

CloudFormation

CI/CD

GitHub Actions

Jenkins

Dynatrace

Datadog

Prometheus

Unity Catalog

Collibra

Atlan

Job description

As an Engineer I in Data Warehousing & Automation Engineering, you will partner with a team of data professionals to deliver data warehousing initiatives across the LPL Financial. This role is pivotal in building our data solutions as strategic assets enhance decision-making, drive innovation, and ensuring data quality and governance.

Responsibilities

• Engineer solutions to deliver on LPLs data warehousing strategy
• Develop data products in Snowflake and dbt, ensuring seamless data flow, quality and accessibility
• 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 to ensure high performance, scalability, and reliability
• Ensure data security, compliance, and governance are integrated into all data warehousing processes to meet regulatory and organizational standards
• Emphasize rapid prototyping and continuous process improvement to enhance data warehousing capabilities and drive innovation
• Stay up-to-date on the latest advancements in industry and technology solutions, bringing insights to the team for continuous development of our stack, solutions and ways of working

What are we looking for?

We’re looking for strong collaborators who deliver exceptional client experiences and thrive in fast-paced, team-oriented environments. Our ideal candidates pursue greatness, act with integrity, and are driven to help our clients succeed. We value those who embrace creativity, continuous improvement, and contribute to a culture where we win together and create and share joy in our work.

Requirements

• 3+ years of experience in both on-prem and cloud-based data warehousing and data marts, with at least 2 years focused on leadership of warehousing team(s)
• Bachelor’s degree in Data Science, Computer science or related field; Master’s degree preferred
• Demonstrable hands-on experience with:
  • Snowflake, AWS S3 at minimum
  • Data governance and cataloging
  • Programming: Python and/or SQL (production code, reusable libraries, tests)
  • Pipeline development and orchestration: 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

Core Competencies

• Excellent communication and stakeholder management skills

Preferences

• Snowflake developer certifications
• AI Engineering: Snowflake Coretex, AWS Bedrock, etc.
• Demonstrated use of AI/ML tools to augment engineering productivity (prompting for code generation, LLMs for docs/tests, query optimization)

Skills & Tools

• AWS (S3, Glue, Lake Formation, IAM), Snowflake
• SQL, Python
• HVR, dbt, Airflow, Step Functions
• Terraform/CloudFormation, CI/CD (GitHub Actions, Jenkins)
• Observability (Dynatrace preferred, Datadog, Prometheus)
• Data governance & security (Unity Catalog, Collibra, Atlan)