ETL Data Architect (Databricks, Kimball, Power BI, MS Fabric)

Position: ETL Data Architect (Databricks, Kimball, Power BI, MS Fabric)
Experience: 8-15 years Category: Software Development/ Engineering Shift Timing: 12:00 PM to 10:00 PM Location: Chennai /Bangalore/Hyderabad/Pune/Mumbai Position ID: J1125-1340 Employment Type: Full Time

Education Qualification: Bachelors degree in computer science or related field or higher with minimum 7 years of relevant experience.

The ETL Data Architect will be responsible for designing, developing, and implementing robust and scalable data architectures and ETL solutions. This role requires deep expertise in Databricks for data processing and Lakehouse architecture, Kimball dimensional modelling for data warehousing, and Power BI and Microsoft Fabric for data visualization and analytics platform implementation. . As an ETL Architect, you will lead the design and implementation of scalable, secure, and high-performance data solutions using the Databricks Lakehouse Platform. You will define architectural standards, guide engineering teams, and collaborate with stakeholders to align data strategies with business goals. Your role will focus on leveraging Databricks' unified analytics capabilities to build enterprise-grade data platforms that support advanced analytics, machine learning, and real-time data processing.

Your future duties and responsibilities
Define and own the end-to-end architecture of data platforms built on Databricks, including ingestion, transformation, storage, and consumption layers. . Develop and maintain data models, data flow diagrams, and other architectural documentation based on Kimball dimensional modelling principles. . Design and implement end-to-end data architectures leveraging Microsoft Fabric's capabilities ( Embedded Power BI integration/ implementation). . Design and implement Lakehouse architectures using Delta Lake, Unity Catalog, and structured streaming. . Proven expertise in implementing data governance using Unity Catalog, including fine-grained access control, column-level lineage, data classification, audit logging, and centralized metadata management across workspaces and cloud environments . Architect scalable ETL/ELT pipelines using Apache Spark, PySpark, and Databricks Workflows. . Lead the integration of Databricks with enterprise systems such as data catalogs, data quality frameworks, ML platforms, and BI tools. . Lead the Design and development of high-performance reporting models and paginated reports, configurable inquiries and interactive dashboards using Power BI. . Guide teams in implementing CI/CD pipelines, version control, and automated testing for Databricks notebooks and jobs. . Collaborate with data scientists, engineers, and business stakeholders to support ML model lifecycle management using MLflow. . Demonstrated experience or familiarity with AI systems such as Databricks DBRX, Mosaic AI, and AutoML, including their integration into data. . Provide technical leadership in performance tuning, cost optimization, and cluster configuration. . Conduct architectural reviews, code audits, and mentoring sessions to ensure adherence to standards and scalability. . Provide technical leadership and guidance to data engineers and developers. . Collaborate closely with clients, business stakeholders, and internal teams to translate business requirements into technical solutions. . Stay current with Databricks innovations and advocate for adoption of new features and capabilities.

Required qualifications to be successful in this role
Must to have Skills-

8+ years of experience in data architecture and engineering, with 5+ years in Databricks and Apache Spark. Strong proficiency in SQL & DAX
. Experience of migrating Snowflake and other custom EDW/ ETL solutions to Databricks. . Experience of migrating different reporting solutions like Cognos, SAP BO etc to Power BI and Databricks. . Deep knowledge and practical experience with Kimball dimensional modelling and data warehousing concepts and temporal data structures. . Expertise in designing and deploying ETL/ELT pipelines for large-scale data integration. . Proficiency in Power BI for paginated report and dashboard development, including DAX. . Deep expertise in Delta Lake, structured streaming, PySpark, and SQL. . Strong understanding of Lakehouse architecture, data mesh, and modern data stack principles. . Experience with Unity Catalog, Databricks Repos, Jobs API, and Workflows. . Proven ability to design and implement secure, governed, and highly available data platforms. . Familiarity with cloud platforms (Azure, AWS, GCP) and their integration with Databricks. . Experience with CI/CD, DevOps, and infrastructure-as-code tools (Terraform, GitHub Actions, Azure DevOps). . Knowledge of machine learning lifecycle, MLflow, and model deployment strategies. . An understanding of E-R data models (conceptual, logical, and physical). . Understanding of advanced data warehouse concepts is required . Strong analytical skills, including a thorough understanding of how to interpret customer business requirements and translate them into technical designs and solutions. . Strong communication skills both verbal and written. Capable of collaborating effectively across a variety of IT and Business groups, across regions, roles and able to interact effectively with all levels. . Strong problem-solving skills. Ability to identify where focus is needed and bring clarity to business objectives, requirements, and priorities.

Good to have skills-

Experience in working with US clients
. Agile Delivery experience and process awareness. Familiarity of working with Jira and/or Azure DevOps. . Microsoft Azure certifications related to Data Engineering or Data Architecture. . US Govt sector Finance or HRM or Budget ERP application experience.