Lead Data Engineer

Sutherland is seeking an analytical person to join us as an Associate Profession - BI Analyst to be responsible for reporting and providing insights from the data. We are a group of dynamic and driven individuals. If you are looking to build a fulfilling career and are confident you have the skills and experience to help us succeed, we want to work with you! 

TheLead BI Engineer will be responsible for architecting, developing, and optimizing enterprise-scale business intelligence solutions. This role requires deep expertise inPower BI, Azure, Databricks, and SQL, with the ability to design scalable data pipelines, deliver advanced analytics, and drive BI adoption across the organization. The ideal candidate combines strong technical skills with leadership capabilities, guiding teams and collaborating with stakeholders to enable data-driven decision-making.

Key Responsibilities

Data Engineering & Pipeline Development

• Design and implementdata ingestion pipelines from multiple sources usingAzure Databricks.
• Develop scalable and reusable frameworks for ingesting and transforming datasets.
• Integrate end-to-end data pipelines ensuringdata quality, consistency, and governance.
• Work with event-based/streaming technologies for real-time data ingestion and processing.
• Optimize Databricks code and performperformance tuning for large-scale workloads.

SQL Development & Optimization

• Strong expertise inSQL, T-SQL, and PL/SQL with hands-on experience inSQL Server.
• Write, analyze, and optimize complex SQL queries includingstored procedures, functions, triggers, joins, updates, and constraints.
• Deep knowledge ofSQL architecture: Agent Jobs, Indexes, Partitions, Views, and Procedures.
• Proven ability to design high-performance queries and implement best practices for SQL optimization.

BI & Visualization

• Lead the design and development ofPower BI dashboards, reports, and KPI scorecards.
• Proficient inDAX, advanced calculations, and data modeling aligned with warehouse standards.
• Collaborate with business stakeholders to translate requirements into actionable BI solutions.
• Champion BI adoption and foster a culture ofdata-driven decision-making.

Cloud & Infrastructure

• Design and deploydata applications on Azure cloud solutions (Synapse, Data Lake, SQL DB, Blob Storage).
• Hands-on experience withAzure Data Factory, Azure Functions, and Azure DevOps for automation and orchestration.
• Provision and manageDatabricks clusters, including scheduling and job automation.
• Familiarity with AWS/GCP integration where applicable.

Advanced Analytics & Development

• Experience withPySpark and Python for data processing and advanced analytics.
• Hands-on experience withSpark SQL, Spark Streaming, Delta Lake, and Scala/Python notebooks.
• Develop proofs of concept (POCs) and prototypes with customer teams.
• Implement transformational big data projects, includingreal-time streaming using Databricks.

Desired Skills

• Strong problem-solving, interpersonal, and communication skills.
• Self-starter with the ability to adapt to newAzure services in the analytics space.
• Provide technical leadership and mentor junior engineers.
• Collaborate with delivery leadership to ensure project delivery adheres to quality standards.

willing to work in UK shift