Senior Data Engineer (AI & LLM Solutions)

Senior Data Engineer (AI & LLM Solutions) Location: Remote(Pakistan, Mexico, India, Morocco) Department: Digital Solutions / Data Engineering & AI Reports To: Technical Lead / Director Job Type: Full-time About AIM Architecture in Motion Inc. (AIM) is a Canadian technology consulting firm that supports organizations across public and private sectors with software engineering, cloud platforms, API integration, data engineering, and enterprise technology solutions. We specialize in delivering scalable, secure, and modern digital solutions leveraging Microsoft technologies, helping our clients drive operational efficiency, data modernization, and digital transformation. Role Overview AIM is seeking a Senior Data Engineer (AI & LLM Solutions) to design, develop, and optimize modern data platforms that support analytics, artificial intelligence, machine learning, and Generative AI solutions. This is a hands-on senior role requiring strong expertise in Microsoft Fabric, Azure Data Services, Azure Databricks, Python, PySpark, and enterprise data architecture, along with practical experience supporting AI and LLM initiatives. The ideal candidate will build scalable and secure data solutions while enabling advanced AI capabilities, including Retrieval-Augmented Generation (RAG), vector search, Azure OpenAI, Copilot, and enterprise LLM solutions. The successful candidate will work closely with Solution Architects, AI Engineers, Cloud Engineers, Data Scientists, and client stakeholders to deliver secure, scalable, and business-driven data platforms. Key Responsibilities Modern Data Platform Development Design and develop enterprise-scale data solutions using Microsoft Fabric, Azure Data Factory, Azure Synapse Analytics, Azure Data Lake Storage, and Azure Databricks. Build and optimize scalable ETL/ELT pipelines for structured, semi-structured, and unstructured data. Develop modern Lakehouse, Data Warehouse, and Medallion Architecture solutions. Design and implement batch and real-time data processing frameworks. Lead data modernization, migration, and integration initiatives from legacy platforms. AI, LLM & Data Enablement Develop data foundations that support AI, Machine Learning, and Generative AI solutions. Prepare, transform, and optimize datasets for AI applications, model training, and fine-tuning. Design and implement Retrieval-Augmented Generation (RAG) architectures and vector search solutions. Support Azure OpenAI, Microsoft Copilot, and enterprise LLM implementations. Develop data pipelines and architectures that enable AI-driven applications. Collaborate with Data Scientists and AI Engineers to operationalize AI and machine learning solutions. Advanced Data Engineering Build distributed data processing solutions using PySpark and Spark SQL. Develop automated data integration frameworks connecting APIs, SaaS applications, databases, and cloud services. Design reusable data engineering frameworks, components, and standards. Optimize large-scale workloads for performance, scalability, reliability, and cost efficiency. Implement data quality, validation, monitoring, and error-handling processes. Data Governance & Security Implement data governance and cataloging solutions using Microsoft Purview and related technologies. Establish and maintain data lineage, classification, cataloging, and access controls. Ensure data platforms align with enterprise security, privacy, and compliance requirements. Support governance and security requirements across frameworks such as SOC 2, NIST, and CMMC. Implement secure data access and protection practices across cloud data platforms. Reporting & Analytics Support Design and support semantic data models for Power BI and enterprise analytics. Enable self-service analytics while maintaining appropriate governance and data quality standards. Support KPI frameworks, executive dashboards, reporting, and predictive analytics initiatives. Collaborate with analytics teams to ensure reliable and high-quality data availability. Technical Leadership & Collaboration Provide technical guidance and mentorship to junior and mid-level data engineers. Participate in solution architecture, technical design reviews, and implementation planning. Work directly with clients and stakeholders to understand requirements and translate business needs into scalable technical solutions. Collaborate with cross-functional teams including AI Engineers, Cloud Engineers, Solution Architects, Data Scientists, and Business Analysts. Participate in technical discussions and presales activities where required. Develop technical documentation, engineering standards, and reusable implementation patterns. Support & Continuous Improvement Troubleshoot and resolve data pipeline, platform, and integration issues. Monitor and optimize data workloads and cloud resources. Support enhancements, upgrades, and ongoing maintenance of data platforms. Identify opportunities to improve data quality, automation, performance, and operational efficiency. Stay current with emerging technologies in Microsoft Fabric, Azure, AI, Generative AI, and data engineering. Required Qualifications Education Bachelor’s degree in Computer Science, Software Engineering, Information Technology, Data Science, or a related discipline. Experience 8+ years of professional experience in Data Engineering, Data Platforms, or Cloud Data Solutions. 5+ years of hands-on experience with Microsoft Azure Data Services. Proven experience delivering enterprise-scale data, analytics, and AI solutions. Strong experience working with modern cloud data platforms and data architectures. Experience working within consulting, professional services, or enterprise environments. Strong communication, stakeholder management, and problem-solving skills. Technical Skills Data Platform Technologies Microsoft Fabric Azure Data Factory (ADF) Azure Synapse Analytics Azure Data Lake Storage Gen2 (ADLS) Azure Databricks Azure Event Hubs Data Warehouse & Lakehouse Architecture Medallion Architecture Programming & Data Processing Python SQL PySpark Spark SQL Kusto Query Language (KQL) REST API integrations ETL/ELT development Databases SQL Server PostgreSQL MySQL NoSQL databases Data modeling and optimization AI & Machine Learning Azure OpenAI Generative AI Prompt Engineering Retrieval-Augmented Generation (RAG) Vector Databases / Vector Search Machine Learning Pipelines NLP fundamentals LLM integration patterns AI-ready data architecture Analytics & Visualization Power BI Tableau Semantic Models Executive Reporting KPI Frameworks Governance & Security Microsoft Purview Data Governance Data Classification Data Lineage Data Cataloging Access Control Enterprise Security Standards SOC 2, NIST, and CMMC awareness DevOps & Cloud Engineering Azure DevOps Git CI/CD Pipelines Infrastructure as Code concepts Containerization concepts Cloud resource optimization Core Competencies Strong analytical and problem-solving skills Ability to design and implement scalable data solutions Strong understanding of enterprise data architecture Ability to work independently in a remote and cross-functional environment Strong communication and stakeholder management skills Ability to mentor engineers and provide technical leadership Strong focus on security, quality, performance, and reliability Ability to translate business requirements into technical solutions Preferred Certifications Microsoft Certified: Fabric Analytics Engineer Associate Microsoft Certified: Azure Data Engineer Associate Microsoft Certified: Azure Data Scientist Associate Microsoft Certified: Azure Solutions Architect Expert Databricks Certified Data Engineer Relevant AI, Machine Learning, or Generative AI certifications What We Offer Remote-first work environment Opportunity to work on enterprise-scale Microsoft Fabric and Azure data platfo