Senior Consultant (Databricks Engineer)

Job Description·      The Data Engineer will be the backbone of our data-driven ecosystem, responsible for designing, developing, and maintaining scalable, reliable data pipelines on Databricks and leading cloud platforms. ·      You will bridge the gap between raw data sources and actionable insights by integrating diverse data sets, ensuring pristine data quality, and powering analytics, reporting, and machine learning workloads. ·      You will work at the intersection of Analytics, Product, and Infrastructure, collaborating with cross-functional teams to elevate our data platform while championing best practices for governance, monitoring, and system reliability. What You Will Do ·      Pipeline Engineering & Development·      Develop and maintain robust ETL/ELT pipelines for centralized storage solutions (e.g., Delta Lake)·       Integrate data from a variety of sources: relational databases, REST APIs, log files, streaming platforms, and external vendors. ·      Build sophisticated transformation routines to cleanse, normalize, aggregate, and enrich raw datasets. ·      Apply advanced data processing techniques to handle complex, nested, or inconsistent data structures. ·      Architecture & Governance Contribute to internal frameworks and best practices for code development, versioning, and deployment. ·      Implement robust data governance policies (access control, lineage, retention) aligned with enterprise standards. ·      Partner with infrastructure leaders to advance our cloud-native data platforms (Azure, AWS). ·      Explore and pilot new tools and technologies leveraging Azure, Databricks, and related ecosystems. ·      Analytics & Business Collaboration Partner with Analytics and Product leaders to translate business requirements into operationalized pipelines. ·      Attend requirement grooming, refinement, and sprint planning sessions with end-users. ·      Develop dashboards, reports, scorecards, and data visualizations to drive business intelligence. ·      Perform rigorous SIT, data profiling, and data validation to confirm accuracy and integrity. ·      Monitoring & Reliability Monitor production pipelines to detect, diagnose, and resolve issues promptly. ·      Develop monitoring dashboards, alerting systems, and automated error-handling mechanisms. ·      Optimize performance, batch scheduling, and resource utilization across the data stack.·      Validate the completeness and consistency of ETL loads during UAT and production rollouts. Qualifications & Required skills ·      3+ years of hands-on experience in data engineering, building large-scale, high-performance data pipelines.·       Strong experience designing data solutions, including data modeling, normalization, and distributed computing architectures. ·      Extensive hands-on coding with PySpark, Spark SQL, and Databricks Notebooks/Jobs. ·      Proficiency in orchestrating pipelines using Azure Data Factory (ADF), Apache Airflow, or similar schedulers. ·      Proven experience with both real-time (streaming) and batch processing paradigms. ·      Solid experience building pipelines on Azure (with AWS knowledge being a significant plus). ·      High-level proficiency in SQL, including window functions, CTEs, and performance tuning. ·      Strong understanding of DevOps tools, Git workflows, and CI/CD pipelines. ·      Familiarity with Scrum methodology and practical experience working within cross-functional Scrum teams. ·      Excellent problem-solving skills and a collaborative mindset. ·       Hands-on experience with streaming technologies such as Apache Kafka, Apache Flink, or AWS Kinesis. ·      Proven ability to design and implement real-time data processing pipelines. ·      Databricks Certified Data Engineer Associate (preferred). ·      Databricks Certified Data Engineer Professional (highly preferred).