Data Engineer
Job Type: Contract
Location: Remote (India)
We are seeking a skilled and hands-on Data Engineer for a contract engagement to build, maintain, and support our enterprise data platform within Microsoft Azure. In this role, you will work closely with Data Architects and technical leadership to construct robust, governed, and scalable data solutions.
Your core responsibilities will focus on T-SQL database development, pipeline orchestration using Azure Data Factory (ADF), building Kimball-style dimensional models, and providing production support to ensure seamless data flows for analytics and downstream business operations.
Key Responsibilities
• Database Development & Engineering: Design, build, test, and optimize Azure SQL Database artifacts—including complex queries, stored procedures, views, user-defined functions, indexes, and execution plans.
• Pipeline Orchestration & ETL/ELT: Architect, deploy, schedule, and monitor end-to-end Azure Data Factory (ADF) pipelines to ingest, transform, and move multi-source data efficiently into enterprise repositories.
• Data Warehousing & Modeling: Apply Kimball dimensional modeling principles to design, implement, and support star schemas, fact tables, dimension tables, and surrogate key management.
• Production Support & Incident Management: Serve as a key point of contact for platform support by troubleshooting pipeline failures, database performance bottlenecks, and data discrepancies. Conduct root-cause analysis and deploy permanent fixes to improve reliability.
• Data Quality & Governance: Deliver reliable, auditable, and secure datasets for business intelligence and reporting while adhering to corporate data governance policies.
• Technical Documentation & Collaboration: Create detailed source-to-target mappings, system diagrams, runbooks, and operational guides. Partner with cross-functional stakeholders and team members to refine data requirements and technical specifications.
• Quality Assurance & Standa
📌 Data Engineer (India)
🏢 Sesheng
📍 India