Consultant - Data & AI

Primary Job Role Fortude is looking for a talented, self-driven Consultant who has a passion for data to join our dynamic, dedicated analytics team. You will be involved in design, development and implementation of data engineering solutions that feed into the analytics solutions we provide our customers across multiple geographies.

Main Duties And Responsibilities

• Design, develop, and maintain scalable end-to-end data pipelines integrating multiple source systems into modern data platforms.
• Develop and curate data across Bronze, Silver, and Gold layers, ensuring accuracy, completeness, traceability, and alignment with business requirements.
• Contribute to the design and implementation of data warehouses and lakehouses, including data integration, orchestration, dimensional models, and analytical data assets.
• Build and optimize data transformations using SQL, Spark SQL, PySpark, and related engineering frameworks.
• Develop semantic models and analytics-ready datasets in Microsoft Fabric and Power BI to enable efficient reporting and self-service analytics.
• Apply data quality, governance, security, validation, and reconciliation controls across data pipelines and curated assets.
• Collaborate with functional, BI, engineering, and client stakeholders to clarify requirements and translate them into practical technical solutions.
• Own assigned workstreams, provide accurate delivery estimates, identify risks and dependencies, and contribute to project planning and technical documentation.
• Review deliverables, support junior team members through technical guidance, and contribute to reusable standards and engineering best practices.
• Monitor, troubleshoot, and optimize solution performance, and support testing, deployment, production stabilization, and incident resolution.

Education & Experience

• Bachelor’s degree in Data Science, Computer Science, Engineering, Information Systems, Analytics, or a related discipline.
• Minimum 4 years of relevant post-qualification experience in Data Engineering.
• Two or more of the following certifications
• Microsoft Certified: Azure Enterprise Data Analyst Associate
• Microsoft Certified: Power BI Data Analyst Associate
• Databricks: Lakehouse Data Engineer Associate
• Microsoft Certified: Fabric Data Engineer Associate
• Microsoft Certified: Fabric Analytics Engineer Associate
• Microsoft Certified: Azure Databricks Data Engineer Associate

Core Skills & Qualifications

• Advanced SQL expertise with strong analytical and problem-solving capabilities, including complex query optimization and performance tuning.
• Hands-on experience with Spark SQL and PySpark for distributed data processing and production-grade data engineering.
• Strong understanding of ETL/ELT frameworks, dimensional modeling, medallion architecture and modern data warehousing and lakehouse concepts.
• Practical experience designing, developing, and maintaining data pipelines using Databricks, Microsoft Fabric, Azure Data Factory, Synapse Analytics, or similar platforms.
• Experience with Microsoft Fabric components such as Data Factory, Lakehouse, Warehouse, notebooks, semantic models, and OneLake is preferred.
• Working knowledge of Power BI and DAX, with an understanding of end-to-end BI and analytics solution delivery.
• Ability to interpret business requirements, contribute to solution design, and independently deliver well-tested technical components.

Added Advantages

• Prior experience in apparel, manufacturing, retail, supply chain, or other domain-driven analytics environments.
• Experience with Change Data Capture, incremental processing, streaming, or near-real-time data integration patterns.
• Exposure to SQL Server-based data warehousing, including Integration Services and Analysis Services.
• Knowledge of data governance, security frameworks, metadata management, observability, and cost or performance optimization.

Behavioral Competencies

• Communication
• Teamwork
• Digital Mindset
• Operational Excellence
• Analytical Ability
• Customer Centricity
• Business and Market Acumen
• Empathy
• Growth Mindset

Equal Opportunity Employer Everyone can grow at Fortude; regardless of their identity. Join us, and be a part of an organization, where we’re all proud to belong.