Associate Principal - Data Engineering
Role details
Job location
Tech stack
Job description
Design develop and maintain scalable highperformance database solutions
Lead initiatives in data modeling database design and performance tuning
Develop and optimize complex SQL TSQL queries stored procedures functions and triggers
Implement and manage RoleBased Access Control RBAC and ensure database security compliance
Analyze and improve database internals indexing strategies and execution plans
Build and manage endtoend data pipelines using Azure Data Factory
Design and implement modern data architectures including data warehouses and data lakes using Azure Synapse and Microsoft Fabric
Collaborate with crossfunctional teams to deliver scalable data engineering and analytics solutions
Develop and maintain Pythonbased data services APIs and microservices
Work with frameworks such as DBT FastAPI or Django to enable data transformation and service exposure
Integrate data platforms with LLMbased systems and agentic workflows for intelligent automation
Contribute to the design and implementation of agentic AI solutions including orchestration tool usage and API interaction patterns
Requirements
Do you have experience in System tuning?, Database Engineering Expertise
810 years of experience as a Database Engineer Data Engineer
Strong expertise in
Data modeling and database design
Performance tuning and optimization
Advanced SQL and TSQL
Proven experience writing
Complex Stored Procedures
User Defined Functions UDFs
Triggers
Strong knowledge of
Database internals
Indexing and execution plans
Security models and RBAC
Azure Data Engineering
5 years of experience with Azure data platforms including
Azure Data Factory ADF building complex pipelines and orchestrations
Azure Synapse Analytics Microsoft Fabric
Data lakes and data warehouse implementations
Good understanding of
Azure ecosystem and services
Networking fundamentals in Azure VNets private endpoints etc
Programming Frameworks
Strong handson experience in Python including
API integrations and data processing
Building microservices architectures
Familiarity with
DBT Data Build Tool
Workflow orchestration tools
Frameworks such as FastAPI or Django
AI LLM Agentic Systems Preferred
Experience working with
LLMbased interfaces
AIpowered automation workflows
Handson exposure to
Claude or similar agentic coding frameworks
Designing and building agentbased solutions
Prompt engineering and tool orchestration
Strong understanding of
APIbased LLM integrations
Autonomous or semiautonomous workflow design
Preferred Qualifications
Experience implementing AIdriven data solutions
Exposure to MLOps or AI lifecycle management
Familiarity with distributed systems and eventdriven architectures
Strong problemsolving and analytical skills
Soft Skills
Excellent communication and stakeholder management skills
Ability to work in a fastpaced collaborative environment
Strong attention to detail and performance optimization mindset Skills
Mandatory Skills : Azure Data Factory, Azure Synapse Analytics Other details
Benefits & conditions
(part of Larsen and Toubro (L&T)) 3.73.7 out of 5 stars Dallas, TX $120,000 - $140,000 a year, Pulled from the full job description
- Paid parental leave
- Parental leave
- Health insurance
- 401(k) matching
- Vision insurance
- Dental insurance
- Life insurance, Variable Compensation: This position includes a bonus or variable payout component based on individual and organizational performance. Actual compensation within the range will be dependent upon the individual's skills, experience, performance and internal equity.
Benefits/perks listed below may vary depending on the nature of your employment with LTIMindtree ("LTIM"):
Benefits and Perks:
- Comprehensive Medical Plan Covering Medical, Dental, Vision
- Short Term and Long-Term Disability Coverage
- 401(k) Plan with Company match
- Life Insurance
- Vacation Time, Sick Leave, Paid Holidays
- Paid Paternity and Maternity Leave
The range displayed on each job posting reflects the minimum and maximum salary target for the position across all US locations. Within the range, individual pay is determined by work location and job level and additional factors including job-related skills, experience, and relevant education or training. Depending on the position offered, other forms of compensation may be provided as part of overall compensation like an annual performance-based bonus, sales incentive pay and other forms of bonus or variable compensation., Compensation range: $120,000.00 to $140,000.00 per year