What are the responsibilities and job description for the Senior Database/Azure Data Engineer position at THE TILTED CIRCLE LLC?
Position: Senior Database/Azure Data Engineer – LLM & Agentic AI Focus
Location: Dallas, TX (Onsite)
Duration: 12 Months Contract
Only W2
8-10 years of experience as a Database/Data Engineer
Key Responsibilities
- Design, develop, and maintain scalable, high-performance database solutions.
- Lead data modelling, database design, and performance-tuning initiatives.
- Develop and optimize complex SQL/T-SQL queries, stored procedures, functions, and triggers.
- Implement and manage Role-Based Access Control (RBAC) while ensuring database security and compliance.
- Analyze and improve database internals, indexing strategies, and execution plans.
- Build and manage end-to-end 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 cross-functional teams to deliver scalable data engineering and analytics solutions.
- Develop and maintain Python-based data services, APIs, and microservices.
- Use frameworks such as DBT, FastAPI, or Django to support data transformation and service exposure.
- Integrate data platforms with LLM-based systems and agentic workflows to enable intelligent automation.
- Contribute to the design and implementation of agentic AI solutions, including orchestration, tool usage, and API interaction patterns.
Required Qualifications
Database Engineering Expertise
- 10–14 years of experience as a Database Engineer or Data Engineer.
- Strong expertise in data modelling, database design, performance tuning, optimization, advanced SQL, and T-SQL.
- Proven experience writing complex stored procedures, user-defined functions (UDFs), and triggers.
- Strong knowledge of database internals, indexing, execution plans, security models, and RBAC.
Azure Data Engineering
- 5 years of experience with Azure data platforms.
- Hands-on experience building complex pipelines and orchestrations using Azure Data Factory (ADF).
- Experience with Azure Synapse Analytics, Microsoft Fabric, data lakes, and data warehouse implementations.
- Good understanding of the Azure ecosystem, core services, and networking fundamentals such as VNets and private endpoints.
Programming and Frameworks
- Strong hands-on experience in Python for API integrations, data processing, and microservices architecture.
- Familiarity with DBT (Data Build Tool), workflow orchestration tools, and frameworks such as FastAPI or Django.
AI, LLM, and Agentic Systems
- Experience working with LLM-based interfaces and AI-powered automation workflows.
- Hands-on exposure to Claude or similar agentic coding frameworks.
- Experience designing and building agent-based solutions.
- Understanding of prompt engineering, tool orchestration, API-based LLM integrations, and autonomous or semi-autonomous workflow design.
Preferred Qualifications
- Experience implementing AI-driven data solutions.
- Exposure to MLOps or AI lifecycle management.
- Familiarity with distributed systems and event-driven architectures.
- Strong problem-solving and analytical skills.
Soft Skills
- Excellent communication and stakeholder management skills.
- Ability to work effectively in a fast-paced, collaborative environment.
- Strong attention to detail with a performance-optimization mindset.